about normalization in database with example ppt free download in to the right box for getting free material and support from us/dedicated premium members...
kindly send, for the class work of MCA 3rd sem of MVGR College of Engineering vizainagram,
need student management system normalization
Posts: 8,059
Threads: 1
Joined: Mar 2014
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.
