Back close
Admissions

Course Detail

Course Name Database Management Services
Course Code 24COM637
Program M. Com. (Finance & Systems)
Semester Elective
Credits 3
Campus Amritapuri

Syllabus

Unit 1

Introduction-What Is a Database System-Why Database-Data Independence-The Three Levels of Architecture-The External Level-Conceptual Level-Internal Level–Mappings – The Database Administrator – The Database Management System – Client/Server Architecture-Distributed Processing.

Unit 2

Basic Concepts – Constraints – Keys – Design Issues – ER-Model – Weak Entity Sets -Extended ER Features.

Unit 3

Hierarchical Data Model-The IMS Database System-Network Data Model–Normalization- Functional Dependency.

Unit 4

Selection Operation – Sorting – Join Operation – Sorting – Join Operation -Query Optimization- Transaction Concept-Transaction State.

Unit 5

SQL Basics-Classification of SQL–DDL–DML–DCL–TCL-SQL Reports–Views –Sequences – Index– Locks -PL/SQL Basics.

Course Objective and Outcomes

Course Objective:
The main objective is to provide the students understanding about fundamental concepts of database management system.

Course Outcomes:

CO1 Master the basic concepts of DBMS like data independence and three schema architecture.
CO2 Be familiar with the CODD’s rules and E-Model and also have clear picture about the structure of the relational databases.
CO3 Master the concept of normalization and different types of normalization.
CO4 Be familiar with the basics of query evaluation techniques and query optimization and also to get a clear picture about transaction processing.
CO5 Master the basics of SQL and construct queries using SQL and also write programs using PL/SQL.

Textbooks/ Reference Books

Textbooks

  1. Abraham Silberschatz, Henry F. Korth, S. Sudarshan – Database System Concepts – McGraw Hill
  2. Kevin Loney, George Koch – Oracle 9i The Complete Reference – McGraw Hill

Reference Books:

  1. C.J. Date – Introduction to Database Systems – Narosa Publishing.
  2. Ivan Bayross – SQL, PL/SQL – The Programming Language of Oracle – BPB Publication

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