Create-an-Entity-Relationship-UML-Notations-Database-Problem-help
Please See Attachment:
1. Create an Entity Relationship (UML Notations)
2. Logical Model (Relational Schema) including Primary and Foreign Keys
3. Ensure RM is in 3NF
Can you also build a DBMS based on the Logical Schema?
ï‚· Make sure that your primary keys are assigned in each table.
ï‚· Verify that all of your fields are assigned an appropriate data type.
ï‚· Verify that all of your fields are assigned an appropriate field length.
 Use default values where appropriate (i.e. default for “OrderDate†as today’s date).
ï‚· Insert 2-3 rows of data in each table. You make up the data