1. A detailed schema using the ER model including:

• Design a corresponding set of tables that are in at least 3NF.

• List of the attributes for each entity and relationship.

• Explanations of the non-obvious entities and relationships.

2. Provide DDL including:

CREATE tables.

3. Construct the following queries and provide results:

A) Populate (INSERT Statements) tables with some data.

B) Show customer details i.e., customer information and address (pick any)?

C) Show all Products that are below 50 quantity.

D) Show all orders of a customer (pick any)?