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.

Fundamentals of Information Systems
8th Edition
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Applications
Section: Chapter Questions
Problem 3PSE
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
Recommended textbooks for you
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
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
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning