Database Management System 14 Introduction to Database Normalization

DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data. Based on this we can define DBMS like this: DBMS is a collection of inter-related data and set of programs to store & access those data in an easy and effective manner.
What is the need of DBMS?
Database systems are basically developed for large amount of data. When dealing with huge amount of data, there are two things that require optimization: Storage of data and retrieval of data.
Storage: According to the principles of database systems, the data is stored in such a way that it acquires lot less space as the redundant data (duplicate data) has been removed before storage. Let’s take a layman example to understand this:
In a banking system, suppose a customer is having two accounts, one is saving account and another is salary account. Let’s say bank stores saving account data at one place (these places are called tables we will learn them later) and salary account data at another place, in that case if the customer information such as customer name, address etc. are stored at both places then this is just a wastage of storage (redundancy/ duplication of data), to organize the data in a better way the information should be stored at one place and both the accounts should be linked to that information somehow. The same thing we achieve in DBMS.
Fast Retrieval of data: Along with storing the data in an optimized and systematic manner, it is also important that we retrieve the data quickly when needed. Database systems ensure that the data is retrieved as quickly as possible.

01 Course content and Syllabus (DBMS)
02 Introduction to basic Terminologies in DBMS
03 Underlying Data Structures used in various types of DB
04 Introduction to Conceptual Design Using Entity Relationship model
05 Classification and Types of Attributes in a Relation
06 Degree of relationship set
08 Degree Cardinality Ratio and Participation
09 One to One relationship
10 Many to Many Relationship
11 Strong Entity vs Weak Entity
12 Basic Components in ER Diagram
13 How to Convert ER Diagram into Relation or Table
14 Introduction to Database Normalization
15 Basics of Functional Dependencies
16 Trivial and Non Trivial Functional Dependencies
17 Closure Properties of Functional Dependencies Armstrong's Axioms
18 Closure set of Attributes
19 Closure set of Functional Dependencies
20 How to Determine Keys in a relation Candidate key and Super Key
21 Determine the candidate keys in the relations
22 Identify the keys in the relations Examples
23 Equivalence in functional dependencies FD
24 Minimal Cover in Functional Dependencies
25 Introduction to decomposition of Relations
26 Lossless decomposition in Relations
27 Lossless decomposition
28 Functional dependency preserving decomposition
29 Whether these decomposition's are FD Preserving or not example
30 example on Functional dependencies Preserving Decomposition
31 Transitive, Partial and Full Functionally Dependency Prime non Prime
32 Introduction to Normalization in Databases
33 Introduction to second Normal Form 2NF
34 Second Normal Form 2nf Example