Question: Using SQL Developer, create an ER Diagram representing the invoices below.
Normalize the schema.
- Engineer a relational schema from the ER diagram (Logical Model).
- Generate the DDL for the schema.
- Execute the DDL in SQL Developer to create the database.
- Populate the tables with data taken from the invoices.
Develop SQL to answer these two queries:
- How many parts did Jim Shoe purchase in November, 2006?
- What was the total amount of all purchases by Speed Racer?