Creating and Normalizing a Database Schema with Queries

Part 1: ER Diagram

Create an ER diagram for a newly normalized database schema.

If you create the ER diagram using other tools, please take screen capture of the ER diagram, and pasted under Part 1.

Take John’s data and normalize it.

Please take screen capture of the normalized data tables here.

Alternatively, you can put the normalized table in the excel worksheet with a title of Part 2.

Now that the data is normalized, it takes a bit more work to compile data. Some queries John needs created are: •

List all order numbers, dates, and totals for a supplied customer.