Bit of help needed

  • 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
 
Rick said:
Sounds like this might be a classroom project. I'll offer a rephrasing of
Click to expand...
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,
Click to expand...
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
Click to expand...

Thanks, that sorted it
 
Back
Top