4.2 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.
4.2 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.
Legal system – business rules:
• In the legal system, a judge hears many cases throughout their career.
• Each case can be heard by multiple judges in some circumstances.
• A case has a date and title that needs to be recorded in the
• The name and surname of each judge needs to be stored.
• A judge can have multiple qualifications (with minimum of one), and each
qualification is related to only one specific judge.
• For a qualification, the institution, description and year completed should
be recorded.
• A case is defended by a single lawyer, but a lawyer can defend many cases
in their career.
• The name and surname for each lawyer needs to be stored in the database
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images