WILL UPVOTE. PLEASE USE VISUAL PARADIGM, IF POSSIBLE You are hired to develop a database system for a real estate manage
Posted: Tue Jul 12, 2022 8:16 am
WILL UPVOTE. PLEASE USE VISUAL PARADIGM, IF POSSIBLE
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. You MUST submit your answer in pdf format.The names of the group members must be written on the first page ofyour pdf document.
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. You MUST submit your answer in pdf format.The names of the group members must be written on the first page ofyour pdf document.