UNIT: 1 Overview of Database Management System :
Introduction to Data and Database system, Elements of Database system, DBMS and its 3-tire architecture, Advantages of DBMS (including Data independence), Types of user, Type of Data Base Administrator and their functions.
UNIT: 2 Data Models:
Type of Data Models, Detailed Study of Relational model (Properties of relational model, key and Integrity rules), Comparative study between different type of data models, advantage and disadvantages of data models.
UNIT: 3 Normalization and Functional Dependency:
Normalization, Need of Normalization, Anomalies associated with Normalization, Functional Dependencies and its Properties, Normal form (1NF, 2NF, 3NF, BCNF).
UNIT: 4 SQL:
Introduction, Data definition, views and queries in SQL, SQL construct, Type of SQL (Brief Overview), SQL Join: Multiple table queries, Built-in functions, Specifying constraints and indexes in SQL, Data Manipulation, Data maintenance, Multiple Table Operations, Transaction integrity facilities, Overview of ORACLE; (Data Type, DDL, DML, DCL).
UNIT: 5 Database Security, Integrity and Control:
Security and Integrity threats, Defence mechanism, Integrity, Recent trends in DBMS, Distributed and Deductive databases.
SUGGESTED READINGS:
- 1. C.J. Date, "An introduction to Database system: Vol. 1, Addision Weseley.
- 2. Bipin Desai, "An introduction to Database system", Galgotia Publications, New Delhi.
- 3. Korth, “Database and its Concept”, TMH.
- 4. DBMS, Katson Publication, New Delhi