For UGC/ NTA NET exam, one of the important topic is database management system. About 2-3 questions come from this chapter. This needs about 8 hours. 4 hours to complete the theory portion and 4 hours for the question answer solve of previous years. A database is an organized set of data stored in a computer that can be search automatically.
A database is a self describing collection of integrated records. It is self describing because it contains as part of itself a directory or dictionary of its context. According to the net syllabus,
ER Diagrams :
E-R diagrams and
their transformation to relational design
Normalization :
Normalization – 1NF, 2NF, 3NF, BCNF and 4NF
Limitations of 4NF and BCNF
SQL :
Data Definition Language (DDL),
Data Manipulation Language (DML),
Data Control Language (DCL) commands
Database objects like-Views,
indexes, sequences, synonyms, data dictionary
Sample questions:
| The normalization of 1NF relations to 2NF involves: | |
| A. | Removal of partial dependencies |
| B. | Removal of full dependencies |
| C. | Removal of transitive dependencies |
| D. | Removal of multi-valued dependencies |
View this Course
Certified
You have 
