Bit of help needed

[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

 

[FN]

Sounds like this might be a classroom project. I'll offer a rephrasing of

the question - it may be incorrect so do with this as you see fit.

"Change the design and add another table of airport types (private,

municiple, metropolitan, international, etc.) and have the PK of this table
as a FK in your main airport table."

Hope this is of some help to you.

Rick...
----- FN wrote: -----

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

Thanks, that sorted it