Search results

Doc Man, Thank you for your response. I really appreciate it! I looked over quite a few sites explaining the workings of entity-relationship models, and though they had many pictures to help explain, I still think your real world example is more intuitive. "Junction table" is another new term...

Thanks for the reply MarKK. I have read-up on 'normalization' and I believe I have an okay grasp on that. As far as 'entity-relationship modeling' that is a new term for me, but I think I have a basic grasp of that as well. Since I have never designed, or even seen the back-end of a database...

Note: This is just an example, in the end application there would be tens-hundreds of vehicles and hundreds-thousands of different inspections. Also, a more general question. What do you think of the overall structure of the example database?

Hello All, I want to get a sanity check on how I am structuring a database I am building. For example: I am building a database to manage inspections on various vehicles. Right now we are inspecting Cars, Trucks, and Buses, but in the future we might want to also inspect Motorcycles. Each...

plog, Awesome! Somehow I overlooked the Extra Credit portion on my first read-through. Now I need to go through my relationships and evaluate when I need left/right joins as opposed to inner joins. Tyvm, Nathan

plog, Thank you for your response. That answers the why, though I need to read more on what all of the different SQL functions do. How would I build this query if I want to have results, even if there is no data in the tbl_OEMSN? I know that I could add a record to tbl_OEMSN with a Null value...

Hello All, This is my first post here, so I will give a bit of background on myself. I am a Mechanical Engineer a few years out of college, and I am working for a small company that repairs Aero-derivative gas turbine parts. I am trying to design an Access database to store information and...