Relational Data Base Management System
1. Overview of Database Management :
Data, Information and knowledge, Increasing use of data as a corporate resource, data
processing verses data management, file oriented approach verses database oriented
approach to data management; data independence, database administration roles,
DBMS architecture, different kinds of DBMS users, importance of data dictionary,
contents of data dictionary, types of database languages. Data models: network,
hierarchical, relational. Introduction to distributed databases.
2. Relational Model :
Entity - Relationship model as a tool for conceptual design-entities attributes and
relationships. ER diagrams; Concept of keys: candidate key, primary key, alternate key,
foreign key; Strong and weak entities, Case studies of ER modelling Generalization;
specialization and aggregation. Converting an ER model into relational Schema.
Extended ER features.
3. Structured Query Language :
Relational Algebra: select, project, cross product different types of joins (inner join, outer
joins, self join); set operations, Tuple relational calculus, Domain relational calculus,
Simple and complex queries using relational algebra, stand alone and embedded query
Introduction to SQL constructs (SELECT…FROM, WHERE… GROUP BY… HAVING…
ORDERBY….), INSERT, DELETE, UPDATE, VIEW definition and use, Temporary
tables, Nested queries, and correlated nested queries, Integrity constraints: Not null,
unique, check, primary key, foreign key, references, Triggers. Embedded SQL and
Application Programming Interfaces.
4. Relational Database Design :
Normalization concept in logical model; Pitfalls in database design, update anomalies:
Functional dependencies, Join dependencies, Normal forms (1NF, 2NF, 3NF). Boyce
Codd Normal form, Decomposition, Multi-Valued Dependencies, 4NF, 5NF. Issues in
physical design; Concepts of indexes, File organization for relational tables, Denormalization.
5. Introduction to Query Processing and Protecting the Database &
Data Organizations: Parsing,
translation, optimization, evaluation and overview of Query Processing. Protecting the
Data Base -Integrity, Security and Recovery. Domain Constraints, Referential Integrity,
Assertion, Triggers, Security & Authorization in SQL.
Mr. UMESH KUMAr, MCA (GGU) PAGE | 2