I'm a novice and I'm confused. Maybe it's the way I think. I feel like there is an easier way that I'm overlooking, but I can't seem to get a satisfactory solution.
How would YOU create your tables/relationships if you had the following:
* The general purpose is to manage orders
* You have to store information about the order (like order number, date)
* You have to store information about from what company the order is from (like address)
* You have to store information about from which department of that company the order comes from, each department has their own information that needs to be stored (like contact person).
Keep in mind that you don't want to memorize which department is from which company nor do you want to be able to make the mistake of entering an order from a department that is not a part of that company.
It seems like it should be an easy thing to do, but I'm stumped. I've thought about creating a new table for every company with a sub table for every department but that doesn't seem very practical. I tried creating one table called Company and one called Department, then merging them on a third table which is then linked to a fourth table called Orders. I'm not convinced this is the best way to do it, but it's my best guess at this moment.
All help is greatly appreciated.
How would YOU create your tables/relationships if you had the following:
* The general purpose is to manage orders
* You have to store information about the order (like order number, date)
* You have to store information about from what company the order is from (like address)
* You have to store information about from which department of that company the order comes from, each department has their own information that needs to be stored (like contact person).
Keep in mind that you don't want to memorize which department is from which company nor do you want to be able to make the mistake of entering an order from a department that is not a part of that company.
It seems like it should be an easy thing to do, but I'm stumped. I've thought about creating a new table for every company with a sub table for every department but that doesn't seem very practical. I tried creating one table called Company and one called Department, then merging them on a third table which is then linked to a fourth table called Orders. I'm not convinced this is the best way to do it, but it's my best guess at this moment.
All help is greatly appreciated.
