THIRD SEMESTER COMPUTER
DATABASE MANAGEMENT SYSTEMS
UNIT- I
Overview of Database Management System: introduction to data. information, database, database management systems, file-based system. Drawback of file-Based System, database approach, Classification of Database Management System. advantages of database approach, Various Data Models. Components of Database Management System, three schema architecture of data base.
UNIT II
Entity-Relationship Model: introduction, the building blocks of an entity relationship diagram, classification of entity set, attribute classification, relationship degree, relationship classification, reducing ER diagram to tables, enhanced entity-relationship model (EER model), generalization and specialization, l5 A relationship and attribute inheritance, constraint, on specialization and generalization, advantages of ER modelling.
UNIT lll
Relational Model: introduction, CODD Rules, relational data model, concept of key. relational integrity, relational algebra, relational algebra operations, advantages of relational algebra. limitations of relational algebra, relational calculus. tuple relational calculus, domain relational Calculus (DRC), Functional dependencies and normal forms up to 3rd normal form.
UNIT lV
Structured Query Language: Commands in SQL Data Types in SQL' Data Definition language'Selection Operation, Projection Operation, Aggregate functions, Data Manipulation Language. Table Modification Commands. Join Operation' Set Operation. View, sub Query'
UNlT- V
PL/SQL: introduction, Shortcomings of SQL- Structure of PL/SQL PL/SQL Language Elements. Data Types, Operators Precedence. Control Structure, Step, to Create a PI,/SQL, Program, iterative Control'Procedure. Function, Database Trigger Types of Triggers.