The Rental System records information about customers, rentals, and payments. For each property, it also records availab

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

The Rental System records information about customers, rentals, and payments. For each property, it also records availab

Post by answerhappygod »

The Rental System records information about customers, rentals, and payments. For each property, it
also records availability by date.
The Rental System provides a unique customer ID (custID) for each customer. It also records the
customer's name and email address. After completing a rental agreement, it also takes payments for
the customer including payment date, amount, credit card number, and credit card expiration
date. Note that the customer may have many payments.
Customers use the rental system to check for the availability of particular properties. For each property,
the Rental System must keep track of availability by date. This includes an availability code of RENTED,
AVAIL or BLOCKEDOUT (so that the owner can personally use his/her property for some dates).
A customer may have many rentals. The rental includes a customer Id, property ID, start date, end
date, down payment amount, and total rental cost. Since customers can cancel a rental, VACAY also
records a status code (PENDING, DOWNPAID, TOTALPAID, COMPLETE, CANCEL).
show a UML Diagram using crows feet model.
Underline keys and wrap inside parenthesis foreign keys. Note that the primary keys from some entities
might contain more than two attributes.
In your UML diagram (2B) for the Rental System, you must also show one or more
relationships to the Property entity.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply