Hi All,
I am new to this forum and was hoping to get some help with a relational database design. I have worked with many databases (MySQL) but they were never relational and now I need one to be relational and it is driving me a bit crazy.
The database functionality I need is as follows:
A users table with the name address phone etc. An airport table where I will insert various airport codes and finally, a services table where I will insert one or more of three types of services. So, as user may have access to one or more airports, and at each airport he may have access to one, two or all three of the services. I am slowly starting to understand how the structure of the relational dB works (barely) but I am really baffled about inserting the info into the various tables with one SQL insert command. Really not sure how to go about this.
Here are the tables I have so far:
I know I could break this one down a bit as well but a little bit at a time :hangover:
Anybody got some time to help me out here and keep my brain from exploding?
Cheers,
Dave
