Results 1 to 3 of 3

Thread: ERD Question

  1. #1
    Join Date
    Sep 2005
    Posts
    14

    ERD Question

    I am a newbie to database. I'm taking a course in database at school and have this one question. I am learning to create ERD.

    We are asked to make an ERD about an airport company. The airport company keeps track of passengers, crews members, flights, plane, inspection reports, baggage. This is not an exaustive list but you get the idea. These are all represented as entities. Now my questions is if the airport wants to keep track of these entities (single instance of the database) for each airline how would the ERD represent such a scenario ? What would be the most efficent/optimized strategy ? Do I just create one entity called say CrewMemeber which will contain all crew members for all airlines...?

    The teacher has not specified anything with respect to how the different airlines should be treated. Is the teacher being vague here or is there a general technique that one would apply in this case ?

    Many thanks

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    One entity should work, you can have another entity for airlines and have a one to many relation from airlines to crewmembers

  3. #3
    Join Date
    Sep 2005
    Posts
    14
    Many thanks again skhanal.

Posting Permissions

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