Define an appropriate schema using sql ddl in mysql

Assignment Help Database Management System

Reference no: EM132120962

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL.

The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, PropertyId, RentalPrice, Size),Customer (choose appropriate attributes), Rentals (choose attributes; this relationshould describe who rents what, since when, and until when), and Payments (shoulddescribe who paid for which unit, how much, and when).

Assume that a customer canrent more than one unit (in the same or different properties) and that the same unit can be co-rented by several customers.

Reference no: EM132120962

Questions Cloud

Does a high risk mean the return must be low : Investors sometimes fear that a high-risk investment is especially likely to have low returns. Is this fear true? Does a high risk mean the return must be low?

Can you design a des key schedule algorithm : Can you design a DES key schedule algorithm in which each key bit is used an equal number of times?

What was the interest rate you charged : If your receive $500 in simple interest on a loan that you made for $10,000 for 5 years, what was the interest rate you charged?

What is the company brand strategy : How does Marriott international company differentiate itself from its competitors? What is the company's brand strategy?

Define an appropriate schema using sql ddl in mysql : Assume that a customer canrent more than one unit (in the same or different properties) and that the same unit can be co-rented by several customers.

Employee benefits practices for pharmaceutical industry : Conduct some research in order to identify the prevalent employee benefits practices for the Pharmaceutical industry.

What project management tasks should kelvin perform : What change management tasks should Kelvin perform before his next meeting, and how do these tasks fit within the project management process?

Would you prefer to raise the funds through borrowing stock : If you owned a small firm that had become somewhat established, but you needed a surge of financial capital to carry out a major expansion.

How much would have been allocated to CD : If BB had used an activity-based costing system to allocate its operating costs in 2017, how much would have been allocated to CD's

User Account

All Pages