Answer Happy

customer_details V CUS_CODE VARCHAR(50) CUS LNAME VARCHAR(50) CUS_ZIP VARCHAR(50) AGENT CODE VARCHAR(50) Indexes agent_details AGENT_CODE VARCHAR(50) AGENT PHONE VARCHAR(50) Indexes AGENT CODE AGENT PHONE 6152439887 1265487878 48798765423 15789485423 14657864165 1234S 5 CUSTOMER DETAILS: CUS_CODE CUS_LNAME Admin1 Liza hyden Andmu 101 102 103 104 105 106 107 108 109 Akjfo Akjdi Lis Any Franc CUS_ZIP AGENT_CODE 12345 2 32654 2 56578 5 894562 3 56478 4 98653 2 45213 3 65897 1 25643 4
Assignment 6 (40 points) 1. Use the tables that you have created for Assignment 5 and create an ERD diagram. Use the following figures for reference. (4-10, 4-13, 4-20). Make sure you use the Crow's foot notation and include the attributes. All many to many (N:M) diagrams should be broken down into Associative entities. 2. Use the normalized tables (end product of Assignment 3) of Assignment 3 and create an ERD diagram. Use the Crow's foot notation and include the attributes. Hint: Remember to use the normalized tables that you have created with primary keys and foreign keys. All many to many (N:M) diagrams should be broken down into Associative entities. Tips: You can use the Workbench to create your diagram Please submit the screenshot of the ERD diagram and also the actual files. Please include your name on the diagram.
Figure 4.10 Example Relationships SUPPLIER SUPPLIER- QUOTATION QUOTATION MOTHER CHILD FATHER PARENT
Figure 4.13 Two Versions of a 1:N O-M Relationship DEPARTMENT O DEPARTMENT HO 1:N Minimum cardinality (O-M) Maximum cardinality (1:N) EMPLOYEE EMPLOYEE
Figure 4.20 Example Subtype Entities STUDENT StudentID STUDENT StudentID LastName FirstName isGradStudent UNDERGRADUATE StudentID HighSchoolGPA ScoreOnSAT isGradStudent GRADUATE StudentID UndergraduateGPA ScoreOnGMAT HIKING CLUB StudentID LastName FirstName DateDuesPaid AmountPaid SAILING CLUB StudentID DateDuesPaid AmountPaid