Database Debrief.
Referencing the two database schema attached, document the following:
- An explanation of the schema selected to develop the database, including:
- A summary of any schema discrepancies you found and how you resolved them
- The process and considerations you used to select the best schema for the database
- The strategy you used to optimize and incorporate best practices into the SQL used to develop the databases, including strengths and weaknesses of the techniques you used
- The strategy used to transform from one schema to another
- The challenges encountered while preparing the data for analysis
- The strategy used to clean the data
- The tools you selected for integrating various database elements, including the strengths and weaknesses of these tools
- Screenshots, diagrams, and other images as needed to support your summary
- Practices you will replicate or avoid in similar projects based on your experiences with this project
Present your summary as A 5 page Microsoft® Word document
-
Database_1.vsd
-
Database_2.mwb