Forum: Database Design  Nov 9th, 2008 |
| Replies: 24 Views: 2,154 Sorry ... I missed that. Will do in the future. Can I move those over now so maybe this post can help someone else?
Dave |
| Forum: Database Design Nov 6th, 2008 |
| Replies: 24 Views: 2,154 Well ... now I need to get this into an actual database and then create the logic to actually insert and retrieve the data. I have not ever done inserts and selects with this type of database so it... |
| Forum: Database Design Nov 5th, 2008 |
| Replies: 24 Views: 2,154 OK .. I have updated the diagram (http://fsmgroup.zuka.net/assets/images/temp/db_v.110508.04.png). I am referring to telephone area codes actually. So again my thinking was ... an area code can... |
| Forum: Database Design Nov 5th, 2008 |
| Replies: 24 Views: 2,154 Wow .. until you mentioned it, I did not realize that I had neglected to add a province/state table to the mix. Duh!!
I will update the diagram to see if I understand what you are saying.
Dave |
| Forum: Database Design Nov 5th, 2008 |
| Replies: 24 Views: 2,154 Sorry ... didn't see this before I replied. Well .. here in Canada, a city can have different postal codes as well as areacodes. And, I am pretty sure there is a Toronto in the US as well as here in... |
| Forum: Database Design Nov 5th, 2008 |
| Replies: 24 Views: 2,154 OK ... I understand how this works now as far as retrieving data from the database (at least conceptually if not actually), but I am a bit confused in terms of the insert. I believe I would have to... |
| Forum: Database Design Nov 5th, 2008 |
| Replies: 24 Views: 2,154 So, this is what I have.
dB diagram (http://fsmgroup.zuka.net/assets/images/temp/db_v.110508.03.png)
Would this not make the table users_airports_link redundant?
If you have the time, with... |
| Forum: Database Design Nov 5th, 2008 |
| Replies: 24 Views: 2,154 Humm ... correct me if I am wrong but I am not sure if this is quite right and it is probably due to my lack of clarity in this.
All airports offer all three of the services in question. What is... |
| Forum: Database Design Nov 5th, 2008 |
| Replies: 24 Views: 2,154 Sorry .. one other question: The tables airport and service are concerning me a bit.
First, the user can be a member of up to 9 different airports and then, for each airport, that user can have... |
| Forum: Database Design Nov 5th, 2008 |
| Replies: 24 Views: 2,154 updated dB diagram (http://fsmgroup.zuka.net/assets/images/temp/db_v.110508.02.png)
Does this look correct? I seems to make sense to me. If it is correct, can you explain how inserts work with... |
| Forum: Database Design Nov 5th, 2008 |
| Replies: 24 Views: 2,154 I will give that a try. Thanks for the response. I appreciate your time.
Dave |
| Forum: Database Design Nov 5th, 2008 |
| Replies: 24 Views: 2,154 Hello all,
I am designing a database and, while I have used simple databases before, I am by no means an expert on relational dB design and so am seeking advice and help.
The database... |
