Generic Entities?

  • Thread starter Thread starter FN
  • Start date Start date
F

FN

Hi all,
I'm just working through my Access project and there is only question that
has stumped me. Basically, I have a database with the following tables:
airport, flight, journey, staff, transit, itinerary, reservation. They are
all linked together, the relationship diagram is at
http://tinyurl.com/3fhy5. One of questions says:
Amend the given design to implement airports as generic entity, with local
and major airports as "kinds-of" airports.
I haven't got a clue, so if someone could point me to the right direction
where I could find some info to solve this? (failing that, even tell me the
answer!)
I'm sure I remember something about Access not handling this very well?
Thanks
 
Surely you're asking about creating a lookup table that defines the type of
airports, and then using the primary key from that lookup table as the
foreign key field in your airports table?
 
Ken Snell said:
Surely you're asking about creating a lookup table that defines the type of
airports, and then using the primary key from that lookup table as the
foreign key field in your airports table?
Click to expand...

Thanks, that sorted it
 
Back
Top