Entity Relationship Modelling Design and draw an Entity Relationship Diagram for the scenario described below. You must use the 'crows foot' style of notation described in the class notes. Your diagram should only contain entities and relationships at this time, not attributes. Relationships should be labelled, like this: places Customer * Order Note that the triangle makes it clear that "Customer places Order", and not "Order places Customer"! There cannot be any many-to-many relationships in your diagram - if you derive such a relationship, then analyze deeper to remove it. You may need to create additional entities to achieve that. Scenario: Expert Witnesses The Nofunland and Laughnomore Public Prosecutions Department (NLPPD) maintains a list of expert witnesses who can provide testimony in court cases. People who are experts in fields such as forensics, ballistics, financial transactions, things like that. Here are some useful things to know: Each expert can be an expert one or moi fields. Each field has one or more experts. Each field has exactly one "leading expert", considered to be the most knowledgable in that field. Each expert can be the leading expert in several fields, but they might not be the leading expert in any field. . NLPPD operates in several courts. Each expert can cover one or more courts. Each court has one or more experts available for cover. Each case is heard in a single court. Courts can hear several cases (it would be very silly if we built a court to hear just one case!) Each expert attends zero or more court cases to provide testimony (some might never be needed). Each court case requires zero or more experts to attend (some cases don't need expert witnesses to attend). Entity Relationship Modelling Design and draw an Entity Relationship Diagram for the scenario described below. You must use the 'crows foot' style of notation described in the class notes. Your diagram should only contain entities and relationships at this time, not attributes. Relationships should be labelled, like this: places Customer * Order Note that the triangle makes it clear that "Customer places Order", and not "Order places Customer"! There cannot be any many-to-many relationships in your diagram - if you derive such a relationship, then analyze deeper to remove it. You may need to create additional entities to achieve that. Scenario: Expert Witnesses The Nofunland and Laughnomore Public Prosecutions Department (NLPPD) maintains a list of expert witnesses who can provide testimony in court cases. People who are experts in fields such as forensics, ballistics, financial transactions, things like that. Here are some useful things to know: Each expert can be an expert one or moi fields. Each field has one or more experts. Each field has exactly one "leading expert", considered to be the most knowledgable in that field. Each expert can be the leading expert in several fields, but they might not be the leading expert in any field. . NLPPD operates in several courts. Each expert can cover one or more courts. Each court has one or more experts available for cover. Each case is heard in a single court. Courts can hear several cases (it would be very silly if we built a court to hear just one case!) Each expert attends zero or more court cases to provide testimony (some might never be needed). Each court case requires zero or more experts to attend (some cases don't need expert witnesses to attend)
