ISM 671

produces a lower normal form; results in increased performance and greater data redundancy

insertion, deletion & update

• when one attribute is dependent on another; 
• student ID         -      student name
• Determinant      -      dependant

• it can only exist where there is a composite PK (the combination of 2 PKs).
• If an attribute (student grade) is dependent on both attributes from the PL (student ID & class ID) then we call it fully functionally dependent. If an attribute depends only on one of the PK then it is partial.

is when an attribute is dependent on another attribute (that is not a part of the PK); also known as non-key to non-key

no repeating groups; in this table, those are emp number, emp name, etc. 

 

First we need to break emp num into a separate row 

• required: table has to be in 1NF and no partial dependency
• In this case, if we know a proj num, we know the project name; this is partial dependency.