Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    1

    UNF, 1NF, 2NF, 3NF. Help anyone!

    Hi,

    I've got some work to do for uni, it's normailsing a booking form but i'm fairly new to it and am not overly sure what goes where. If anyone wouldn't mind taking a look that'd be great. Also there's a bit of work after e.g. inputting into access, so i really need the normalising correct before i can go any further.


    Here's the form:



    __________________________________________________ _

    NORTH SEA LINERS
    Booking Form

    BOOKING NO ______________
    BOOKING DATE _______________ BOOKING CLERK _______________________
    CROSSING No _______________ DEP DATE _______________________ DEP TIME ___________
    ARRIVAL PORT _____________ ARRIVAL TIME ______________ NO OF CABINS BOOKED ______________
    NUMBER OF PASSENGERS ___ ________________ CUSTOMER NUMBER _______________
    CUSTOMER NAME __________________________ CUSTOMER ADDRESS ________________________________________

    (Should be a table below)

    Passenger Details
    ID Name Gender Special Requirements (for this visit) Price
    1
    2
    3
    4
    5

    total___________________


    ________________________________________________


    Here's my normailising attempt.

    UNF

    Booking No
    Booking Date
    Booking Clerk
    Crossing No
    Dep Date
    Dep Time
    Arrival Port
    Arrival Time
    Number of Cabins booked
    Number of Passengers
    Customer Number
    Customer Name
    Customer Address
    ID
    Name
    Gender
    Special Requirements
    Price
    Total



    1NF

    Booking No
    Booking Date
    Booking Clerk
    Crossing No
    Dep Date
    Dep Time
    Arrival Port
    Arrival Time
    Number of Cabins booked
    Number of Passengers
    Customer Number
    Customer Name
    Customer Address

    Booking No
    ID
    Name
    Gender
    Special Requirements
    Price
    Total


    2NF

    Booking No
    Booking Date
    Booking Clerk
    Crossing No
    Dep Date
    Dep Time
    Arrival Port
    Arrival Time
    Number of Cabins booked
    Number of Passengers
    Customer Number
    Customer Name
    Customer Address

    Booking No
    ID

    ID
    Name
    Gender
    Special Requirements
    Price
    Total


    3NF

    Booking No
    Booking Date
    Booking Clerk
    Crossing No

    Crossing No
    Dep Date
    Dep Time
    Arrival Port
    Arrival Time

    No of Cabins booked
    No of passengers
    Customer No

    Customer No
    Customer Name
    Customer Address

    Id...
    (Though think it's all wrong upto here)

    _______________________________________

    Assignment if anyone want to take a look:
    http://www.yousendit.com/transfer.ph...8B63A0758B740F



    Any help or suggestions would be great.
    Thanks Adam.
    Last edited by dunnot; 07-20-06 at 18:58.

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    You have several things to work out starting right from your UNF.

    You will ultimately need to separate Booking, Crossing, Customers and Passengers.

    I suggest going to FabForce.Net and downloading dbDesigner and doing your work with a graphic tool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •