[go: up one dir, main page]
Scribd
Upload
35 views2 pages

Database Systems Course Guide

The document outlines the course CAP206: Database Management Systems. The course aims to help students (1) understand database concepts and DBMS software, (2) apply SQL queries to large datasets, and (3) analyze concepts like normalization, transactions, concurrency control and recovery in databases. The course covers fundamentals of DBMS, relational database design using SQL, database design principles, transaction management, concurrency control, recovery, and distributed databases. Students will implement practical experiments on DDL, DCL, DML statements, keys, joins and functions. The recommended textbooks are Database System Concepts and SQL, PL/SQL The Programming Language of Oracle.

Uploaded by

priyam12111763
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
35 views2 pages

Database Systems Course Guide

The document outlines the course CAP206: Database Management Systems. The course aims to help students (1) understand database concepts and DBMS software, (2) apply SQL queries to large datasets, and (3) analyze concepts like normalization, transactions, concurrency control and recovery in databases. The course covers fundamentals of DBMS, relational database design using SQL, database design principles, transaction management, concurrency control, recovery, and distributed databases. Students will implement practical experiments on DDL, DCL, DML statements, keys, joins and functions. The recommended textbooks are Database System Concepts and SQL, PL/SQL The Programming Language of Oracle.

Uploaded by

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

CAP206:DATABASE MANAGEMENT SYSTEMS

L:2 T:0 P:2 Credits:3

Course Outcomes: Through this course students should be able to

CO1 :: understand the database concepts and database management system software

CO2 :: apply SQL queries to fetch information from large datasets

CO3 :: analyze the concept of normalization, transaction, concurrency control and recovery in
database
CO4 :: analyze use of distributed databases in industry applications

Unit I
Fundamentals of DBMS : Difference between Conventional file system and DBMS, Components of
DBMS, Architecture of DBMS, Different data models, Data independence, Various types of constraints
Unit II
Relational Databases Design : Structure of relational databases,, Relational Algebra,, Views,, Basic
structure of SQL Queries,, DDL statements, DCL statements, Joins in databases
Unit III
Database Design : Design guidelines,, Pitfalls in relational database design,, DBA, responsibilities of
DBA,, Need of Normalisation,, first normal form, second normal form, third normal form, forth normal
form, fifth normal form,, Types of dependencies
Unit IV
Transaction Management : Concept of Transaction,, Desirable properties of transactions (ACID),,
Schedules, Serializability of schedules, Recoverability
Unit V
Concurrency Control and Recovery : Lock-Based Protocols,, Deadlock Handling,, Multiple
granularity,, Timestamp-Based Protocols,, Validation-based protocols,, Failure Classification,, Buffer
management,, Failure with Loss of Nonvolatile Storage,, Log based recovery,, Shadow paging
Unit VI
Distributed Databases : Introduction to distributed databases,, Client /Server Databases,, Data
Fragmentation,, Replication and Allocation Techniques,, semi-join,, Homogeneous and Heterogeneous
Databases,, Distributed Data Storage,, Distributed Transactions,, Cloud-Based Databases

List of Practicals / Experiments:

List of programs
• Implementation of DDL Statements

• Implementation of DCL & DML Statements

• Implementation of Integrity Constraints

• Implementation of Null and Default Constraint

• Implementation of different types of Keys

• Implementation of JOINS( Inner, Left, Right, Full, Self)

• Implementation of various In-built Functions

Text Books:
1. DATABASE SYSTEM CONCEPTS by AVI SILBERSCHATZ HENRY F. KORTH S. SUDARSHAN,
MC GRAW HILL
References:
1. SQL, PL/SQL THE PROGRAMMING LANGUAGE OF ORACLE by IVAN BAYROSS, BPB
PUBLICATIONS

Session 2022-23 Page:1/2


Session 2022-23 Page:2/2

You might also like