"Knowledgy" <atlanta business intelligence consultantswrot e in message
news:apqdnaVJxf KY-FranZ2dnUVZ_qOk nZ2d@comcast.co m...
What are you suggesting? That one should always create a new table when
adding a new attribute to the data model? Maybe use binary relations or 6th
Normal Form?
Even using 6NF you would still need to add to an existing table if you
needed to add an attribute to make a compound key. You could create a new
copy of the table instead I suppose but I fail to see why that would be
preferable to adding an attribute to an existing table.
--
David Portas
news:apqdnaVJxf KY-FranZ2dnUVZ_qOk nZ2d@comcast.co m...
It's called abstraction and proper database design
>
--
Sincerely,
John K
Knowledgy Consulting
>
Atlanta's Business Intelligence and Data Warehouse Experts
>
>
>
--
Sincerely,
John K
Knowledgy Consulting
>
Atlanta's Business Intelligence and Data Warehouse Experts
>
>
adding a new attribute to the data model? Maybe use binary relations or 6th
Normal Form?
Even using 6NF you would still need to add to an existing table if you
needed to add an attribute to make a compound key. You could create a new
copy of the table instead I suppose but I fail to see why that would be
preferable to adding an attribute to an existing table.
--
David Portas