WILL UPVOTE. I ALREADY POSTED THIS QUESTION BUT I DID NOT RECEIVE THE CORRECT ANSWER. THANK YOU You are hired to develop

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

WILL UPVOTE. I ALREADY POSTED THIS QUESTION BUT I DID NOT RECEIVE THE CORRECT ANSWER. THANK YOU You are hired to develop

Post by answerhappygod »

WILL UPVOTE. I ALREADY POSTED THIS QUESTION BUT I DID NOTRECEIVE THE CORRECT ANSWER. THANK YOU
You are hired to develop a database system for a real estatemanagement company. The company’s business is to rent apartments totenants. The lease contains the following information:
Tenant’s fist and last name
Tenant’s e-mail address
Tenant’s cell phone number
Tenant’s preferred way of communication: either e-mail orsms
Full address of the apartment being rented
Size of the apartment in terms of number of bedrooms and numberof bathrooms
Rent value in USD
Start and end days of the lease in the form ofday/month/year
Each lease can have a maximum of two tenants’ names on it
In this assignment, your task is to extract all the neededrelations. You need to apply all the guidelines and good databasedesign practices discussed in class. Feel free to add fields ifneeded. You need to specify the connectivity and the cardinalitybetween the relations.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply