1. The figure below is a conceptual database design for a house rental system. It is a conceptual design so that 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 InvoicelD billed to Invoice Date Total pays OWNER OwnerlD has MAINTENANCE MaintenancelD HOUSE PropertyID HouseName Size FirstName Maintenanceltem has performs LastName RequestDate Email Type Request Detail Phone Address City Completed Date Cost BankAccountNumber CUSTOMER CustomerlD FirstName rents StartDate EndDate Cost LastName Phone Email