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.

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.