omework Your deliverable for this homework is a Visio file (.vsd) that provides the ER-Diagram for the following two cases. Identify all entity types, attributes, relationship types and their degrees in the following cases. Then draw an entity-relationship diagram for each case. Depict the E-R diagram for each case in a separate tab in the same Visio file. The E-R diagram should specify the entities, cardinalities, relationship labels, and attributes. Each entity should specify at least two attributes. Each entity should have at least one identifier attribute (primary key) Case 1: An organization makes many models of cars, where a model is characterized by a model number, name, and an engine size. Each model is made up from many parts and each part may be used in the manufacture of more than one model. Each part has a part id and a description. Each model of car is produced at just one of the firm's factories. A factory produces many models of car and many types of part although each type of part is produced at one factory only Case 2: A member may hold a number of investment accounts. Each member is characterized by a membership number, name and address. Each investment account is associated with the branch where it is handled. Any branch handles many investment accounts. A member may also have one mortgage account. All mortgage accounts are associated with an office, and an office can handle multiple mortgage accounts. Deliverable: Submit just the MS Visio file containing two tabs. Name your file using the "lastname firstname.vsd" form. For example, my file would be "Saldanha_Terence.vsd". Attach your file into Blackboard itself while submitting your Assignment. Due Date:_The due date for this assignment is Friday November 17t (11:59pm. The following will be the rubric that will be used to grade the homework. Pts Pts Possible Rcvd Description Comments File naming convention followed Tabs labeled with situation number Completeness of the E-R diagram for Case 1 Appropriateness of the attributes for each entity of the E-R diagram for Situation 1. Create at least two attributes for each entity Appropriateness of the relationship labels (e.g., produces/is produced by") for each entity of the E-R diagram for Case 1. At least one identifier (primary kev) should be specified for each entit Appropriateness of the cardinalities of the E-R diagram for Case 1 1. 2. 3. 4. 10 5. 6. 7. Completeness of the E-R diagram for Case 2 Appropriateness of the attributes for each entity of the E-R diagram for Case 2. Create at least two attributes for each entity. At least one identifier (primary kev) should be specified for each enti 10 8. 10 9. Appropriateness of the relationship labels (e.g., "handles/is handled 10 by") for each entity of the E-R diagram for Case 2 10. Appropriateness of the cardinalities of the E-R diagram for Case2 11. Total 90
