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
This presentation is for final year project to complete degree in Computer Science. It emphasis on Applications of Computer Sciences. It was supervised by Prof. Ambuja Viral at Bengal Engineering and Science University. It includes: Normalization, Database, Normal, Form, Employee, Supervisor, Store, Item, Materials, Finance, Manager
Typology: Slides
1 / 79
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
AHSAN IBRAHIM CHOHAN (03-1-3-004-2005) MUNEEB IQBAL (03-1-3-020-2005)
14/01/
5
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.
7
Semester Description 6 th^ Semester SRS SPMP 7 th^ Semester (Mid Term) Use Cases Activity Diagrams Data Flow Diagram (DFDs) Identification of Entities and their attributes. Entity Relationship Diagram (ERD)
8
Semester Description 7 th^ Semester (Final) Normalization of Database up to Third Normalization Form (3NF). Installation of Oracle E-Business Suite.
10
Definition: “The process of decomposing relations with anomalies to produce smaller and well structured relations is called normalization.”
11
Definition: “A relation is in first normal form(1NF) if and only if every attribute is single valued for each tuple.”
13
Definition: “A relation is in third normal form(3NF) if it is in second normal form and all the transitive dependencies have been removed.”
14
1NF: Table is already in 1NF Form, it contains no multi valued attribute. 2NF: Table is already in 2NF Form because partial dependencies does not exist in the table.
Emp-ID Emp-Name Emp-Password Designation Payment-ID Pay Date ofJoining Emp-NIC PhoneNumber Emp-Address
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.
SM-ID StoreIn-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 functional dependency. 3NF: Table is already in 3NF form because there is no transitive dependency between nonkey attributes.
SI-ID Type Quantity Status Price
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.
PM-ID Project-ID Cost-ID
20
3NF: Table is not in 3NF Form because a transitive dependency exist that is Cost-ID depends on Project-ID.
Proj-Manager
Proj-Cost
PM-ID Project-ID
Cost-ID Project-ID
