KEMBAR78
Database Management Systems Course | PDF | Databases | Relational Database
Scribd
Upload
102 views2 pages

Database Management Systems Course

This document outlines the objectives, topics, and outcomes of a course on Database Management Systems. The course covers fundamental concepts like data modeling, relational algebra, SQL, database design using ER diagrams and normalization. It also covers topics like transactions, concurrency control, recovery techniques, database implementation including indexing and query processing. The final unit covers advanced topics such as distributed databases, NoSQL databases, and database security. The course aims to help students construct SQL queries, design databases, handle transactions, apply indexing strategies, and choose suitable databases based on requirements.

Uploaded by

Suresh Kumar
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
102 views2 pages

Database Management Systems Course

This document outlines the objectives, topics, and outcomes of a course on Database Management Systems. The course covers fundamental concepts like data modeling, relational algebra, SQL, database design using ER diagrams and normalization. It also covers topics like transactions, concurrency control, recovery techniques, database implementation including indexing and query processing. The final unit covers advanced topics such as distributed databases, NoSQL databases, and database security. The course aims to help students construct SQL queries, design databases, handle transactions, apply indexing strategies, and choose suitable databases based on requirements.

Uploaded by

Suresh Kumar
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/ 2

CS3492 DATABASE MANAGEMENT SYSTEMS L T P C

3 0 0 3

OBJECTIVES:

 To learn the fundamentals of data models, relational algebra and SQL


 To represent a database system using ER diagrams and to learn normalization techniques
 To understand the fundamental concepts of transaction, concurrency and recovery processing
 To understand the internal storage structures using different file and indexing techniques
which will help in physical DB design
 To have an introductory knowledge about the Distributed databases, NOSQL and database
security

UNIT I RELATIONAL DATABASES 10

Purpose of Database System – Views of data – Data Models – Database System Architecture –
Introduction to relational databases – Relational Model – Keys – Relational Algebra – SQL
fundamentals – Advanced SQL features – Embedded SQL– Dynamic SQ

UNIT II DATABASE DESIGN 8

Entity-Relationship model – E-R Diagrams – Enhanced-ER Model – ER-to-Relational Mapping –


Functional Dependencies – Non-loss Decomposition – First, Second, Third Normal Forms,
Dependency Preservation – Boyce/Codd Normal Form – Multi-valued Dependencies and Fourth
Normal Form – Join Dependencies and Fifth Normal Form

UNIT III TRANSACTIONS 9

Transaction Concepts – ACID Properties – Schedules – Serializability – Transaction support in SQL –


Need for Concurrency – Concurrency control –Two Phase Locking- Timestamp – Multiversion –
Validation and Snapshot isolation– Multiple Granularity locking – Deadlock Handling – Recovery
Concepts – Recovery based on deferred and immediate update – Shadow paging – ARIES Algorithm

UNIT IV IMPLEMENTATION TECHNIQUES 9

RAID – File Organization – Organization of Records in Files – Data dictionary Storage – Column
Oriented Storage– Indexing and Hashing –Ordered Indices – B+ tree Index Files – B tree Index Files
– Static Hashing – Dynamic Hashing – Query Processing Overview – Algorithms for Selection,
Sorting and join operations – Query optimization using Heuristics - Cost Estimation.

UNIT V ADVANCED TOPICS 9

Distributed Databases: Architecture, Data Storage, Transaction Processing, Query processing and
optimization – NOSQL Databases: Introduction – CAP Theorem – Document Based systems – Key
value Stores – Column Based Systems – Graph Databases. Database Security: Security issues –
Access control based on privileges – Role Based access control – SQL Injection – Statistical Database
security – Flow control – Encryption and Public Key infrastructures – Challenges

TOTAL: 45 PERIODS
OUTCOMES:

Upon completion of the course, the students will be able to:

CO1: Construct SQL Queries using relational algebra

CO2: Design database using ER model and normalize the database

CO3: Construct queries to handle transaction processing and maintain consistency of the database

CO4: Compare and contrast various indexing strategies and apply the knowledge to tune the
performance of the database

CO5: Appraise how advanced databases differ from Relational Databases and find a suitable
database for the given requirement.

TEXT BOOKS:

1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Sixth Edition,
Tata McGraw Hill, 2011.

2. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, Sixth Edition,


Pearson Education, 2011.

REFERENCES:

1. C.J.Date, A.Kannan, S.Swamynathan, An Introduction to Database Systems”, Eighth Edition, Pearson


Education, 2006.

2. Raghu Ramakrishnan, “Database Management Systems”, Fourth Edition, McGraw-Hill College


Publications, 2015.

3. G.K.Gupta,"Database Management Systems”, Tata McGraw Hill, 2011.

HOD/CSE

You might also like