3 Comments on “What ensures that attributes in a table depend only on the primary key?”

1. Jamal Ahmed says:

   January 13, 2014 at 11:28 am

   check

   
   
   
   0

   
   
   
   0
2. Ahmed says:

   January 6, 2015 at 8:42 pm

   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

   
   
   
   0

   
   
   
   0
3. Ahmed says:

   January 6, 2015 at 8:45 pm

   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

   
   
   
   0

   
   
   
   0