normalization_Hamdard University Bangladesh.pptx

normalization_Hamdard University Bangladesh.

1. Hamdard University Bangladesh Course Teacher Subject :Database Management System Md . hahidul Islam Lecturer Md. Shahidul Islam   Lecturer  Department  of   Computer Science  &  Engineering

2. Database Normalization Presented by: Amith Hassan Rohan ID : 315221029 Dept: b.sc in CSE Batch: 2   Topic:

3. About This Session Introduction What ­Is­ Database­ Normalization? What ­are ­the ­Benefits­ of­ Database ­Normalization? What ­are ­the ­Normal­ Forms? First­ Normal ­Form Second­ Normal­ Form Third ­Normal ­Form Forming­ Relationships Joining­Tables

4. Normalization: It is the process of organizing the data in the database. It is used to remove or reduce the redundancy from a relation INTRODUCTION

5. What is normalization? Normalization is the process of Organizing the data and the attributes of a database. • It performed to reduce the data redundancy in a database & ensure that data is stored logically. • Normalization is systematic approach of decomposing table to ellminare data redundancy and undesirable characteristics like insertion, updare and delete. • Normalization is multi-step process that puts dara in tubular form remove duplicate date from relation tables.

6. Id Name Address Profession

7. What are the Normal Forms? First Normal Form­ (1NF) Second Normal ­Form ­(2NF) Third­ Normal ­Form­ (3NF) Boyce-Codd­ Normal­ Form­ (BCNF) Fourth­ Normal­ Form ­(4NF) Fifth­ Normal ­Form ­(5NF)