Check My Tables Please !

[spazzer]

Hi,
I am designing some tables to store data about drivers and routes and types of traction they drive can someone check out my tables and see if all is ok so far and give any advice on what to do next ??

Cheers,
Nick C

 

[Kryst51]

Your tables look good to me, for storing data. What do you want to do with the database, that might help people to give you advice on what to do next.

 

[spazzer]

Hi,
Thanks for reply, I am trying to create a start on a database for where I work, I have upto 750 members of staff who work at different stations across the country some are train guards and some are train drivers, I also have platform and station staff but am concentrating on traincew for now, they all can drive different traction engines and also drive over various different routes, some will drive everything to everywhere and others maybe only one route and traction !
As I have done above in diagram is this data normalized ?,also how can I see what the the numbers mean in the tables i.e. If I have a driver 1 who can drive over routeID 1,2 & 3 how can I see who the driver is without having to create a lookup that might give me a list of over 500 drivers ?
I would appreciate any ideas !!!

All the Best,
Nick C

 

[Kryst51]

You do these things through queries and forms. The tables just store the information, check out some tutorials on forms and queries. It sounds like you have a good handle on the table design portion from looking at your relationship page. It looks normalized to me. Nothing sticks out. Also there are other helpful threads in this forum to help as well.

 

[spazzer]

Hi,
Thanks for reply,I have got a good book on it so will check it out, thanks for help !

Nick C

 

[Kryst51]

Your very Welcome.