DATABASE MANAGEMENT SYSTEM.
SEMESTER:-IV
IV CODE:-BCE4406
TEACHING AND EXAMINATION SCHEME
Examination Scheme Teaching Scheme
IE-20 Lectures: 3 Hrs/week
MTE: 30 Credit:-3
ETE :50
Examination Scheme Teaching Scheme
Oral Assessment: 50 Practical: 4 Hrs/Week
Term Work:25 Credit:2
Practical Assessment : 25
PLANNING FOR INTERNAL EVALUATION (IE)
Activity name and its Syllabus units or topics
rubric (on which contents IE
related activity is being
planned)
Planning for IE1 (10 marks) Case study based assignment Unit 1 & Unit 2
in class (2 questions 10marks)
Problem solving & students
participation during theory
lectures. ( students
performance will be observed
by subject teacher and marks
will be given out of 05
Planning for IE2 (10 marks) Open Book Test (2 questions Unit 4 & Unit 5
10marks)
Problem solving & students
participation during theory
lectures.
( students performance will be
observed by subject teacher
and marks will be given out of
05 )
DATABASE MANAGEMENT SYSTEM
• Prerequisites Courses:
1. Discrete Mathematics
2. Data Structures and Algorithms
Database Management System
• Relevance/Purpose of DBMS in Computer Engineering
Program:
Now a days data and databases are part of each and every organisation, it
touches every aspect of our life. Being Computer Engineer it is very important
and necessary to have the knowledge about Database Management Systems.
DBMS is core subject in Computer Engineering and base for Advanced
Databases and High Performance Databases. Computer Engineering
professionals are expected to know about various data models , relational
database design and database languages to work on any real time project / an
application
Database Management System
Course Objectives:
1. To understand the fundamental concepts of database management. These
concepts include aspects of database design, database languages, and
database system implementation.
2. To provide a strong formal foundation in database concepts, technology, and
practice.
3. To give systematic database design approaches covering conceptual design,
logical design and an overview of physical design.
4. To make students familiar with the basic issues of transaction processing and
concurrency control.
5. To learn a powerful, flexible, and scalable general-purpose database to
handle big data.
6. To learn and understand Advances in Databases and Applications.
Database Management System
Course Outcomes:
After learning the course, students will be able to:
1. Design E-R
R Model for given requirements and convert the same into
database tables.
2. Design schema in appropriate normal form considering actual requirements.
3. Write queries and PL/SQL Code blocks for given requirements, using
different SQL and PL/SQL concepts.
4. Convert the given schedule in serializable (Conflict/view) schedule to
achieve benefits of serializability.
5. Apply different concurrency control and recovery methods in real time
situations.
6. Use advanced database Programming concepts like mongoDB.
SYLLABUS
Unit I Introduction to Database Management Systems, Purpose of Database Systems, Database-
System Applications, View of Data, Database Languages, Database System Structure, Data
Models, Database Design and ER Model:
Model Entity, Attributes, Relationships, Constraints, Keys,
Design Process, Entity Relationship Model, ER Diagram, Design Issues, Extended E-R
Features, converting E-R & EER diagram into tables.
Case Study: Design ER Model for any real time application and convert the same into
tables on paper
Unit II SQL: Characteristics and advantages, SQL Data Types and Literals, DDL, DML, DCL, TCL,
SQL Operators, Tables: Creating, Modifying, Deleting, Updating, SQL DML Queries:
SELECT Query and clauses, Index and Sequence in SQL, Views: Creating, Dropping,
Updating using Indexes, Set Operations, Predicates and Joins, Set membership, Tuple
Variables, Set comparison, Ordering of Tuples,
Tuples Aggregate Functions, SQL Functions, Nested
Queries, PL/SQL: Concept of Stored Procedures & Functions, Cursors, Triggers, Assertions,
Roles and Privileges
Case Study: Implementation of unit 1 case study using SQL/PLSQL.
Unit III Relational Database Design
Relational Model: Basic concepts, Attributes and Domains, CODD's Rules, Relational
Integrity: Domain, Referential Integrities, Enterprise Constraints, Database Design: Features
of Good Relational Designs, Normalization, Atomic Domains and First Normal Form,
Decomposition using Functional Dependencies, Algorithms for Decomposition, 2NF, 3NF,
BCNF.
SYLLABUS
Unit IV Database Transaction Management
Transaction concept, Transaction states, ACID properties, Concept of Schedule, Serial
Schedule, Serializability: Conflict and View, Cascaded Aborts, Recoverable and Non-
recoverable Schedules, Concurrency Control:
Control Lock-based, Time-stamp based Deadlock
handling, Recovery methods: Shadow-Paging
Paging and Log-Based Recovery, Checkpoints.
Case Study: Study of transaction Management in Postgre SQL
Unit V NoSQL Databases
Introduction to Distributed Database System-
System Advantages, disadvantages, CAP Theorem.
Types of Data: Structured, Unstructured data & Semi-Structured Data;
NoSQL Database: Introduction, need, Features, Types of NoSQL Databases: Key-value store,
document store, graph, wide column stores;
stores BASE Properties, Data Consistency model ACID
Vs BASE, Comparative study of RDBMS and NoSQL, MongoDB (with syntax and usage):
CRUD Operations, Indexing, Aggregation, MapReduce, Replication, Sharding.
Case Study-Use of NoSQL databases for processing unstructured data from social
media.
Unit VI Advances in Databases
Emerging Databases: Active and Deductive databases, Main Memory databases, Semantic
databases.
Complex Data Types: Semi-Structured
Structured Data: Features of Semi-Structured Data Models,
Nested Data Types: JSON, XML, Object Orientation: Object-Relational Database System,
Table Inheritance, Object-Relational Mapping, Spatial Data: Geographic Data, Geometric
Data
DATABASE MANAGEMENT SYSTEM
Text Books
1. Silberschatz A., Korth H., Sudarshan S., "Database System Concepts",
McGraw Hill Publishers, 7th Edition, 2020 ISBN 978-0-07-802215-9.
978
2. Ivan Bayross,, "SQL, PL/SQL the Programming Language of Oracle", BPB
Publications, 2014 ISBN: 9788176569644.
3. Connally T, Begg C., "Database Systems-
Systems A Practical Approach to Design,
Implementation and Management", Pearson Education, 5th Edition, 2010,
ISBN 81-7808-861-4.
4. Pramod J. Sadalage and Martin Fowler, "NoSQL
" Distilled", Addison Wesley,
ISBN 10: 0321826620, 2013, ISBN 13: 978-0321826626.
978
DATABASE MANAGEMENT SYSTEM
Reference Books
1. C. J. Date, "An Introduction to Database Systems", Addison-Wesley,
Addison 8th
Edition, 2004, ISBN 0321189566.
2. S. K. Singh, "Database Systems: Concepts, Design and Application",
Pearson Education, 2009,ISBN 9788177585674.
3. Kristina Chodorow, Michael Dierolf,, "MongoDB:
" The Definitive Guide",
O’Reilly Publications, 3rd Edition, 2019 ISBN 9781491954461.
4. Kevin Roebuck, "Storing and Managing Big Data - NoSQL, HADOOP and
More", Emereo Pty Limited, 2011,ISBN 1743045743, 9781743045749.
Database Management System
• Teaching Plan :
Unit No. Contents Theory
Lectures
I Introduction to Database Management Systems and ER Model 6
II SQL and PL/SQL 6
III Relational Database Design 6
IV Database Transaction Management 7
V NoSQL Databases 6
VI Advances in Databases 5
Total Lecture Hours in a semester (12 weeks) 36
