Scribd
Upload
65 views

20cs413-Database Management Systems

Uploaded by

banupriyar
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
65 views

20cs413-Database Management Systems

Uploaded by

banupriyar
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/ 1

K.S.R.

COLLEGE OF ENGINEERING (Autonomous) R 2020


SEMESTER – IV
L T P C
20CS413 DATABASE MANAGEMENT SYSTEMS
3 0 0 3
Prerequisite: Basic Knowledge about data structures and computer systems.
Course Outcomes: On Completion of this course , the student will be able to Cognitive level
CO1: Be aware of database architecture and the relational algebra. Understand
CO2: Apply Structured query language to create and manipulate a relational database. Apply
CO3: Create functions, triggers, recursive queries and indexing. Apply
CO4: Demonstrate the purpose of ER Model and normalization. Analyze
CO5: Discover about transaction, query processing and advanced database concepts. Understand
UNIT – I BASIC CONCEPTS AND RELATIONAL MODEL [9]
Database System Applications – Purpose of Database Systems – Views of Data – Database Languages – Database and
Application Architecture. Introduction to Relational Model: Structure of Relational Databases – Database Schema – Keys
– Schema Diagrams – Relational Algebra.
UNIT – II SQL FUNDAMENTALS AND INTERMEDIATE SQL [9]
Overview of the SQL Query Language – SQL Data Definition – Basic Structure of SQL Queries – Additional Basic
Operations – Set operations – Null values – Aggregate functions – Nested Sub Queries – Modification of the Database –
Join Expressions – Views – Transactions – Integrity Constraints – Authorization.
UNIT– III ADVANCED SQL, INDEXING AND HASHING [9]
Accessing SQL from Programming Language – Functions and Procedures – Triggers – Recursive Queries – Indexing:
Basic Concepts – Ordered Indices – B+ Tree Index Files – Hash Indices – Multiple-Key Access – Creation of Indices –
Bitmap Indices.
UNIT – IV DATABASE DESIGN [9]
Overview of the Design Process – The Entity-Relationship model – Complex Attributes – Mapping Cardinalities – Primary
key – Functional Dependencies – Non-loss Decomposition – First, Second and Third Normal Forms, Dependency
Preservation – Boyce/Codd Normal Form – Multi-valued Dependencies and Fourth Normal Form – Join Dependencies
and Fifth Normal Form.
UNIT – V TRANSACTIONS, QUERY PROCESSING AND ADVANCED DATABASE CONCEPTS [9]
Transaction Concept – A Simple Transaction Model – Storage Structure – Transaction Atomicity and Durability –
Transaction Isolation – Serializability – Concurrency Control – Lock-Based protocols – Query Processing overview –
Spatial Database Concepts – Multimedia Database Concepts – Introduction to Deductive Databases.
Total = 45 Periods
Text Books :
1 Abraham Silberschatz, Henry F. Korth and S. Sudharshan, Database System Concepts, Tata McGraw Hill, New
Delhi, Seventh Edition, 2019.
2 Ramez Elmasri and Shamkant B. Navathe, Fundamentals of Database Systems, Pearson Education, New Delhi,
Seventh Edition, 2016.
References :
1 Abraham Silberschatz, Henry F. Korth and S. Sudharshan, Database System Concepts, Tata McGraw Hill, New
Delhi, Sixth Edition, 2015.
2 S.K.Singh, Database Systems Concepts, Design and Applications, Pearson Education, New Delhi, second
Edition, 2011.
3 C.J.Date, A.Kannan and S.Swamynathan, An Introduction to Database Systems, Pearson Education, New Delhi
Eighth Edition, 2006.
4 http://freevideolectures.com/course/2668/database-management-system#

You might also like