Recommend a data design proposal

Recommend a data design proposal

In academic research, creating a database that enables the capture of  qualitative and or quantitative data, as gathered by primary or  secondary data sources, is key to successful analysis of hypotheses.

For this week’s assignment, you must create a database in MySQL for  purposes of academic research. You are free to use ideas that may be  flowing related to your planned dissertation research or another area of  data collection to solve for another problem statement of interest. You  will create a technical design specification that will include  screenshots of your created MySQL database, your entity-relationship  diagram, and a detailed description of what you are solving for. You are  permitted to build off of the database created in earlier weeks, or  you may start with a new research topic of interest. If you build off  of the previously created database, you must add significantly to the  previous design to address new analytic issues.

Your database design and document should include the following:

• Research problem statement – includes citations to the literature in support of any assertions or facts presented
• Stakeholder analysis – identifies who cares about this research, or  who will weigh in on future use of the database and/or insights the data  can provide
• Endpoint discussion – includes intended use of the database and any  insights planned to be achieved by the design and the data to be housed  in the schema; includes citations to the literature for any assertions  or statements of facts presented
• Technical design – includes screenshots and/or descriptions of all  tables, fields, and description of the data contained in the fields  (metadata (i.e., field data types), and example data contained with each  field)
• At least 8 tables – 8 new tables, if building off your previously  developed assignment database), with no orphaned tables (i.e., no tables  that do not relate to at least one other table in the schema); each  table should have no less than 2 fields and no more than 8 fields
• Entity-relationship diagram, with cardinality – includes showing the nature of relationships between related tables

Length: 5-10 pages, not including title page

References: Include a minimum of 3 scholarly resources.

The completed assignment should address all of the assignment  requirements, exhibit evidence of concept knowledge, and demonstrate  thoughtful consideration of the content presented in the course.