a. Prepare a UML class diagram with classes, associations, and multiplicities. b. Using the preceding information and

Question:

a. Prepare a UML class diagram with classes, associations, and multiplicities.

b. Using the preceding information and the following attributes list, prepare a listing of the relational tables necessary to support this sales and collection process. List the tables in the following order: resources, events, agents, type images, and linking tables.


Beach Rentals (BR) maintains an inventory of rental houses near universities and leases those houses to student renters. This case describes their rental business process. BR agents-former marketing majors renowned for their fast-talking and flamboyant lifestyles- work with potential renters and sign the rental contracts for BR.
BR tracks its houses by city, neighborhood, and distance from campus. BR assigns one specific BR agent to each neighborhood to manage rentals for all houses in that neighborhood, but each BR agent may be assigned to multiple neighborhoods. BR cashiers collect the rent and are bonded for security purposes. Because cashiers never become agents (or vice versa), BR tracks BR cashiers separately from BR agents, although both are identified by employee numbers.
BR sets rental rates to its student customers by considering such matters as number of bedrooms and age of the house. Additionally, BR applies a monthly rental surcharge to each house that depends solely upon its neighborhood designation; for example, upscale neighborhoods have higher surcharges and less desirable neighborhoods have lower surcharges.
The same surcharge applies for the life of the lease. Every house has a rental surcharge, and all houses in a particular neighborhood have the same surcharge.
Prospective renters, usually students, contact BR to inquire about renting a house. When a potential renter contacts BR, a BR agent is assigned to assist him or her. That BR agent remains the person's point of contact for as long as he or she continues to deal with Beach Rentals. BR records information on each potential renter as soon as he or she contacts BR to inquire about a house.
BR agents negotiate the rental contracts with the students. Each rental contract must last at least 6 months, and 12-month contracts get a 5 percent discount. BR also charges a damage fee that is due along with the first month's rent when the rental contract is signed.
The BR agent earns a 10 percent commission on each rental contract, and BR tracks the year-to-date (YTD) commission earned for each of the BR agents. Of course, the BR agents compete with one another to see who earns the highest commissions, and BR fosters the competition by giving an annual award to its "best" agent.
When multiple students want to rent one house, BR requires that they designate the primary renter-the one who will be responsible for paying the rent. BR also gathers information about all the other occupants of the house and designates them as secondary renters. All the student renters, however, sign the rental contract, and BR assigns a unique renter number to each occupant. The students may not change primary renter for the term of a contract. BR cashiers collect the rental payments monthly from the primary renters. BR records information concerning employees, house owners, bank accounts, and neighborhoods in the database before the renters are involved in any events.

Attributes:
Agent employee# Monthly rent Agent name Neighborhood name Agent real estate license status Number of bedrooms Bank accou

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Accounting Information Systems

ISBN: 978-1260153156

2nd edition

Authors: Vernon Richardson, Chengyee Chang, Rod Smith

Question Posted: