week 7

The picture above has two errors are:
The integral from part of the project didn’t has relative cardinalities, otherwise the connections of the cardinalities between the integral part of the project is 1-N

In the picture also show the error the connection between employees, responsibility and project, that has been connect with . The conclusion that I can get is separate the connection of the employees and project and also the employees with the responsibility, so there isn’t connection more between responsibility and project.

This is the correct picture :




1NF/First Normal Form

A form of normal relations, said the first, if and only if every attribute value for every single line. Each field is only one definition, is not a collection of words that has two meanings, one meaning only and not the fraction is also the word - th

e word means so that the other. There is no set of attributes that\ repeatedly or attribute double value.




2NF/Second Normal Form

Second Normal form (NF 2) is:

1). Meets 1 of NF (normal first).
2). Non-key attributes must depend on the function key / primery key.
So that the second normal form for each table / file must be specified attribute keys.



Definition of Third Normal Form (NF 3) is:
1). Meet the 2 forms of NF (both normal).
2). Non-key attributes do not have a transitive dependency on the key / key primery.