#1 (permalink)

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.