Showing posts with label relational. Show all posts
Showing posts with label relational. Show all posts

Friday, March 30, 2012

Need help assigning runway using time

Hi there,
I am trying to model a simple air traffic control system and have plane, flight_info and runway tables. Flight_info is a relational table and 2 of its attributes are pointers to the plane and runway tables so that I can allocate planes and flights to runways.

The length of the runway needs to be more than the stopping distance of the plane and I have a getStoppingDistance method to use for this. I guess one part will be to compare the length of the runway with the stopping distance.

I also need to assign a runway to a flight for a fixed time for each flight. I'm not sure how I can achieve this. I am thinking that I will need to test the 'state' attribute of the runway table to see if a particular runway is allocated or not and if it isn't, assign it to a flight. But I'm not sure how I would assign it for a fixed time.

Any help or suggestions on this would be great.reset the "state" attribute of runway everytime the flight completes landing. you could write a trigger on flight_info table which shall toggle this runway.state when you update flight_info

Friday, March 9, 2012

need advice

Hi guys,
Can you suggest good books on relational algebra and database design(NF)?
Thanks a lot in advance
Alexhttp://www.datamodel.org/
AMB
"Alex" wrote:

> Hi guys,
> Can you suggest good books on relational algebra and database design(NF)?
> Thanks a lot in advance
> Alex
>
>|||>> Can you suggest good books on relational algebra and database design(NF)?
One widely recognized book on the scientific & mathematical aspects (
algebra, calculus & deductive ) of relational theory is the Foundations of
Databases by Abiteboul, Hull & Vianu. The book is relatively advanced and
the ones starting out might find the book tough to comprehend. On the topic
of relational algebra and the coverage of its practical utility, no other
popular book does more justice more than C J Date's Introduction to Database
systems. As far as datamodelling is concerned there are several good books
around. Books by C J Date, Toby Teorey, David Maier etc are excellent
primers dealing with conceptual modelling and logical design.
As in every other field with its basis on science & mathematics, sometimes
it makes good sense to avoid product based design books and 10-minute guides
to learn data modelling & design.
Anith