UNIT 1.................................................................7
Database Management System
1.1 Introduction of Basic Concept and Definitions DBMS - Data and Information, Data Vs. Information, Data Dictionary, Data Item or Field, Record
1.2 Definition of DBMS
1.3 Applications of DBMS
1.4 Advantages and Disadvantages of DBMS
1.5 Users of DBMS - Database Designers, Application programmer, Sophisticated Users, End Users
UNIT 2..................................................................13
Relational Model
2.1 Basic Terms – Relation, Tuple, Attribute, Cardinality, Degree of relationship set, Domain
2.2 Keys - Super Key, Candidate Key, Primary Key, Foreign Key
UNIT 3..................................................23
Relational Algebra Operations
3.1 Preliminaries
3.2 Relational Algebra – Select, Project, Union, Difference, Intersection, Cartesian Product, Natural Join
UNIT 4.................................................36
Queries in DBMS
4.1 Introduction
4.2 History Of SQL
4.3 Basic Structure
4.4 DDL Commands
4.5 DML Commands
4.6 Simple Queries
4.7 Aggregate Functions
Practical Assignment on DBMS.........................57
