Scribd
Upload
26 views

DBMS

Uploaded by

Global Institute
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
26 views

DBMS

Uploaded by

Global Institute
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

PAPER: DATABASE MANAGEMENT SYSTEM (CODE: BSCITM302)

PAPER NAME: Database Management System

CREDIT: 5

PAPER CODE: BSCITM302

CONTACTS HOURS/ WEEK: 5L

Course Objective: After successful completion of this course, students will be able to:

To equip students with a comprehensive understanding of Database Management Systems


(DBMS), including its architecture, data models, and the roles of a Database Administrator
(DBA); to develop proficiency in designing and normalizing relational databases; to master
Structured Query Language (SQL) for various database operations; to understand and
implement transaction management, concurrency control, and database recovery techniques;
and to gain practical skills in PL/SQL programming for developing efficient and secure
database applications.

Course Outcome:
CO1 Explain DBMS fundamentals, architecture, and DBA roles.
CO2 Illustrate relational and ER models, keys, constraints, and normalization.
CO3 Use SQL for data definition, manipulation, control, and complex queries.
CO4 Analyze transaction management, concurrency control, and recovery
techniques.
CO5 Write and manage PL/SQL code for efficient database applications.

UNITS COURSE CONTENT


1 Basic Concept: (9L)
Database Management System, File based system, Advantages of DBMS over file
based system, Database Approach, Logical DBMS Architecture, Three level
architecture of DBMS or logical DBMS architecture, Need for three level
architecture, Physical DBMS Architecture, Database Administrator (DBA)
Functions & Role, Data files indices and Data Dictionary Types of Database,
Relational and ER Models: Data Models, Relational Model, Domains, Tuple and
Relation, Super keys, Candidate keys , Primary keys and foreign key for the
Relations, Relational Constraints, Domain Constraint, Key Constraint, Integrity
Constraint,- Update Operations and Dealing with Constraint Violations, Relational.
Operations Entity Relationship (ER) Model:
Entities, Attributes, Relationships, More about Entities and Relationships,
Conversion of E-R Diagram to Relational Database.
2 Database Integrity and Normalization: (8L)
Relational Database Integrity, The Keys, Referential Integrity, Entity Integrity,
Redundancy and Associated Problems, Single Valued Dependencies, Normalization,
Rules of Data Normalization, The First Normal Form, The Second Normal Form,
The Third Normal Form, Boyce CODD Normal Form, Attribute Preservation,
Losslessjoin Decomposition, Dependency Preservation.
3 Structured Query Language (SQL): (9L)
Meaning, SQL commands, Data Definition Language, Data Manipulation Language,
Data Control Language, Transaction Control Language, Queries using Order by,
Where, Group by, Nested Queries. Joins, Views, Sequences, Indexes and Synonyms,
Table Handling
4 Transaction and Concurrency Management: (7L)
Transactions, Concurrent Transactions, Locking Protocol, Serializable Schedules,
Locks Two Phase Locking (2PL), Deadlock and its Prevention, Optimistic&
Pessimistic Concurrency Control. Database Recovery and Security: Database
Recovery meaning, Kinds of failures, Failure controlling methods, Database errors,
Backup & Recovery Techniques, Security & Integrity, Database Security
Authorization
5 PL/SQL: (7L)
Introduction to PL/SQL, Variables & Data types, Basic blocks, Conditional &
branching statement, Handling of Cursor, Trigger, Function, Procedure, Package and
Exception.
Reference Books:

 Silverchatz, Korth&Sudarshan-Data Base System Concepts, MH.

 Elmasri, Navathe- Fundamentals of Database Systems, Pearson

 C J date-An Introduction to Database, Addison-Wesley Publishing Company

 Majumder & Bhattacharyya-Data Base Management Systems, TMH

 Feuerstein-Oracle PL/SQL Programming,SPD/O’REILLY

 Leon-Data Base Management Systems, VIKAS

 Kroenke-Data Base Processing:Fundamentals, Design &Implementation,PHI

 P.S Deshpande-SQL PL/SQL for Oracle 8 & 8i, Wiley Dreamtech

 P. Bhatia, S. Bhatia, G. Singh- Concepts of Database Management System, Kalyani


Publishers

You might also like