Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
The definition and explanation of first normal form (1nf), second normal form (2nf), and third normal form (3nf) in the context of database normalization. It includes examples of various tables and their normalization status. The document also mentions the importance of normalization in eliminating redundancy and improving data consistency.
Typology: Slides
1 / 74
This page cannot be seen from the preview
Don't miss anything!
1
Introduction What is this project? Normalization of Database First Normal Form(1NF) Second Normal Form(2NF) Third Normal Form(3NF) Normalization of Tables Employee Supervisor Materials Store Item Finance Manager Project Manager
2
Financial Assets Cost Project Project Specifications Store In charge Plots Shops Task Logistic Assets Commission Agents Payments Customer Order Vendor Third Party
4
This System will enable the Civil Engineering, Human Resources and Finance Department of Ashyana Developers to perform the different operations and process related to the construction projects in an efficient way. This system will enable the organization to manage their resources in such a way so that project deadlines should be met within the estimated time and cost.
5
The system is mainly divided into three modules which are:
7
Semester Description 7 th^ Semester (Final) Normalization of Database up to Third Normalization Form (3NF). Installation of Oracle E-Business Suite.
8
Definition: “The process of decomposing relations with anomalies to produce smaller and well structured relations is called normalization.”
10
Definition: “A relation is in second normal form(2NF) if and only if it is in first normal form and all the partial dependencies have been removed key .”
11
Definition: “A relation is in third normal form(3NF) if it is in second normal form and all the transitive dependencies have been removed.”
13
3NF: Table is not in 3NF form because PhoneNumber and Emp-Address depend on NIC.
Emp-NIC NIC Emp-Name Phone Number Emp-Address
Employee Emp-ID Designation Emp-Password Pay Date ofJoining NIC
14
1NF: Table is already in 1NF Form, it contains no multi valued attribute. 2NF: Table is already in 2NF Form, it contains no partial dependency. 3NF: Table is already in 3NF form because there is no transitive dependency between nonkey attributes.
SM-ID StoreIn-ID
16
1NF: Table is already in 1NF Form, it contains no multi valued attribute. 2NF: Table is already in 2NF Form, it contains no partial dependency. 3NF: Table is already in 3NF form because there is no transitive dependency between nonkey attributes.
FM-ID Company Assets-ID
17
1NF: Table is already in 1NF Form, it contains no multi valued attribute. 2NF: Table is already in 2NF Form, it contains no partial dependency.
PM-ID Project-ID Cost-ID
19
1NF: Table is already in 1NF Form, it contains no multi valued attribute. 2NF: Table is already in 2NF Form, it contains no partial dependency. 3NF: Table is already in 3NF form because there is no transitive dependency between nonkey attributes.
Bank Account Number Balance Withdrawals Deposits
20
1NF: Table is already in 1NF Form, it contains no multi valued attribute. 2NF: Table is already in 2NF Form, it contains no partial dependency. 3NF: Table is already in 3NF form because there is no transitive dependency between nonkey attributes.
Cost-ID Project-ID Estimated-Cost Original-Cost
