Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help with this question please 2. (10 points) The figure below is a conceptual database design for a house rental system. It is a conceptual

help with this question please image text in transcribed
2. (10 points) 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). MAINTENANCE_INVOICE Invoicel InvoiceDate Total has MAINTENANCE HOUSE pays OWNER Ownerlo First Name LastName Maintenancelp PropertyID HouseName Maintenance Requeste Request Detail Completed Date Cost Bank Account Number CUSTOMER Customerid LastName (Paste your Astab Result Here) 2. (10 points) 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). MAINTENANCE_INVOICE Invoicel InvoiceDate Total has MAINTENANCE HOUSE pays OWNER Ownerlo First Name LastName Maintenancelp PropertyID HouseName Maintenance Requeste Request Detail Completed Date Cost Bank Account Number CUSTOMER Customerid LastName (Paste your Astab Result Here)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

1. Who is responsible for resolving this dilemma?

Answered: 1 week ago