Theme Park Database
I am trying to get my head around the concept of normalisation and need a little guidance if possible. I am trying to create a database that will store information about how many times I rode theme parks rides, at which park, on which day. I have come up with these tables and links so far.
Diary_table :- DiaryID, No_of_Rides, DateID, RideID
Ride_table :- RideID, ridename, ParkID
Park_table :- ParkID, parkname
Date_table :- DateID, actual_date
I think I am right in putting date into its own table, since there will be repeated dates for different rides. ie on day three, I might ride seven different rides in two different parks. The idea is eventually to be able to run queries that determine 'how many times did I ride #Rideone# during my holiday' or 'what rides did I ride on day three?'
I am hoping this is pretty close to a completed structure, but any feedback or comments would be very much appreciated.
xE
Subject
Written By
Posted
Theme Park Database
July 13, 2011 06:33PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.