November 4, 2016 at 10:01 am
An Airline Management System manages airline flight information. Each flight is identified by flight number, consists of 1 or more flight legs with leg numbers 1, 2, 3 etc.
Trying to design a database in3NF for this but struggling to think of tables so far, what I have so far is the following minus the tuples which am I also struggling with 🙁 SQL maybe not for me!!!
Flight Table
FlightID
RouteNo
Route Table
RouteNo
DepartureTime
ArrivalTime
Fares Table
Airplane Table
Airport Table
Reservations Table
AirportAirplane Table
Apologies i know this in probably beneath most of the members here and I'm way out!!!
November 4, 2016 at 12:58 pm
Anyone??
November 4, 2016 at 1:20 pm
Don't think of tables. You need to start by thinking on entities, attributes and relationships. Create an ER model before even thinking about tables.
Designing a DB is not a task that can be completed using a forum. It's a complex process that might take you months. Unless you want a simplistic approach that can be used for a homework but will give problems with real-life scenarios.
November 14, 2016 at 7:15 am
Luis Cazares (11/4/2016)
Don't think of tables. You need to start by thinking on entities, attributes and relationships. Create an ER model before even thinking about tables.Designing a DB is not a task that can be completed using a forum. It's a complex process that might take you months. Unless you want a simplistic approach that can be used for a homework but will give problems with real-life scenarios.
....and be very careful about overnormalising......
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply