What ensures that attributes in a table depend only on the primary key?
A.
Referential integrity
B.
The database management system (DBMS)
C.
Data Normalization
D.
Entity integrity
What ensures that attributes in a table depend only on the primary key?
What ensures that attributes in a table depend only on the primary key?
check
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table ) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored
http://databases.about.com/od/specificproducts/a/normalization.htm
Entity Integrity
Entity integrity defines a row as a unique entity for a particular table. Entity integrity enforces the integrity of the identifier column(s) or the primary key of a table (through indexes, UNIQUE constraints, PRIMARY KEY constraints, or IDENTITY properties).
Details here:
http://technet.microsoft.com/en-us/library/aa933058%28v=SQL.80%29.aspx