Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012
    Posts
    6

    Airline Schedules

    I'm building an airline simulation game and want to store my schedule into a database.

    I have an aircraft table with my planes.

    How should I set up my schedule table.

    It'll have the following columns.

    AircraftID
    OriginAirport
    DestinationAirport
    DepartureTime
    ArrivalTime
    DayOfWeek (int 1-7)

    Is there a better way of doing this?

    I would need to check that any departure is not before a previous arrival but could run a query before an insert.

    Ill be using mysql

  2. #2
    Join Date
    May 2016
    Posts
    81
    Hi kiwis

    I propose you this conceptual & logical data model considering that an aircraft can stop over many times

    CDM
    Click image for larger version. 

Name:	flyCDM.jpg 
Views:	3 
Size:	94.7 KB 
ID:	17112

    LDM
    Click image for larger version. 

Name:	flyLDM.jpg 
Views:	4 
Size:	115.4 KB 
ID:	17113


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •