Assignment 1.docx - 19F-CST8215 u2013 Database Assignment...

This preview shows page 1 - 2 out of 2 pages.

19F-CST8215 – Database Assignment 1 Step 1: Draw the first draft of the ERD Step 2: Identify the many-to-many relationship Tenant Office Step 3: Resolve M:N relationship Landlord Step 4: Draw the second draft of the ERD Step 5: Identify the entities Building – Strong Floor – Weak Office – Weak Tenant – Weak
Landlord – Weak Step 6: Identify the relationships and cardinalities (on associative entity) A tenant has only one landlord, a landlord can have many tenants A landlord may own more than one office, an office has only one landlord

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture