home hardware prices news articles forums photos user reviews
Go Back   Tech Support Forums - TechIMO.com > PC Hardware and Tech > Webmastering and Programming
Ask a Tech Support Question (free)!

ERD Problems - Please Help

Reply
Get bargains at  »  Dealighted.com
 
Thread Tools Search this Thread
Currently Active Users: 2079
Discussions: 200,919, Posts: 2,379,045, Members: 246,287
Old October 20th, 2009, 05:10 PM   Digg it!   #1 (permalink)
Junior Member
 
Join Date: Oct 2009
Posts: 2
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.
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]
mikhail96 is offline   Reply With Quote
Old October 24th, 2009, 11:23 AM     #2 (permalink)
Caveat Emptor
 
Rootstonian's Avatar
 
Join Date: Mar 2005
Location: Out of my mind
Posts: 3,241
Send a message via AIM to 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.
Rootstonian is offline   Reply With Quote
Old October 25th, 2009, 02:28 PM     #3 (permalink)
Junior Member
 
Join Date: Oct 2009
Posts: 2
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.
mikhail96 is offline   Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
I need a bit of Help on this ERD project Story Lopez Webmastering and Programming 1 October 11th, 2008 12:03 PM
cli.exe errors and game problems Pc problems sammy1991 Technical Support 1 July 9th, 2006 09:21 PM
SiS Driver problems and Graphics Card Problems Piccolo00 Graphics Cards and Displays 5 January 25th, 2004 04:19 PM
Backup, ERD etc? John Prophet Applications and Operating Systems 1 December 2nd, 2003 02:08 PM
Mandrake 9.0 Installation Problems: X-Server, GUI Problems? chromelocust Technical Support 2 March 21st, 2003 03:50 AM


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Most Active Discussions
Is It Just Me? (2846)
Obama the Muslim (11)
Why is Khalid Sheikh Mohammed even .. (9)
Is the PSU I received dead? (10)
windows vista security holes (7)
Foreign voltage (10)
HIS HD5770 graphic card question (15)
Install XP pro and a Vista laptop ?.. (9)
A good PSU? (10)
Dept. of HS: NSA 'Helped' Develop V.. (15)
Print spooler problem (10)
New Computer wont recognize XP disc (7)
Ideal cheap graph card for PC-Gamin.. (15)
EVGA 9800 gtx help with finding a g.. (8)
Recent Discussions
Foreign voltage (10)
FiOS modem/router interfering with ne.. (7)
Browsers wont load websites (2)
Virus Doctor Popup? (1)
Help getting around port 80 for camer.. (1)
[F@H SPAM 11/16/09] ! 1/2 months to r.. (31)
Dept. of HS: NSA 'Helped' Develop Vis.. (15)
windows vista security holes (7)
Install XP pro and a Vista laptop ?? (9)
EVGA 9800 gtx help with finding a goo.. (8)
Modern Warfare For the PC (32)
Problem with speed step/turbo boost? (1)
monitor will not turn on at all, (0)
Modern Warfare 2: Who Bought It? (61)
World's largest Monopoly Game using G.. (330)
Print spooler problem (10)
SIS 740 and Widescreen (8)
Baffling Problem with my CPU/MoBo's. .. (0)
Display shows 3x5 inch in middle of s.. (0)
HIS HD5770 graphic card question (15)
Best file format to play on Windows H.. (0)
PSP Go bought in Japan (0)
Asus P4G8X Mobo (3)
Need hard disk drivers (4)
windows 7 internet problem (4)


All times are GMT -4. The time now is 06:45 PM.
TechIMO Copyright 2009 All Enthusiast, Inc.



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28