Course Course Course L T P C

21ECE371T DATABASE DESIGN AND MANAGEMENT E PROFESSIONAL ELECTIVE

Code Name Category 3 0 0 3

Pre-requisite Co- requisite Progressive

Nil Nil Nil
Courses Courses Courses
Course Offering Department ECE Data Book / Codes / Standards Nil

Course Learning Rationale (CLR): The purpose of learning this course is to: Program Outcomes (PO) Program
Specific
CLR-1: understand the fundamentals of Database Management Systems, Architecture and Languages 1 2 3 4 5 6 7 8 9 10 11 12 Outcomes

Environment & Sustainability

CLR-2: conceive the database design process through ER Model and Relational Model

The engineer and society

Conduct investigations of
design Logical Database Schema and mapping it to implementation level schema through Database

Individual & Team Work

Engineering Knowledge

Design/development of

Project Mgt. & Finance

CLR-3:
Language Features

Modern Tool Usage

Life Long Learning

complex problems
understand the practical problems of concurrency control and gain knowledge about failures and

Problem Analysis
CLR-4:

Communication
recovery
CLR-5: explore the database implementation mechanism

solutions

PSO-1

PSO-2
PSO-3
Ethics
Course Outcomes (CO): At the end of this course, learners will be able to:
CO-1: define the various elements of Database Management Systems 3 2 - - - - - - - - - - 3 - -
CO-2: apply E-R diagram for database design and normalization 2 3 - - 3 - - - - - - - - - -
CO-3: express database program using Relational Algebra and Relational Calculus 2 3 - - - - - - - - - - 3 - -
CO-4: evaluate the concepts of transaction, concurrency control, and recovery mechanism in database 2 2 - - 3 - - - - - - - - 2 -
CO-5: compile database implementation mechanism 2 1 - - 3 - - - - - - - - - -

Unit-1 – Introduction to Database Systems 9 Hour

Introduction: Database System, Applications, Purpose of Database Systems, View of Data, Database Languages, Data Storage and Querying, Transaction Management, Database Architecture, SQL Concepts :
Basics of SQL, DDL,DML,DCL, structure – creation, alteration, defining constraints – Primary key, foreign key, unique, not null, check, IN operator, aggregate functions, Built-in functions –numeric, date, string
functions, set operations, sub-queries, correlated sub-queries, join, Exist, Any, All , view and its types., transaction control commands
Unit-2 - Database Design 9 Hour
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-3 - Relational Algebra 9 Hour
Relational Algebra and Calculus: Relational algebra: introduction, Selection, and projection, set operations, renaming, Joins, Division, syntax, semantics. Operators, grouping and ungrouping, relational comparison
Calculus: Tuple relational calculus, Domain relational Calculus, calculus vs algebra, computational capabilities
Unit-4 - Transaction Management 9 Hour
Transaction processing - Concurrency control - ACID property - Serializability of scheduling - Locking and timestamp-based schedulers - multi-version and optimistic Concurrency Control schemes -Database
recovery
Unit-5 - Implementation Technique 9 Hour
Redundant Array of Independent Disks (RAID) - File Organization - Organization of Records in Files - Indexing and Hashing - Ordered Indices - B+ tree Index Files - B tree Index Files - Static Hashing - Dynamic
Hashing - Query Processing Overview - Algorithms for SELECT and JOIN operations -Query optimization using Heuristics and Cost Estimation

154
B.Tech / M.Tech (Integrated) Programmes-Regulations 2021-Volume-14-ECE-Higher Semester Syllabi-Control Copy
 1. Data base Management Systems, Raghu Ramakrishnan, Johannes Gehrke, McGraw Hill 4. Database Systems Design, Implementation, and Management, Peter Rob& Carlos Coronel,
Education (India) Private Limited, 3rd Edition, 2003 7th Ed., 2011.
Learning 2. Fundamental of Database Systems, Ramez Elmasri, Shamkant B.Navathe, Pearson 5. Principles of Distributed Database Systems, Ozsu, Pearson Publication,2011
Resources Education, 6th edition, 2011 6. Distributed Database Management Systems, Rahimi & Haug, Wiley, 2010
3. Data base System Concepts, A. Silberschatz, and Henry. F. Korth, S.Sudarshan, McGraw
Hill Education(India) Private Limited l, 6thedition, 2011

Learning Assessment
Continuous Learning Assessment (CLA)
Summative
Formative Life-Long Learning
Bloom’s Final Examination
CLA-1 Average of unit test CLA-2
Level of Thinking (40% weightage)
(50%) (10%)
Theory Practice Theory Practice Theory Practice
Level 1 Remember 15% - 15% - 15% -
Level 2 Understand 25% - 20% - 25% -
Level 3 Apply 30% - 25% - 30% -
Level 4 Analyze 30% - 25% - 30% -
Level 5 Evaluate - - 10% - - -
Level 6 Create - - 5% - - -
Total 100 % 100 % 100 %

Course Designers
Experts from Industry Experts from Higher Technical Institutions Internal Experts
1. Mr. Athif Shah, Chairman, Abe Semiconductor, 1. Dr. Meenakshi, Professor of ECE, CEG, Anna 1. Dr .B. Muruganandam, SRMIST
[email protected] University,[email protected]
2. Dr. Elizer, SRMIST

155
B.Tech / M.Tech (Integrated) Programmes-Regulations 2021-Volume-14-ECE-Higher Semester Syllabi-Control Copy