Determine and describe the factors necessary to ensure referential integrity in the database
Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
using MySQL Workbench to describe and reflect upon your work in a paper that describes the process for developing insights. This is the essence of creating analytic horsepower from data.
Based on the scenario above, be sure your paper addresses the following:
Include your problem statement, statement of significance for solving this problem to the literature or industry.
Identify your process for database design and indicate which facets you determined were needed to develop the endpoint insights and thus reflected in the tables and fields you created.
Determine and describe the factors necessary to ensure referential integrity in the database.
Discuss what future research or industry problems could be solved from the existing schema with the addition of additional tables from other data sources (cite your assumptions and references to the literature).
Describe any assumptions or limitations for each relationship between attributes in your schema.
Create an ER diagram (schema) in MySQL Workbench. Take a screenshot of the full schema diagram. Label your screenshots when you paste them into your document.
Export your database to your computer. Be sure and select the option to “Export to Self-Contained File.”
Include a standard title page at the beginning of your document.
Submit your database file and your paper to the assignment Dropbox.
Length: 10-12 pages, not including title page
References: Include a minimum of 3 scholarly resources.