DATA BASE MANAGEMENT SYSTEM
UNIT: 1
Overview of Database management System: Introduction, Data and Information, Database, Database Management system, Objectives of DBMS, Evolution of Database Management System, Classification of Database Management System.
UNIT: II
File-Based System: File Based System. Drawbacks of File-Based System, DBMS Approach, Advantage of DBMS, Data models, Components of Database System, Database Architecture, DBMS Vendors and their products.
UNIT: III
Entity-Relationship Model: Introduction, The Building Blocks of an entity-Relationship, Classification of Entity Set, Attribute Classification, relationship Degree, Relationship Classification, Generalization and Specialization, Aggregation and composition, CODDs Rules, relational Data Model, Concept of Relational Integrity.
UNIT: IV
Structured Query Language: Introduction, History of SQL Standards, Commands in SQL, Data types in SQL, Data Definition Language(DDL), Selection Operation Projection Operation, Aggregate Functions, data Manipulation Language, Table Modification, Table Truncation, Imposition of Constraints, Set Operations.
UNIT: V
PL/SQL: Introduction Structure of PL/SQL, PL/SQL Language Elements, Data Types, Control Structure, Steps to Create a PL/SQL Program, Iterative Control Cursors, Steps to Create a Cursor, Procedure, Functions, packages, Exceptions Handling, Database Triggers, types of triggers.
No comments:
Post a Comment