Design Entity Relationship Diagram

[KerryK2021]

Description Create an entity relationship diagram to show database structure and relationships between entities.

• Identify entities
• Define attributes for each entity
• Define relationships between entities

AC

• Ensure entities are identified and shown
• Ensure attributes are defined for each entity, including the data type
• Ensure relationships are specified

[KerryK2021]

• Users -> Appointments 1:M
• Appointments -> Users / Plumbers / Services / Appointment_Status M:1
• Plumbers -> Appointments 1:M
• Services -> Appointments 1:M
• Appointment_Status -> Appointments 1:M
• Payment -> Appointments 1:1
• Availability -> Plumbers 1:M

[KerryK2021]