ERD Problems - Please Help

[mikhail96]

Hi i'm in great need of help, there is a sorta simple case study from which i have to build a database. I must construct an ER diagram and I'm having a great deal of trouble, can anyone help me please. My attempt seems to be a bit bad. Please assist me.
Case Study

The Hilton Village is an up-market holiday consortium providing ethically sound activity
holidays with a touch of luxury; accommodation is in canvas ‘villages’. To minimize
environmental impact villages consist of no more than 15 tents, most being between 8 and
12 tents. Each village is locally managed to maximize the use of local knowledge and
products. There are now more than 250 Hilton Villages throughout the Caribbean and
Australasia; numbers continue to rise.

I am to design a database for the company (paradise village). Initially each village will maintain its
own local database, but they will all be of the same design.

The database must allow for clients to:
- make bookings, each booking may be for a number of tents, and can be
complex; clients organizing family holidays may want different numbers of tents on
different days as family groups come and go;
- reserve (and be billed for) activities, e.g. the hire of canoes; data would include the date
the canoe trip took place and the number of canoes used. Generally activities are
arranged once the holidaymaker is on-site.
Some sites also have additional facilities (such as a gourmet restaurant) in which case
clients should be able to make bookings before the holiday commences or during the
holiday.


needs to record the following data:
About the client:
• Name.
• Address.
• Telephone,
• Credit card details.
About the site:
• For each tent its name and capacity.
• For the restaurant (or other facilities) if present, its name and capacity.
• For equipment, the item type (e.g. canoe or high chair) and how many of the item are
held.
About bookings:
• It is necessary to record that a booking is made.
• The cost of the booking at the time the booking is made.
About billing:
• The cost of items (e.g. a 2-person tent) throughout the year must be recorded.
Generally this will be divided into high, mid and low season rates.
• As time goes by these prices will be updated.
Unstructured information:
• There is a need for both clients and Paradise Villages to record ad hoc information,
e.g. a client might write a note “I am allergic to all forms of gluten, please can you
make sure there is something I can eat for breakfast.”
[IMG]file:///C:/Users/Mikhail/Pictures/unfinished.jpg[/IMG]

[Rootstonian]

ERD's are not hard to do:

Map out and draw all your tables and the indexes and columns in those tables
Normalize (that is, try to avoid duplicate data in the tables)
Connect the tables with "one-to-one", "one-to-many" etc. lines

You can have a Client_Table with name and address info in it, I would not put credit card number in there. Instead, have a credit_card table and an index that can join to the Client_Table.

That way, security could be setup for users to see Client_Table, but not necessarily their credit card number.

[mikhail96]

hey thank you so much, i ended up getting through with the diagram and i used the credit_card table you pointed out, it was a great help. thansk again. At first it was difficult to do, but I jus calmed myself down and dove into it lol. now i'm finishing up the logical side to it. Thanks again.