C o r e
J a v a
Overview of DBMS
Truncate, Drop and Rename
All DML command
All TCL Command
All DCL Command
ORDER BY clause
Group BY clause
AND & OR operator
C + +
D B M S
" Without SQL, websites will never have any way to handle Databases for data. " H o m e
M o r e . . .
L a n g u a g e
Normalization of Database
Database Normalisation is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables.
Normalization is used for mainly two purpose,
Eliminating reduntant(useless) data.
Ensuring data dependencies make sense i.e data is logically stored.
Problem Without Normalization
Without Normalization, it becomes difficult to handle and update the database, without facing data loss. Insertion, Updation and Deletion Anamolies are very frequent if Database is not Normalized. To understand these anomalies let us take an example of Student table.
Updation Anamoly : To update address of a student who occurs twice or...
Please join StudyMode to read the full document