Relational Database Design OWNER Perform the complete transformation

Relational Database Design OWNER Perform the complete transformation steps for the E-R Model of the ‘Real Estate Agency’ described in Topic 4. 1 (1, N) own N (1, 1) MAINTENANCE (1, 1) (0, N) incur N PROPERTY 1 (0, N) 1 N (0, N) for (1, 1) rent N ACCOUNT (1, 1) N M pay (1, N) TENANT 1 Topic 5 : Relational Database Design

Relational Database Design Solution -- From Step 1 OWNER ( Owner #, Owner Name, Owner Address) PROPERTY ( Building#, Address, Value) TENANT(Tenant#, Family Name, First Name, Contact Address, Phone#) MAINTENANCE (Maintenance#, Date, Type, Cost) ACCOUNT( Acct Receipt#, Dateof. Payment, Typeof. Account, Amount. Paid) -- Step 2: No weak entity -- Step 3: no 1 To 1 relationship -- Step 3 -- Step 4: 1 To N between OWNER and PROPERTY -- The PROPERTY relation is modified: PROPERTY (Building#, Address, Value, Owner#) Topic 5 : Relational Database Design

Relational Database Design Solution -- Step 4: 1 To N between PROPERTY and MAINTENANCE -- The MAINTENANCE relation is modified to: MAINTENANCE(Maintenance#, Date, Type, Cost, Building#) -- Step 4: 1 To N between TENANT and ACCOUNT -- The ACCOUNT relation is modified to: ACCOUNT( Acct Receipt#, Dateof. Payment, Typeof. Account, Amount. Paid, Tenant#) -- Step 4: 1 To N between PROPERTY and ACCOUNT -- The ACCOUNT relation is modified to: ACCOUNT( Acct Receipt#, Dateof. Payment, Typeof. Account, Amount. Paid, Tenant#, Building#) Topic 5 : Relational Database Design

Relational Database Design Solution -- Step 5: M to N relationship between TENANT and PROPERTY The RENT relation is created: RENT (Building#, Tenant#, Leased. Period, Bond) -- -- Step 6: no multivalued attribute. -- Step 7: no ternary relatiosnhip Topic 5 : Relational Database Design

Relational Database Design Solution -- Finally, the end result of the transformation can be listed as follows. OWNER ( Owner #, Owner Name, Owner Address) PROPERTY (Building#, Address, Value, Owner#) TENANT(Tenant#, Family Name, First Name, Contact Address, Phone#) MAINTENANCE(Maintenance#, Date, Type, Cost, Building#) ACCOUNT( Acct Receipt#, Dateof. Payment, Typeof. Account, Amount. Paid, Tenant#, Building#) RENT(Building#, Tenant#, Leased. Period, Bond) Step 1 Step 4 Step 5 Topic 5 : Relational Database Design