08-16-2017, 10:08 PM
normalization in database with example ppt free download
Database normalization is the process of making the data in a database available in the most organized way possible. It is one of the first concepts you will learn when studying database management, as you might in a course like SQL Database For Beginners.
When you re normalizing a database, there are two things you need to consider: whether the information in the database has internal redundancies, and whether the dependencies across the different tables in the database are logically organized.
The term normalization comes from the concept of normal forms, which describe just how organized the information is in the database. But normal forms were developed around the concept of a table-based relational database, which you need to learn about in order to understand database normalization. You might want to take a course like this one in RDBMS Concepts to get started. Normal forms are designed to enable the most straightforward approaches is for searching across information when it is structured in this manner.
As an example, let s imagine we re creating a database of the children in a class, and the pets they have. When starting to build this database, the first approach might be to create a simple table with all of the information in one place, and one row for each student.