Use the entities below to create a UML class diagram. Include all one-to-many re

Question

Use the entities below to create a UML class diagram. Include all one-to-many relationships in the diagram with matching primary and foreign keys in the attribute list of the entities linked by each relationship.

Certification incident responce Employess Vehicle fire sation Certification ID (PK) High-rise toxic-waste level 2-DIL emt Employee iD (FK) emt-2 paramedic Last name firts name Branch ID (PK) name location phone Branch NAme (FK) ID (PK Report ID (PK) date address depart return details Vehicle ID (FK) Branch ID (FK) Employee ID (PK) Firstname last name address DOB address Ssn pay rate certifications ID (FK) milage accidents maintainace Level 2- DL (FK)

Explanation / Answer

Entity 1(PK) - Entity 2(PK): Cardinality

Employees(EmployeeID) - Certification(EmployeeID): 1 to Many

Vehicle(ID) - incidence response(Vehicle ID) : 1 to Many

fire station(Branch ID) - Incidence response(Branch ID) : 1 to Many

Certifications(Certification ID) - Employees(certifications ID): 1 to Many

Certification(Level 2-DL) - Vehicle(Level 2-DL): 1 to Many

fireStation(name) - fire station(Branch Name) : 1 to Many

Here Last two are violating regarding to foreign key constraint. according to foreign key rule references attribute must be primary key

Let me know if you have any clarifications. Thank you...

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.