Question description
Please See Attachment:1. Create an Entity Relationship (UML Notations) 2. Logical Model (Relational Schema) including Primary and Foreign Keys3. Ensure RM is in 3NFCan you also build a DBMS based on the Logical Schema?Ensure it includes the following: 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
