Assumed that an employee (pegawai) is only one officer on the field (bagian), and a field consisting of several officers. An employee only to be leaders in one field only. Some employees can do some projects, as well as vice versa. And the project is done only on one field (bagian) and the field (bagian) can do a lot of projects. Every employee in the work are controlled by someone who came from the employees. Employees also have dependents, such as family and others.
Relational Database Schema
Relational database schema on every table was already shaped 3NF.
- 1NF requirement has been fulfilled, namely: there are no multivalued atribute or nested relations.
- Terms of 2NF was fulfilled, namely: no nonkey every attribute to be functionally dependent on a part of the primary key.
- 3NF terms have been met, namely: there is no transitive dependency. A fuctional dependency X -> Y in a relation schema R is a transitive dependency if there is a set of attributes Z that is neither a candidate key nor a subset of any key of R, and both X -> Z and Z -> Y hold.