2007-03-17

DB View : Retail Inventory Mgmt

note the data fields which hold, in this example, an inventory of musical instruments where various colors (or other differences) are listed, vs the second table shown.


i also have a table which holds only each item's respective "Manufacturer" info, so i don't think i want that here-- therefore, i should remove the Manufac. names from the "nickname" (3rd field, top table) and keep it only in the Manufacturer's table.

I wonder: Is this as close as i might come to the 3rd normal form for these data types?...

1 comment:

ZiggyStardust said...
This comment has been removed by the author.