Thread: ERD Problems - Please Help
October 20th, 2009, 04:10 PM #1
- Join Date
- Oct 2009
ERD Problems - Please Help
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.
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
needs to record the following data:
About the client:
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
It is necessary to record that a booking is made.
The cost of the booking at the time the booking is made.
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.
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.
October 24th, 2009, 10:23 AM #2
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.
October 25th, 2009, 01:28 PM #3
- Join Date
- Oct 2009
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Story Lopez in forum Webmastering and ProgrammingReplies: 1Last Post: October 11th, 2008, 11:03 AM
By sammy1991 in forum Technical SupportReplies: 1Last Post: July 9th, 2006, 08:21 PM
By Piccolo00 in forum Graphics Cards and DisplaysReplies: 5Last Post: January 25th, 2004, 04:19 PM
By John Prophet in forum Applications and Operating SystemsReplies: 1Last Post: December 2nd, 2003, 02:08 PM
By chromelocust in forum Technical SupportReplies: 2Last Post: March 21st, 2003, 03:50 AM