+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    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]

  2. #2
    Caveat Emptor Rootstonian's Avatar
    Join Date
    Mar 2005
    Location
    Out of my mind
    Posts
    3,330
    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.

  3. #3
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

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

Tags for this Thread

Posting Permissions

  • You may post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Recommended Sites: ResellerRatings Store Reviews