Back close

Course Detail

Course Name Database Management System
Course Code 18CSA114
Program B. C. A., B. C. A., B. C. A. (Bachelor of Computer Applications)
Semester Two
Credits Four
Year Taught 2018
Degree Undergraduate (UG)
Campus Kochi, Mysuru, Amritapuri

Syllabus

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

Text Books

Text Book

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

References

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

DISCLAIMER: The appearance of external links on this web site does not constitute endorsement by the School of Biotechnology/Amrita Vishwa Vidyapeetham or the information, products or services contained therein. For other than authorized activities, the Amrita Vishwa Vidyapeetham does not exercise any editorial control over the information you may find at these locations. These links are provided consistent with the stated purpose of this web site.

Admissions Apply Now