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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Dataset
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education