COURSE SUMMARY
Course Title: 
Database Management System
Course Code: 
18CSA114
Year Taught: 
2018
Semester: 
2
Degree: 
Undergraduate (UG)
School: 
School of Engineering
Campus: 
Amritapuri

'Database Management System' is a course offered in the second semester of B. C. A. (Bachelor of Computer Applications) program at School of Engineering, Amrita Vishwa Vidyapeetham, Amritapuri.

UNIT 1

Introduction - Data Independence - The Three Levels Of Architecture - The External Level - Conceptual Level - Internal Level - Client/Server Architecture- System Structure , Instance and schema, Data Models, Types of DBMS

UNIT 2

Keys - CODD’s Rules, Design Issues -ER – Model –Attribute types- Weak Entity Sets - Extended ER Features –ER to Relational Mapping, Structure Of Relational Databases

UNIT 3

Normalization –Anomalies- Functional Dependency: Armstrong’s axioms- closure of a relation and closure of attribute– Lossless decomposition-1NF, 2NF, 3NF, Boyce - Codd Normal Form

UNIT 4

The Relational Algebra -- Query Processing and Optimization: Evaluation of Relational algebra expressions-Query Equivalence-Transaction Processing: ACID properties, states of a transaction-Introduction to concurrency control-Deadlock-Recovery.

UNIT 5

Built in SQL functions- Set operations, Sub Queries-Joins-DCL – TCL- Views – Sequences – Index – Locks PL/SQL Basics – Exceptions – Cursors - Stored Functions – Triggers

TEXTBOOKS:

  • Silberschatz. Korth. Sudarshan: Database System Concepts - 6thEdition Mcgraw-Hill International Edition
  • Ivan Bayross: Sql- PL/SQL The Programming Language Of Oracle- 4rd Edition- Bpb Publications

REFERENCE

  • C.J. Date: An Introduction To Database Systems - Eighth Edition - Pearson Education Asia
  • Kevin Loney - George Koch: Oracle 9i The Complete Reference Mcgraw-Hill International Edition
  • “Fundamentals of Database Systems” by Elmasri and Navathe