- Jan 6, 2005
- 14,698
- 1,909
- 126
I recently received an assignment at work to develop a fairly complex database, that consists of numerous "many to many" relationships. Similarly, the expectation is that I create a user interface that will allow my team to run various queries against the data that will populate this database.
I have one graduate level database class under my belt. I know how to construct databases at the most fundamental level, but I have little to no experience in developing complex architectures that will reside underneath a user interface.
I have searched various web forums, but all of them seem to presume a fairly thorough understanding of Access.
I need something a bit more fundamental yet comprehensive...a college/graduate level or similar reference book that can take my understanding beyond the fundamentals into more complex design approaches.
Thing is, such books tend to be rather expensive, and I would assume that there are better resources available then those sold at the local Barnes and Noble.
So, can anyone recommend a good crash course book for complex database design? More specifically, I will have to tackle the following tasks:
1. Resolve numerous many to many relationships...I know how to split tables to resolve these relationships, but I need to go one step further and understand how to apply concatenated fields to link various data...a book or resource that is chock full of real world application examples would be ideal, as I can probably port these case studies into application for what I need to do.
2. Validate the database architecture to ensure there are no data collisions.
3. Build a user friendly interface that will enable users to input, modify, and run queries on the database.
Thank you in advance for your help.
I have one graduate level database class under my belt. I know how to construct databases at the most fundamental level, but I have little to no experience in developing complex architectures that will reside underneath a user interface.
I have searched various web forums, but all of them seem to presume a fairly thorough understanding of Access.
I need something a bit more fundamental yet comprehensive...a college/graduate level or similar reference book that can take my understanding beyond the fundamentals into more complex design approaches.
Thing is, such books tend to be rather expensive, and I would assume that there are better resources available then those sold at the local Barnes and Noble.
So, can anyone recommend a good crash course book for complex database design? More specifically, I will have to tackle the following tasks:
1. Resolve numerous many to many relationships...I know how to split tables to resolve these relationships, but I need to go one step further and understand how to apply concatenated fields to link various data...a book or resource that is chock full of real world application examples would be ideal, as I can probably port these case studies into application for what I need to do.
2. Validate the database architecture to ensure there are no data collisions.
3. Build a user friendly interface that will enable users to input, modify, and run queries on the database.
Thank you in advance for your help.
Facebook
Twitter