Course Policy Database Management System

Mukesh Patel School of Technology Management and Engineering

Computer Engineering Department

Course Policy
Program/Branch/Semester : B Tech (Artificial Intelligence, Data Science, Computer
Engineering, Information Technology, CSE (Cyber), AI
and ML, AI and DS, CSBS, CSE (DS), Computer
Science)MBA Tech (All Programs)
B Tech Integrated (Computer Engineering)

Academic Year : 2024-25

Course Code & Name : 702A10C001, Database Management System (3 credits)

Credit Details :
LTPC2024

Course Coordinator : Dr. Soni Sweta

Faculty

7250371806 & soni.sweta@nmims.edu

Contact No. & Email :
Office : MPSTME. Mumbai

Student Contact Hours : Monday 3:00 to 4:00pm

Other Course Faculty :

members teaching this
course
Course Faculty 2 :Dr. RadhaKrishna Rambola Course Faculty 3: Prof. Sonia Relan
Contact No. & Email: 8700355382, Shirpur Contact No. & Email:
radhakrishna.rambola@nmims.edu 8668787355, 8275589278, Shirpur
Office Hours sonia.relan@nmims.edu Office Hours:

Course Faculty 4: Prof. Sachin Course Faculty 5 : Dr. Hemant

Bhandari Contact No. & Email: Gianey Contact No. & Email:
9584120066,Shirpur 9352237730, Shirpur
sachin.bhandari@nmims.edu hemant.gianey@nmims.edu
Office Hours: Office Hours:
Course Faculty 6 : Prof. Pankti Course Faculty7 : Prof. Artika Singh
Doshi Contact No. & Email: Contact No. & Email: 9769746015,
9920562911 , Mumbai Mumbai artika.singh@nmims.edu
pankti.doshi@nmims.edu Office Hours:
Office Hours:

Course Faculty 8 : Prof. Shakila Course Faculty 9 : Prof. Manisha Tiwari

Shaikh Contact No. & Email: Contact No. & Email: 8985877265,
8097338633, Mumbai Mumbai, manisha.tiwari@nmims.edu
shakila.shaikh@nmims.edu Office Office Hours:
Hours:

Page 1 of 14
Course Policy Database Management System

Course Faculty10 : Prof. Swati Vaishnav Course Faculty 11: Dr. Radhika Chapaneri
Contact No. & Email: 7977413295 ,Mumbai Contact No. & Email: 9987024068, Mumbai
swati.vaishnav@nmims.edu Radhika.Chapaneri@nmims.edu
Office Hours: Office Hours:

Course Faculty 12 : Prof. Jish Joy Course Faculty 13 : Prof. Tejaswin Chavan
Contact No. & Email: 9819405049 Contact No. & Email: 9975671357, Navi Mumbai
Mumbai, Jish.Joy@nmims Tejaswini.Chavan@nmims.edu Office
Office Hours:
Hours:

Course Faculty 14 : Shruti Sharma Course Faculty 15 : Dr. Jyotsna

Contact No. & Email: Singh Contact No. & Email:
9893220288,Indore, 9810901088, Chandigardh,
shruti.sharma@nmims.edu Office jyotsna.singh@nmims.edu Office
Hours: Hours:
Course Faculty 16 : Wasiha Tasneem
Contact No. & Email: 8885284037,
Hydrabad
tasneem.wasiha@nmims.edu Office
Hours:

Queries by Emails are encouraged.

Course link : Portal Link
MS Teams Link: Multicampus coodination for DBMS-
2024-25 | General | Microsoft Teams

1 Introduction to the Course

1.1 Importance of the course

The importance of the Database Management System (DBMS) course is to provide

students with a comprehensive understanding of how databases are designed, managed,
and utilized in modern applications. The course introduces fundamental concepts such
as data models, relational databases, and database design principles. Students will learn
how to create and manipulate databases using Structured Query Language (SQL). The
course also covers advanced topics such as normalization, transaction management and
concurrency control. Emphasis is placed on understanding the importance of data
integrity, security, and performance in DBMS. By the end of the course, students will
be equipped with the skills to design efficient, scalable, and secure database systems.
The course aims to bridge the gap between theoretical concepts and practical
implementation of databases in real-world scenarios. It prepares students for roles in
database administration, development, and optimization. Additionally, students will
learn how to work with database management software and apply industry best
practices. Ultimately, the goal is to make students proficient in managing and utilizing
databases effectively in diverse computing environments.

Page 2 of 14
Course Policy Database Management System

1.2 Objective of the Course

The objective of the course is to offer a thorough introduction to the key concepts
involved in the design and development of database systems, focusing on the efficient
and effective organization, maintenance, and retrieval of information from a database
management system.

1.3 Pre-requisite

● Data Structure.

2 Course Outcomes (CO) and mapping with Program Outcomes (PO)

2.1 Course Outcomes

On successful completion of the course, the students will be able to –

1. Describe core concepts of database and model a database management system through
ER modeling. (L-3)
2. Apply knowledge of relational algebra and structured query language to retrieve and
manage data from relational database. (L-3)
3. Demonstrate the use of normalization for database design (L-3)
4. Demonstrate the concept of transactions and use modern database techniques
such as NoSQL(L-3)

Program Outcome (PO):-

PO 1 : An ability to apply knowledge of mathematics, science, and engineering for
problem solving.

Page 3 of 14
Course Policy Database Management System

PO 2 : An ability to research, design and conduct experiments, as well as to analyze and

interpret data.

PO 3 : An ability to design, implement, and evaluate a computer-based system, process,

component, or program to meet desired needs.

PO 4 : An ability to function effectively on teams to accomplish a common goal.

PO 5 : An ability to identify, formulate and provide effective IT solution for engineering

problems.

PO 6 : Apply reasoning informed by the contextual knowledge to assess societal, health,

safety, legal and cultural issues and the consequent responsibilities relevant to the
professional engineering practice.

PO 7 : An ability to communicate effectively with a range of audiences.

PO 8 : The broad education necessary to understand the impact of engineering solutions

in a global, economic, environmental, and societal context.

PO 9 : Recognition of the need for and an ability to engage in continuing professional

development and self-learning.

PO 10 : An ability to apply ethical principles in development of IT solutions.

PO 11 : An ability to use the techniques, skills, and modern engineering tools

necessary for developing effective IT solutions.

PO 12: An ability to identify and analyze user needs and take them into account in the
selection, creation/integration, evaluation and administration of IT-based
solutions.

3 Syllabus, Pre-class activity and References

Page 4 of 14
Course Policy Database Management System

3.1 Teaching and evaluation scheme

Teaching Scheme Evaluation Scheme

Internal Continuous
Lecture Term End
Practical Tutorial Assessment (ICA)
Hours Examination
Hours Hours Credit As per Institute Norms
per (
per week per week (50 Marks)
week 100 Marks)
Marks Scaled to 50 Marks Scaled to
2 2 0 3
50

3.2 Syllabus

Program: B Tech (Artificial Intelligence, Data Science, Semester: III / IV

Computer Engineering, Information
Technology, CSE (Cyber), AI and ML, AI and
DS, CSBS, CSE (DS), Computer
Science)MBA Tech (All Programs)
B Tech Integrated (Computer Engineering)

Course: Database Management Systems Code: 702AI0C001

Teaching Scheme Evaluation Scheme
Detailed Syllabus:
Unit Description Duration
1. Introduction 03
Database System Applications, Purpose of Database Systems, View
of Data, Database Languages, Data Models, Database Users and
Administrator
Database Design and the E-R Model 05
Overview of the Design Process, The Entity-Relationship Model,
2. Constraints, Entity Relationship Diagrams, Reduction to Relational
Schemas, Schema Diagrams , Entity-Relationship Design Issues,
Extended ER features
Introduction to the Relational Model 03
Structure of Relational Databases, Database Schema, Keys,
3. Relational Algebra, Basic operators of Relational Algebra

4. Structured Query Language 06

Overview of the SQL Query Language, SQL Data Definition, SQL
Constraints, Basic Structure of SQL Queries, Additional Basic
Operations, DML operations, Set operations, Aggregate Functions,
Nested Sub-queries, Joins, views.

Page 5 of 14
Course Policy Database Management System

5 Relational Database Design 05

Features of Good Relational Designs, Problems with bad design,
Decomposition using concept of functional dependencies,
Armstrong’s axioms, Closure of functional dependency, Closure of
attribute, Introduction to process of Normalization and
denormalization,
Normal Forms- 1NF, 2NF, 3NF, BCNF
6 Transactions 04
What is Transactions? Properties of transaction, Transaction states,
Issues with concurrent executions, Schedules, Serializability
Conflict and View
7 Introduction to NoSQL 04
Overview of NoSQL, characteristics of NoSQL, Storage types of
NoSQL, Implementing NoSQL in MongoDB - Managing Databases
and Collections from the MongoDB shell, Finding Documents in
MongoDB collection from the MongoDB shell.

Total 30

3.2 Pre-class activity :

Using GenAI, explore the Real-World Applications of DBMS
 Ask students to explore real-world applications where DBMS plays a critical role
(e.g., banking, healthcare, or social media etc.)
 Activity: Use GenAI to generate case studies or scenarios, discussing how DBMS is
crucial in handling data for such applications.
An outline of the preliminary study for each unit will be shared before the unit begins. Relevant
study materials, such as textbook chapters, video links, presentations, and notes, will be
uploaded to the student portal/ MS Team in advance . Students are expected to review these
materials in preparation for the upcoming sessions. For every hour of classroom teaching,
students should dedicate at least two hours to self-study. Lecture sessions will focus on
advanced topics, practical applications, and addressing any doubts.

3.3 References

Text Books:
1. Hennery Korth and Abraham Silberschatz, Database System Concepts, 7th Edition,
McGraw Hill, 2019
2. Gaurav Vaish, Getting Started with NoSQL, 1st edition, Packt Publication, March
2013
3. Brad Daylel, NoSQL with MongoDB in 24 Hours, 1st edition, Sams Teach Yourself,
January 2015

Page 6 of 14
Course Policy Database Management System

Reference Books:
1. Elmarsi and Navathe, Fundamentals of Database Design, 7th Edition, Addison
Wesley, 2019
2. Bob Bryla, Kevin Loney Oracle Database 12C The Complete Reference, 1st edition,
Tata McGraw Hill, 2017

4 Experiment details

The following 10 programming exercises will form the submission for laboratory coursework.
Practic Week No Practical Definition CO
al No
1 1 Explore various fundamental concepts of DBMS and its CO1/L2
future prospective. Introduction to the MySQL/Oracle

1. Write briefly about the need of an effective DBMS in

today’s world of data explosion
2. List four applications you have used that most likely
employed a database system to store persistent data
3. List four significant differences between a file
processing system and a DBMS.
4. In a particular organization, customer names and
addresses are kept in one file for the sales department

and another file for billing department. What

inconsistency might result from this redundancy?
5. Describe at least 3 tables that might be used to store
information in a social networking system such as
Facebook.
6. List any three database software and compare them in
terms of licensing, ease of use, scalability,
performance, security.

2 2 Apply Data Definition language [DDL] on the relational CO2

model designed and apply below constraints on the /L3
relational model designed.
● Primary key
● Unique constraint
● Not Null constraint
● Foreign key
● Check constraint
Create table structures for one particular database
(atleast
5-6 tables)
Create user, databases

Page 7 of 14
Course Policy Database Management System

3 3 Apply Data Definition language [DDL] on the relational CO2/L2

model designed
Insert values in the tables in database created in Practical
No.1.
Select, Delete, Update statements

4 4 To design Entity Relationship and relational model for CO1

the given case study.Students can also design the ER /L3
Model for the project. Students can make use of tools
such as ERD Plus, Lucid chart etc to design ER model
5 5 To study and implement DML select statement with CO2
where clause, and, or, not, in, between and like, order by /L3
clause.

6 6 To implement group by, having clause, aggregate CO2

functions for solving queries. /L3

7 7 Evaluation of Practicals and First phase of evaluation of CO1, C

mini project O2/L4
The students to be evaluated on the following DBMS
aspects
1. ER Model
2. Creation of Tables and Insertion of values and
basic queries
8 8 To apply order by clause and concept of different types CO2/L3
of Joins for solving queries.
9 9 To implement sub queries, set operation and views for CO2 /L3
solving queries.
10 10 Demonstrate the use of normalization and transaction CO3,
CO4 /L3
11 11 To implement NoSQL database using Mongodb CO4 /L3

12 12 Project Evaluation and Practicals Evaluation CO2,C

The students to be evaluated on the following DBMS O3,
aspects CO4 /L4
3. Complex Queries
4. Normalization
5. Final Demo
6. Learning Beyond classrom

Page 8 of 14
Course Policy Database Management System

5 Assessment Policy
5.1 Component wise Continuous Evaluation Internal Continuous Assessment (ICA) and Term
End Examination (TEE)
Assessment ICA (50%) (Marks scaled to TEE (100 marks)
Component 50) scaled to
50)

Lab Class Formative Assessment

Performance Mini project Test1 and Quiz/Technical
m Implementati Class presentation/Viva/Assi
on Test 2 gnment/ Seminar/Flip
(Group Class
activity)
Weightage 20% 20%*2=40% 10% 50%
30%
Marks 10 10*2=20 5 100
15
Timeline ● Lab Week 6
submission Week 7 and Week 11
Weekly 14

5.2 Assessment Policy for Internal Continuous Assessment (ICA)

Assessment of ICA consists of the following components.

1. Class test 1 and 2 (10*2)

a. Two class tests will be conducted as per the academic calendar.

2. Lab performance and practicum (10 marks)

a. Lab tasks (10 marks)

i. Continuous assessment for laboratory tasks will be conducted. There are
10 lab tasks, each carrying weightage of 10 marks. At the end of the
course, average of total marks will be taken to obtain marks out of 10.
ii. Discussion of your work with your peers is allowed. However, each
student is expected to submit his/her original work. Submissions which
are similar will be marked zero.
iii. The lab work assessment will be based on various parameters, including
timely completion of the lab work file, understanding of the experiments
performed, originality, student involvement, regularity, and discipline
during the session. Late submissions will incur a 20% penalty.
iv. Lab tasks are to be submitted as per the date mentioned in the lab file.
Late submissions will not be accepted.

Page 9 of 14
Course Policy Database Management System

3. Formative Assessment using suitable assessment tools (5 marks) –

Quiz/Technical presentation/Viva/Assignment/ /Tutorial/Seminar/Flip Class

4. Implementation and demo presentation of Database project(15 Marks)

a. Group of 2-3 students will work together in a Team.

b. The Project Goal and Learning Objectives:
i. Create application specifications
ii. Create Entity Relationship diagrams
iii. Convert ER to Relational model iv. Optimize relational model using
concepts of normalization
c. Steps for the Project implementation:
● Select the project title and get the topic approval
● Do the requirement analysis and prepare detail project description
● For the requirement gathered drawn an ER diagram. Make sure to indicate
primary keys, cardinality constraints, weak entities (if any), and
participation constraints. There might be extra constraints which cannot be
captured by the E/R diagram, make sure you mention them below the
diagram. List any assumptions you make in the process. Hint: The E/R
diagram should contain atleast 8 (may be more/less) entities. Please do not
copy it, create your own with your creativity.
● For each entity set and relationship, write a short description in plain English
of what it represents or models. One or two sentences per entity set and
relationship is enough. These descriptions are primarily to help us
understand that you are modeling your application correctly
● Translate the ER diagram into relational database tables (i.e. give the SQL
DDL statements). Make sure that the translation captures key constraints
(primary keys and foreign keys if applicable) and participation constraints
in the ER diagram. Identify constraints, if any, that you are not able to
capture.
● Optimize relational model using concepts of normalization.
● Create SQL scripts to create the database tables and populate your database
with sample data. Include at least for each relation.
● Write done at least 15 queries related to your project including concepts of
simple query, joins, aggregate functions and sub-query.
● Implement the project, report submission and demo presentation.
● Present your project
d. Evaluation of project will be based on following rubrics-
i. Innovative Ideas (5 Marks) Idea should not be regular such as Hotel,
Library Management system etc. ii. Implementation and Design (15 Marks)
It includes ER model, Relational model and Normalization of tables.
iii. Self-Learning and Learning Beyond classroom (5)

Presentation Timeline
Week 1-3 Choose topic, submit the abstract
Week 4 Get the topic approval

Page 10 of 14
Course Policy Database Management System

Week 7 First phase of evaluation: 10 marks

Innovative Ideas (5 Marks)
Design and Partial implementation (5 Marks)
Week 14 Final phase of evaluation 10 marks
Implementation, presentation and viva, Self-Learning
and Learning Beyond classroom

The idea is to encourage students to pay attention in class and actively participate

5.3 Assessment Policy for Term End Examination (TEE)

A written examination of 100 marks for 03 hours duration will be conducted for the course as
per the academic calendar.
7. Lesson Plan

Sr.no Topics to be covered CO Textbook Chapters &

Readings
Unit 1
Introduction to DBMS

Database System Applications, Purpose of CO1

1 Database Systems, TB1,RB1

View of CO1
2 Data, Database Languages, Data Models, TB1,RB1

Database Users and Administrator CO1

3 TB1,RB1
Unit
Database Design and the E-R Model
2
Overview of the Design Process, CO1
4 TB1,RB1
The Entity-Relationship Model, CO1
5 Constraints, Entity Relationship Diagrams, TB1,RB1

CO1
6 Entity Relationship Diagrams TB1,RB1
Reduction to Relational CO1
7 Schemas, Schema Diagrams TB1,RB1

, Entity-Relationship Design Issues, CO1

8 TB1,RB1
Extended ER features
Unit
Introduction to the Relational Model
3

Page 11 of 14
Course Policy Database Management System

Structure of Relational Databases, Database CO2

9 Schema, Keys, TB1,RB1

Relational CO2
10 Algebra, Basic operators of Relational Algebra, TB1,RB1

Relational CO2
11 Algebra, Basic operators of Relational Algebra, TB1,RB1

Unit
Structured Query Language
4
Overview of the SQL Query Language, SQL Data CO2
Definition, SQL
12 TB1,RB1
Constraints,

Basic Structure of SQL Queries, Additional Basic CO2

13 Operations, TB1,RB2

DML operations, CO2

14 TB1,RB2
CO2 TB1 RB2
15 Set operations
, Aggregate Functions, CO2 TB1 RB2
16
Nested Sub-queries,
CO2 TB1 RB2
17 Joins, views
Unit
Relational Database Design
5
Features of Good Relational Designs, Problems CO3
18 with bad design, TB1,RB1

Decomposition using concept of functional CO3

dependencies,
19 TB1,RB1
Armstrong’s axioms,

Closure of functional dependency, Closure of CO3

20 attribute, , TB1,RB1

Introduction to process of Normalization and CO3

21 TB1,RB1
denormalization
CO3
22 Normal Forms- 1NF, 2NF, 3NF, TB1,RB1
CO3
23 BCNF, Denormalization TB1,RB1

Page 12 of 14
Course Policy Database Management System

Unit
Transactions
6
What is Transactions? Properties of transaction, CO4
24 TB1,RB1
Transaction states, CO4
25 Issues with concurrent executions TB1,RB1

Schedules, Serializability- Conflict CO4

26 TB1,RB1
CO4
27 and View TB1,RB1

Unit
Introduction to NoSQL
7
Overview of NoSQL, characteristics of NoSQL, CO4
28 Storage types of TB2, TB3

NoSQL, Implementing NoSQL in MongoDB - CO4 TB2,TB3

29 Managing Databases

and Collections from the MongoDB shell, Finding CO4 TB2, TB3
30 Documents in
MongoDB collection from the MongoDB shell

6 Teaching-learning methodology: Encourage faculty members to incorporating Project

Base Learning (PBL) to achieve CO-PO, PEO’s attainment core concept of Outcome
Base Learning (OBE)

Faculty will make a group of 2 to 3 students for any group based activity such as project,
evaluation, Technical presentation etc. Lecture and laboratory session will be conducted as
follows-

1. Lectures: o Outline for preliminary study to be done for each unit will be
provided prior to commencement of each unit. o Deeper concepts and
applications will be explained through Presentation and Video Lectures. o Some
practical applications will be simulated in class on MySQL for better
understanding of the concepts.
2. Laboratory:
o Lab manual consisting of theory and SQL Query to support the lab experiment
will be uploaded on student portal. o Regular lab assessment and grading will be
done. Students will be marked based on parameters like completion of lab
assignment, originality, logic developed, interaction during the lab, submission,
punctuality and discipline.

Page 13 of 14
Course Policy Database Management System

10. Active learning techniques

Active learning is a method of learning in which students are actively or experientially
involved in the learning process. Following active learning techniques will be adopted
for the course.

1. Muddiest topic: Faculty will find out the least understood point/topic in the session. This
topic is then further explained to ensure that it is understood well.

2. Blended Learning: Students will be introduced to the topic at home while the in-depth
topics, applications and numerical problems will be discussed by the faculty in the lecture
session. Outline for preliminary study to be done for each unit will be provided prior to
commencement of each unit. Preliminary study material (video links, presentation, notes
etc) will be made available on the student portal.

3. Frame a question: Student will be asked to design and frame their own questions
pertaining to the topic being taught. The idea is to stimulate students’ curiosity, engage the
students in collaborative teaching and learning, and motivating students to develop deeper
understating of the topic.
4. Brainstorming: Students will be asked to generate ideas on a certain topic, category or
question while the faculty will facilitate and record the answers on the
blackboard/whiteboard.

11. Course Material

Following course material is uploaded on the student portal: (give student portal link)
● Course Policy
● Lecture Notes
● Lecture Videos
● Lecture Presentations
● Books / Reference Books / NPTEL video lectures link
● Assignments
● Lab Manuals, Test images database link
● List of Program Outcomes

12. Course Outcome Attainment

Following means will be used to assess attainment of course learning outcomes.

● Use of formal evaluation components of continuous evaluation, assignments, laboratory
work, semester end examination
● Indirect assessment by course exit surve/ feedback after course conduction
13. Academic Integrity Statement

Students are expected to carry out assigned work under Internal Continuous
Assessment (ICA) independently. Copying in any form is not acceptable and will invite
strict disciplinary action. Evaluation of corresponding component will be affected
proportionately in such cases. Plagiarism detection software will be used to check
plagiarism wherever applicable. Academic integrity is expected from students in all
components of course assessment.
Page 14 of 14