Database Design Question/Problem
-
I am looking at the Northwind database. When I open the category table, it brings a table which looks like table inside table. That may not be the way to say it. I believe that may be based on relationship. When I clicked on the plus sign, it opened a child table, then when the child table open, I clicked on the plus sign again, then it opened another child table. I assume that is because of the relationship.
mfcuser wrote:
I assume that is because of the relationship.
Yes, you assumed correctly :)
You will see a delete button on each of your posts. Press it. - Colin Angus Mackay
-
I am looking at the Northwind database. When I open the category table, it brings a table which looks like table inside table. That may not be the way to say it. I believe that may be based on relationship. When I clicked on the plus sign, it opened a child table, then when the child table open, I clicked on the plus sign again, then it opened another child table. I assume that is because of the relationship.
mfcuser wrote:
When I open the category table, it brings a table which looks like table inside table
That is a manifestation of the user interface. There is no table within a table.
mfcuser wrote:
I believe that may be based on relationship.
That is correct.
mfcuser wrote:
When I clicked on the plus sign, it opened a child table, then when the child table open, I clicked on the plus sign again, then it opened another child table. I assume that is because of the relationship.
Yes. There are a number of relationships in the Northwind database.
Upcoming Scottish Developers events: * We are starting a series of events in Glasgow in 2007. Are you interested in a particular subject, or as a speaker? * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog | Photos