Link to home
Start Free TrialLog in
Avatar of stevthym
stevthym

asked on

Assistance with an ERD Diagram

Hi,

For the following scenario I need to develop a UML style ERD diagram. I am confused... Please assist. Perfecly with a diagram...

Case Study:
Tracel and Tourism Ltd (TAT advertise and manage properties for rent in popular holiday resorts arount the Eastern Mediterranean and black sea coasts. Properties can be registered with TAT by their owners or by an agent who acts on behalf of one or more owners.

When property owners or agants reg their property with TAT they must provide info about their property, TAT staff will use this info to complete an Accomodation Spec Form (ASF) An example of ASF is shown in FIgure 1.
Historically TAT only used to deal with agents so the ASF was used to store agent details and then list all details of properties from the agent. More recently TAT has began to operate directly with owners and so in these cases the owner is also considered to be the agent(they assigned an Agent ID) and only one property is entered on the ASF.

For all properties a copy is made of the owner's details wich are saved in the Owner File whilist the completed ASF is file by agent name in property file.Agent's details are currently not stored separately from the property details.

Customers will contact the TAT Enquiries Desk with general enquiries regarding accom and availability. It is company policy that an enquiry will always result in some form of communication back to the customer. However due to the persuasive skills of the Enquiries Desk team general enqueiries often also result in a booking

Bookings (either directly from a customer or through the Enquiries Desk) will always be handled by the booking Dep. Property details and retes are checked against the booking request provided by the customer as is the availability of the prop. If everithing is in order then a booking is recorded, the deposit is taken and the abailability of property details will be adjusted accordingly. The customer will receibe a confirmation of the booking.

If there are any probs with the booking the alternative accomd. may be offered but on the rare occasion that a booking can't be made the customer is sent a cancellation notice and their deposit refunded.

All Payments to TAT must be taken through the Acc Section. Deposits sent with bookings will be directed there and also customers who are making advance payments for their accomodation will send payments directly to the Acc sec. Receipts are issued for every payment received.

The Accounts Section also handles payments of rental fees to owners and agents. At the end of Each month the Acc Section will calculate the rental income generated by the property subtract is commission (usuallu 2.5%) and send the remainder to the owner. In the case where an agent has provided the property details payment sent to the agent rather than teh owner. This allows the agent to subtract their own fees before sending the remainder to the owner.
Avatar of Darren
Darren
Flag of Ireland image

Avatar of stevthym
stevthym

ASKER

Thanks... But please based on my scenario would you just suggest which entities I should generate from the description?
ASKER CERTIFIED SOLUTION
Avatar of Darren
Darren
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
OK, I will create an ERD and let you know asap... Thanks!
Hi,

Are you going to put something up?

Darren
tomorrow yes!
Hi,

Well not really. I am planning to teach that course and I am just looking for clarifications!