The Plaza is an apartment rental company that would like to create an online management system to keep track of apartment complex units, tenants, maintenance requests, and rental payment information. Since you are taking a database class, you are asked to assist the company in designing a database based on the following specifications. Each apartment unit has a unique number.Each unit's street number,street name, city, state zip code, number of bedrooms, monthly rent, and occupancy status are recorded. Each tenant must lease at least one apartment unit for a period of time. It is important to document the lease start date and end date. The Plaza tracks each tenant's name, SSN, home mailing address, and phone number. Each tenant is assigned a unique identifier number. Each tenant should pay the monthly rental fee by the first day of each month.Any rent due not paid by the 4th day of the monthly rental period is subject to a $50.00 late fee charge with an additional $10.00 for each late day. Accurately documenting payment information is vital for deciding the late payment penalties. Each payment date,amount,pay type (cash, check, credit card, etc.) need to be tracked. Each payment has a unique identifier number. To ensure each unit is in a livable condition,each tenant may request work orders for maintenances. The requested date and problems should be recorded for each work order. In addition,each work order has a unique identifier number, completed date and worker's name Once the repair job is complete, the work order can be signed off 1.Draw an ER-diagram for the database by identifying the entity sets,relationship sets and their multiplicity, and the primary key for each entity set (and weak entity set, if any) and each relationship set Q1 Which of the following statements is true?: A. "Leastby" is an entiry set and has two attributes B. "Makes" is a relationship set and has one attribute. C. "Tenants" is an entity set and has one candidate key. D. "Payments" is a relationship set and jas four attributes. Q2 List the number of binary relationship sets in the E-R diagram: (enter an integer.) Q3 List the number of many multi-valued attributes in the E-R diagram. (Enter an integer) Q4: The late fee and specific due date of the rent can be modeled as attributes of the relationship set Makes. True or false? Q5: Is there a generalization and specialization relationship? Yes or no? If yes, list its super-entity type and sub-entity types in sequence.
The Plaza is an apartment rental company that would like to create an online management system to keep track of apartment complex units, tenants, maintenance requests, and rental payment information. Since you are taking a database class, you are asked to assist the company in designing a database based on the following specifications. Each apartment unit has a unique number.Each unit's street number,street name, city, state zip code, number of bedrooms, monthly rent, and occupancy status are recorded. Each tenant must lease at least one apartment unit for a period of time. It is important to document the lease start date and end date. The Plaza tracks each tenant's name, SSN, home mailing address, and phone number. Each tenant is assigned a unique identifier number. Each tenant should pay the monthly rental fee by the first day of each month.Any rent due not paid by the 4th day of the monthly rental period is subject to a $50.00 late fee charge with an additional $10.00 for each late day. Accurately documenting payment information is vital for deciding the late payment penalties. Each payment date,amount,pay type (cash, check, credit card, etc.) need to be tracked. Each payment has a unique identifier number. To ensure each unit is in a livable condition,each tenant may request work orders for maintenances. The requested date and problems should be recorded for each work order. In addition,each work order has a unique identifier number, completed date and worker's name Once the repair job is complete, the work order can be signed off 1.Draw an ER-diagram for the database by identifying the entity sets,relationship sets and their multiplicity, and the primary key for each entity set (and weak entity set, if any) and each relationship set Q1 Which of the following statements is true?: A. "Leastby" is an entiry set and has two attributes B. "Makes" is a relationship set and has one attribute. C. "Tenants" is an entity set and has one candidate key. D. "Payments" is a relationship set and jas four attributes. Q2 List the number of binary relationship sets in the E-R diagram: (enter an integer.) Q3 List the number of many multi-valued attributes in the E-R diagram. (Enter an integer) Q4: The late fee and specific due date of the rent can be modeled as attributes of the relationship set Makes. True or false? Q5: Is there a generalization and specialization relationship? Yes or no? If yes, list its super-entity type and sub-entity types in sequence.
Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter12: Database Queries With Sql
Section: Chapter Questions
Problem 3E
Related questions
Question
The Plaza is an apartment rental company that would like to create an online management system to keep track of apartment complex units, tenants, maintenance requests, and rental payment information. Since you are taking a database class, you are asked to assist the company in designing a database based on the following specifications.
Each apartment unit has a unique number.Each unit's street number,street name, city, state zip code, number of bedrooms, monthly rent, and occupancy status are recorded.
Each tenant must lease at least one apartment unit for a period of time. It is important to document the lease start date and end date.
The Plaza tracks each tenant's name, SSN, home mailing address, and phone number. Each tenant is assigned a unique identifier number.
Each tenant should pay the monthly rental fee by the first day of each month.Any rent due not paid by the 4th day of the monthly rental period is subject to a $50.00 late fee charge with an additional $10.00 for each late day. Accurately documenting payment information is vital for deciding the late payment penalties. Each payment date,amount,pay type (cash, check, credit card, etc.) need to be tracked. Each payment has a unique identifier number.
To ensure each unit is in a livable condition,each tenant may request work orders for maintenances. The requested date and problems should be recorded for each work order. In addition,each work order has a unique identifier number, completed date and worker's name Once the repair job is complete, the work order can be signed off
1.Draw an ER-diagram for the database by identifying the entity sets,relationship sets and their multiplicity, and the primary key for each entity set (and weak entity set, if any) and each relationship set
Q1 Which of the following statements is true?:
A. "Leastby" is an entiry set and has two attributes
B. "Makes" is a relationship set and has one attribute.
C. "Tenants" is an entity set and has one candidate key.
D. "Payments" is a relationship set and jas four attributes.
Q2
List the number of binary relationship sets in the E-R diagram: (enter an integer.)
Q3
List the number of many multi-valued attributes in the E-R diagram. (Enter an integer)
Q4:
The late fee and specific due date of the rent can be modeled as attributes of the relationship set Makes. True or false?
Q5:
Is there a generalization and specialization relationship? Yes or no? If yes, list its super-entity type and sub-entity types in sequence.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning