Home /
Expert Answers /
Computer Science /
question-4-marks-25-draw-an-entity-relationship-diagram-erd-using-unified-modelling-language-pa719
(Solved): Question 4 (Marks: 25) Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language ( ...
Question 4 (Marks: 25) Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level-include primary and foreign key fields, and remember to remove any many-to-many relationships. Tip: Pay attention to the mark allocation shown below. - Each owner owns one or more cats, and every cat has exactly one owner. - The name and surname of each owner must be stored in the database. - The name of each cat must be stored in the database. - Each cat belongs to one specific breed, and many cats can belong to the same breed. - The description of each breed must be stored in the database. - A cat can enter many competitions, and many cats can enter the same competition. - The description of each competition must be stored in the database. Tip: Pay attention to the mark allocation shown below.