Scribd
Upload
60 views1 page

DATABASE MANAGEMENT SYSTEMS

Uploaded by

Binith 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
60 views1 page

DATABASE MANAGEMENT SYSTEMS

Uploaded by

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

DATABASE MANAGEMENT SYSTEMS

Course Code L-T-P-Cr.: 3 0 0 3 Semester: V

Category: PC (CS)
Course Objectives: (1) To introduce students to the basic knowledge of Data Repository and Database
Models, Data Models, Database Schema. Concept of relational database
models, entity-relationship model, relational database design.
(2) Understanding, relational algebra, relational calculus, and SQL. Understanding
the concept of Functional dependencies and database normalization.
(3) Student will be introduced storage strategies for databases. Understanding
transaction systems and processing, database failures and recovery. To
impart Concepts for the implementation of various real life problems.
(4) Concept of query processing and optimization. Case study on advanced databases.

UNIT – I : INTRODUCTION TO DATABASE SYSTEMS AND DATA MODELS (9 Hours)


Introduction : Data vs Information, File based Information repository, concept of Database, Evolution of DB &
DBMS, Need for data management, Data models & Database Schema Architecture, components of DBMS,
Key issues and challenges in Database Systems, Applications of databases.
Logical database Models: Terminologies, ER Model - Conceptual data modeling, ER diagram notation,
ER Diagrams. EER Models, Relational Database Model, ER to Relational Mapping, Database Constraints-Keys,
Dependencies, examples.
UNIT – II : RELATIONAL DATABASE, AND DATABASE NORMALIZATION (9 Hours)
Database Languages: Relational Algebra, Relational Calculus, SQL - Types of Sublanguages, data definition,
Data Manipulation, data query, transaction control languages in SQL. Aggregation functions group by and
having clauses, embedded SQL.
Functional Dependencies and Normalization: Introduction to Functional Dependency and Normalization –
Concept of functional dependency, First, Second, Third & Fourth Normal Forms - BCNF – Join Dependencies-
other Normal forms
UNIT – III: PHYSICAL DATABASE DESIGN, TRANSACTIONS, RECOVERY (9 Hours)
Storage Strategies and Physical Database Design: B-Trees, Hashing, Indexing.
Introduction to Transactions and Recovery: Transaction Systems, Transaction Properties
(ACID Properties), Transaction schedule and its types- serial, non-serial, conflict serializable,
recoverable schedules, System failure & Recovery - Introduction, Two Phase Commit Protocol, Need
for Concurrency Locking Protocols, Deadlocks & Managing Deadlocks.
UNIT – IV : QUERY PROCESSING AND SPECIAL DATABASES (9 Hours)
Query Processing and Optimization: Query Tree, Evaluation of Relational Algebra Expressions,
Query Equivalence, Join strategies, Query Optimization Algorithms.
Introduction to Special Topics: Object Oriented Databases, XML & Web databases, Data
warehouses, No-SQL, Big Data, Spatial databases.
TEXT BOOKS:
(1) Elmaski & Navathe -Fundamentals of Database Systems, 4th Edition, Pearson Education
REFERENCE BOOKS:
(1) Database Systems, Thomas Connolly, Carolyn Begg
(2) Raghu Ramakrishnan, “Database Management Systems”, Third Edition, McGraw Hill.
(3) C.J. Date - An introduction to Database Systems, Pearson Education
(4) Avi Silberschatz, Henry F. Korth , S. Sudarshan,Database System Concepts
(5) Bipin Desai -An introduction to Database System, Galgotia Publication.

You might also like