Task in this part is to, given an E-R diagram, identify the entities, attributes, keys, and relationships in the E-R model, and generate a corresponding formal written description in the format discussed in class.
Your tasks are:
ER diagram attached.
1. Given the E-R diagram on the following page, list the names of the entities, attributes, keys and relationships being used.
2. For each entity, give a formal written description, including all of its attributes and its key.
3. For each relationship, give a formal written description of both directions of the relationship, including its cardinality.
Submit a single document containing your written answers as your solution.
Reading: Bagui & Earp Ch 1. (pp. 1-8), Ch2 (pp. 23-42), Ch. 3 (pp. 53-63) and Ch. 4 (pp. 73-78)
Ch. 1 (pp. 1-8) The software Engineering Process and Relational Databases â€“ stop at â€œThe Relational Model.â€œ
Ch. 2 (pp.23-42) The Basic ER Diagram: A Data Modeling Schema â€“ stop at â€œER Design Methodologyâ€ (the one with examples, after â€œMore about Attributesâ€ section.
Ch. 3 (pp.53-63) Beyond the First Entity Diagram â€“ stop at â€œChapter Summary.â€
Ch. 4 (pp.73-78) Extending Relationships/Structural Constraints â€“ stop at â€œMany-to-Many (M:N).â€
Reading using Bagui & Earp 2nd Edition:Ch1. (pp. 1-8), Ch2. (pp. 20-32), Ch4. (pp. 67-80), Ch5. (pp. 101-111), Ch6. (123-128).
Note:It requires to submit a file.