Question

+ pays OWNER OwnerID FirstName has LastName H+- Email Phone BankAccountNumber CUSTOMER CustomerID FirstName DO- LastName Phone Email HOUSE PropertyID HouseName Size Type Address City rents MAINTENANCE_INVOICE InvoiceID InvoiceDate billed to Total has MAINTENANCE MaintenanceID Maintenanceltem performs H+- RequestDate RequestDetail CompletedDate Cost StartDate EndDate Cost

          + pays
OWNER
OwnerID
FirstName
has
LastName
H+-
Email
Phone
BankAccountNumber
CUSTOMER
CustomerID
FirstName
DO-
LastName
Phone
Email
HOUSE
PropertyID
HouseName
Size
Type
Address
City
rents
MAINTENANCE_INVOICE
InvoiceID
InvoiceDate
billed
to
Total
has
MAINTENANCE
MaintenanceID
Maintenanceltem
performs
H+-
RequestDate
RequestDetail
CompletedDate
Cost
StartDate
EndDate
Cost

+ pays
OWNER
OwnerID
FirstName
has
LastName
H+-
Email
Phone
BankAccountNumber
CUSTOMER
CustomerID
FirstName
DO-
LastName
Phone
Email
HOUSE
PropertyID
HouseName
Size
Type
Address
City
rents
MAINTENANCEINVOICE
InvoiceID
InvoiceDate
billed
to
Total
has
MAINTENANCE
MaintenanceID
Maintenanceltem
performs
H+-
RequestDate
RequestDetail
CompletedDate
Cost
StartDate
EndDate
Cost

Added by Kimberly B.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Luke Humphrey

Step 1

First, let's identify the entities in the conceptual design: Show more…

Show all steps

Thanks for your feedback!

The figure below is a conceptual database design for a house rental system. It is a conceptual design, so it does not specify primary keys, foreign keys, and associative entities. Convert the following conceptual design into a logical schema. A logical schema for a relational database should have primary keys, foreign keys, and associative entities (when needed). (Use Astah IE) MAINTENANCE INVOICE billed to InvoiceID InvoiceDate Total 1-N pays has OWNER HOUSE PropertyID MAINTENANCE OwnerID MaintenanceID FirstName HouseName MaintenanceItem has LastName Size performs RequestDate Email Type RequestDetail Phone Address City CompletedDate BankAccountNumber Cost CUSTOMER CustomerID StartDate EndDate Cost FirstName rents LastName Phone Email