SEMESTER-II
COURSE
DATABASE MANAGEMENT SYSTEMS CREDITS 3
TITLE
COURSE
ACA31006 COURSE CATEGORY CC L-T-P-S 2-0-2-2
CODE
40th ACM - LEARNING
Version 1.0 Approval Details BTL 2,3
24th Feb 2024 LEVEL
ASSESSMENT SCHEME
First Periodical Second Periodical Seminar/ Assignments/ Surprise Test / End Semester Exam
Attendance
Assessment Assessment Project Quiz Internal External
15% 15% 10% 5% 5% 25% 25%
The Database Management System course is designed to address new technologies, advanced theories, and techniques, along
Course
with their application, implementation, and integration with legacy systems. The program aims at equipping students with
Description
expertise in a range of highly marketable, hands-on skills required in data modelling.
1. To explain the basic concepts of DBMS and architecture
2. To make the students to understand about the concept Data modelling
Course
3. To explain how to do the normalisation and to understand relational algebra
Objectives
4. To help the students to understand the SQL concepts and the sub queries
5. To Make students to understand query concepts
CO1: Describe the Basics of DBMS
CO2: Understand the concepts of ER diagrams, entity sets and entity types
Course
CO3: Explain the Normalization and Relational algebra
Outcome
CO4: Describe the SQL concepts
CO5: Understanding the Query processing, Query optimisation and execution.
Prerequisites: +2 or Higher Secondary or Equal
Pedagogy: Direct Instruction, Constructivist, Reflective, Inquiry-based, Discussion, Simulation, Presentation, Assignments
CO, PO AND PSO MAPPING
CO PO -1 PO-2 PO-3 PO-4 PO-5 PO-6 PO-7 PSO-1 PSO-2 PSO-3
CO-1 2 2 2 - 2 - 2 3 2 2
CO-2 3 3 3 - 2 2 3 3 3 3
CO-3 3 2 2 - 2 1 3 3 3 3
CO-4 3 1 2 - 2 1 2 3 3 3
CO-5 3 1 2 - 2 1 3 3 3 3
1: Weakly related, 2: Moderately related and 3: Strongly related
MODULE 1: INTRODUCTION 12hrs
Databases and Database Users: Introduction, An example, Characteristics of the Database Approach-Data
Independence, Database Languages and Interfaces-The Database System Environment-Centralized and
Client-Server Architectures, Classification of Database Management Systems.
CO-1, BTL-1,2
Practicum:
1. Create the table for Library Management System using DDL Commends
2. Create the table for Vehicle Parking Management System using DDL and DML Commands
MODULE 2: DATA MODELING 12Hrs
Data Modeling Using Entity-Relationship Model-Entity Types-Entity Sets-Attributes and Keys-
Relationship Types-Relationship Sets-Weak Entity Types, Refining the ER Design Company Database
Diagrams, Naming Conventions and Design
CO-2, BTL-2,3
Practicum:
1. Student Score Card Preparation and draw an ER Diagram
2. Supermarket System and draw an ER Diagram
MODULE 3: RELATIONAL ALGEBRA AND NORMAL FORMS 12Hrs
Relational Database Model – Structure of Relational Model – Keys – Relational Algebra ‐Functional
Dependencies ‐ Normalization – 1NF – 2NF‐3NF‐ BCNF – 4NF – Oracle Database Server.
Practicum : CO-3, BTL-3
1. Create Computer Goods table for Purchase and Sales to perform relational algebra
2. Create Bank Customer table with Primary Key and execute 1NF and 2NF
MODULE 4: SQL BASICS AND SUB QUERIES 12Hrs
Introduction – Data Retrieval – SQL Plus – Single Row Functions – Group Function – Set Function –
Sub Query – Joins. Oracle-Introduction – Insert Statement – Update Statement – Delete Statement –
Transaction Control Language – View – Defining Constraints.
Practicum: CO-4, BTL-3
1. Salary table and apply Statistical functions
2. Explore about single row function – Date functions
3. Explore about single row function – String functions
MODULE 5: Queries Concepts 12Hrs
Query Processing, Optimization & Execution – Hashing – Distributed Architecture ‐Concurrency Control
– Backup & Recovery Techniques – Oracle Architecture.
CO-5 BTL-3
Practicum:
1. Display a hash value using default hash algorithm.
Skill Development Activities: Reflecting on personal thoughts during daily activities for one day and observing/ introspecting on the various
psychological phenomena taught in this course.
Note: This should Cover all the 5 modules and the specific skill the students have developed.
TEXT BOOKS
1 Database System Concepts Seventh Edition Avi Silberschatz Henry F. Korth S. Sudarshan McGraw-Hill Publication.
REFERENCE BOOKS
1 "Fundamentals of Database Systems" by R Elmasri and S Navathe
2 "Database Management Systems" by Johannes Gehrke and Raghu Ramakrishnan
3 “Principles of Database Systems” by J. D. Ullman
E-BOOKS / MAGAZINE / ARTICLES
1 https://mrcet.com/downloads/digital_notes/ECE/III%20Year/DATABASE%20MANAGEMENT%20SYSTEMS.pdf
2 https://mu.ac.in/wp-content/uploads/2021/08/USIT304-Database-Management-Systems.pdf
3 https://xuanhien.files.wordpress.com/2011/04/database-management-systems-raghu-ramakrishnan.pdf
ONLINE RESOURCES
1 https://www.cet.edu.in/noticefiles/279_DBMS%20Complete1.pdf
https://industri.fatek.unpatti.ac.id/wp-content/uploads/2019/03/162-Introduction-to-Database-Management-System-Satinder-
2
Bal-Gupta-Aditya-Mittal-Edisi-2-2017.pdf
3 https://people.inf.elte.hu/miiqaai/elektroModulatorDva.pdf
