right, the project involves createing a dyanamic website for a ficticious cruise company. The aim of the site is to allow a member of the cruise line admin staff to update the website without the use of a web developer.
Thus far I have three forms which I have normalised,
Crusie date -Contains info about the holidays, cost etc
Staff data -Contains staff username & password
Itinerary data- contains more detailed info about the hols & the schedule
Its really the itinerary data that I'm struggling with,
UNF 1NF 2NF 3NF
itineraryID itineraryID itineraryID itineraryID
heading heading heading heading
description description description description
day image image image
arrive time itineraryID* itineraryID* itineraryID*
depart time day day day
image destination destination destination
arrive arrive arrive
depart depart depart
I'm just not sure if I've normalised this correctly as when I started to gather date it didn't seem right. Above I am left with an Itinerary table n then a Schedule table.
When I gather data for my schedule table this is what i ended up with
itineraryID* day destination arrive depart
1 Tuesday Barbados 8.00pm
1 Wednesday at sea at sea at sea
1 Thursday Trinidad 8.00am 6.00pm
1 Friday Isla Margarita 8.00am 6.00pm
1 Saturday Grenada 8.00am 6.00pm
1 Sunday St Lucia 8.00am 6.00pm
1 Monday St Vincent 8.00am 6.00pm
1 Tuesday Barbados 7.00am
2 Tuesday Barbados 8.00pm
2 Wednesday at sea 8 6
2 Thursday Tortola 8 7
2 Friday St Maarten 8 8
2 Saturday St Kitts 8 8
2 Sunday Antigua 9 6
2 Monday Dominica 8 8
2 Tuesday Barbados 7
Have I done something wrong during normalisation?????? Or does this look ok??
Well why didn't u just say so at the start, lol, )
Super mate, thanks alot, as I said above i just felt there was summit wrong when I was entering the data & I ended up with 8 itineraryId row 1's
Yep once they leave on place there headed to another!
lol most folks have a single digit fav number!
I'm still a little confused about how I'll pull back the individual times when I come to populate my "update Schedule" form fromt the database but as long as theres no glaring errors I think I'll go get the rest of my data n start to build the site!