GUJARAT TECHNOLOGICAL UNIVERSITY
Program Name: Bachelor of Engineering
Level: UG
Subject Code : BE03000091
Subject Name : Database Management System
w. e. f. Academic Year: A.Y. 2024-25
Semester: 3
Category of the Course: Professional Core Course
Prerequisite: Basic knowledge of Computer Programming.
Rationale: The course will equip student with the knowledge and skills to design, implement,
and manage database systems. It covers database design, modeling, and structures
like relational, hierarchical, and network models. Students will learn data
manipulation languages for querying and managing databases, along with key
DBMS concepts such as security, integrity, concurrency, and storage strategies.
Hands-on practice with SQL and PL/SQL ensures practical experience in database
management.
Course Outcome:
After Completion of the Course, Student will able to:
RBT
No Course Outcomes Lev
el
1 Understand DBMS fundamentals, database architecture, relational models, and user R, U
roles.
2 Design databases using E-R diagrams, normalization, and relational schemas. C
3 Apply SQL and PL/SQL for database queries, constraints, procedures, and triggers. A
4 Use transaction management, concurrency control, and recovery techniques. N
5 Demonstrate query optimization, indexing, hashing, and database security. A
*Revised Bloom’s Taxonomy (RBT)
Teaching and Examination Scheme:
Teaching - Learning Scheme
Total Assessment Pattern and Marks
(in Hours per Semester) Total
Credits
Theory Tutorial / Practical
=
L T P TW/SL TH PA TW/ ESE Marks
TH/30 ESE (E) PA/ (I)
(M) SL (I) (V)
45 0 30 45 120 04 70 30 20 30 50 200
w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page no. 1 of 5
GUJARAT TECHNOLOGICAL UNIVERSITY
Program Name: Bachelor of Engineering
Level: UG
Subject Code : BE03000091
Subject Name : Database Management System
Course Content:
Unit No. of % of
Content
No. Hours Weightage
Introductory concepts of DBMS
1. Purpose of database system, View of data, Database Languages, 3 10
Relational Databases, Database Architecture, Database users, DBA
Relational Model
2. Structure of relational databases, Database Schema, Keys, Schema 4 10
Diagrams, Relational algebra operators, relational algebra queries.
Introduction to SQL:
Overview of SQL Query Language, Basic structure of SQL Queries,
3 DDL, DML, Additional Basic Operations, defining constraints –
Primary key, foreign key, unique, not null, check, Set operations, 6 15
Null values, Aggregate
functions, Built-in functions –numeric, date, string functions, nested
sub- queries, Modification of the Database, DCL and TCL.
Entity-Relationship Model:
Design process, E-R Model, constraints, Removing redundant
4 5 10
attributes in Entity Sets, E-R diagrams, Reduction of E-R database
schema to Relational schema, Design issues.
Relational Database Design:
Features of good relational designs, Dependency preservation,
5. Functional Dependency–definition, Trivial and Non-Trivial FD, 6 15
Closure of FD set, Closure of attributes, Irreducible set of FD,
Decomposition using FD,
Normalization – 1Nf, 2NF, 3NF,BCNF, Multivalued dependency,
4NF.
Transaction Management:
Transactions: Transaction concepts, transaction model, ACID
6. Properties of transactions: Serializability of transactions, testing for
serializability, Concurrency Control: Lock based protocols, deadlock 6 10
handling, Timestamp protocols, Recovery System: Types of
failure, Storage, Recovery and
atomicity, Recovery Algorithms.
Query Processing & Optimization:
7. Overview, measures of query cost, selection and join
operation,evaluation of expressions. Transformation of relational 4 10
expressions, estimating statistics of expression results, evaluation
plans, materialized views.
Database Security
8. Security – Security and Authentication, authorization in SQL, access 4 5
control, DAC, MAC and RBAC models, Intrusion detection, SQL
injection.
Indexing and Hashing
9 Basic Concepts, Ordered Indices, B+-Tree Index Files, Multiple-Key
Access, Static Hashing, Dynamic Hashing, Comparison of Ordered 4 10
Indexing and Hashing, Bitmap Indices, Index Definition in SQL
PL/SQL Concepts
10 Cursors, Stored Procedures and Database Triggers 3 5
w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page no. 2 of 5
GUJARAT TECHNOLOGICAL UNIVERSITY
Program Name: Bachelor of Engineering
Level: UG
Subject Code : BE03000091
Subject Name : Database Management System
Suggested Specification Table with Marks (Theory):
Distribution of Theory Marks (in %)
R Level U Level A Level N Level E Level C Level
10 20 30 20 -- 20
Where R: Remember; U: Understanding; A: Application, N: Analyze and E: Evaluate C:
Create (as per Revised Bloom’s Taxonomy)
References/Suggested Learning Resources:
(a) Books:
1. “Database System Concepts”, 6th Edition by Abraham Silberschatz, Henry F.
Korth, S. Sudarshan, McGraw-Hill.
2. “Fundamentals of Database Systems”, 7th Edition by R. Elmasri and S. Navathe, Pearson
3. “An introduction to Database Systems”, C J Date, Pearson.
4. “Modern Database Management”, Hoffer , Ramesh, Topi, Pearson.
5. “Principles of Database and Knowledge – Base Systems”, Vol 1 by J. D. Ullman,
Computer Science Press.
6. “SQL- PL/SQL”, Ivan bayross
(b) Open source software and website:
7. NPTEL Course: Introduction to Database Systems by Prof. Sreenivasa Kumar- IIT Madras
8. NPTEL Course: Data Base Management System by y Prof. Partha Pratim Das,
Prof. Samiran Chattopadhyay- IIT Kharagpur
Suggested Course Practical List: (List can be change according to Latest Development)
Sr Aim
1 Design and implement sample schema and insert data in tables.
2 Implement Data Definition Language (DDL) and Data Manipulation Language (DML)
commands.
3 Implement Data Constraints: Add primary key, foreign key, unique key, and check constraints,
define and remove integrity constraints using the ALTER TABLE
command.
4 Execute value-matching and pattern-matching conditions on any sample schema to
retrieve specific data based on given requirements.
5 Perform oracle functions: aggregate, numeric, string, conversion, date conversion, date
functions and set operations functions, to manipulate and retrieve data effectively.
6 Study of group by and having clauses.
7 Solve queries using the concept of sub query.
8 Displaying data from Multiple Tables using join operations.
9 Study & Implementation of Database Backup & Recovery commands.
Study & Implementation of Rollback, Commit, Savepoint
10 Study & Implementation of PL/SQL using Cursor and Trigeers.
11 Design and implement sample schema and insert data in tables.
w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page no. 3 of 5
GUJARAT TECHNOLOGICAL UNIVERSITY
Program Name: Bachelor of Engineering
Level: UG
Subject Code : BE03000091
Subject Name : Database Management System
12 Implement Data Definition Language (DDL) and Data Manipulation Language (DML)
commands.
Activities suggested under self-learning:
Sl. Name of the activity No. of hours Evaluation Criteria
No.
1 Assignment writing. Numerical 5 assignments of 3h Based on the assignment
based assignment is preferable. each. Total = 15h submitted.
Problem solving/Coding using C, 5 small coding-based Based on the coding solution
2 C++, Python, SCILAB, MATLAB, problems of 3h each. submitted.
MS-EXCEL or any other relevant Total = 15h
software
Technical Video based learning Duration of video = Report /presentation based on
3 related to the subject 5h the video learning outcomes.
Report preparation &
Presentation = 10h
Total = 15h
4 Discussion on research paper 3 research paper = Summarize research paper and
based on relevant subject 15h evaluation critical parameters
5 Poster/chart/power point Duration = 10 h Based on poster/chart
preparation on technical topics preparation and presentation
skills
6 Application/Software development Duration = 15 h Depending on the complexity
of the Application/Software
7 Group Discussion on Duration = 1 h each Based on performance in
emerging/trending technical topics group discussion, technical
based on subject depth, knowledge etc.
8 Seminar / Presentation Duration for study Topic can be selected
and preparation=5h technical content beyond
Report writing=3h syllabus
Presentation=2h
Total=10h
9 Real world case studies-based Duration of data Based on in-depth study,
learning collection/study = 5h technical depth, data collected,
Report preparation = fact finding, etc.
10h
Total = 15h
10 Working/non-working model on Working = 12 h Based on inter
technical topics Non- working = 8 h department/external
evaluation
11 Self-learning on-line course Minimum duration of Examination based assessment
the course should be at the end of course. Based on
15h. the certificate produced.
12 Complex problem solving Maximum 3 Based on the depth of the
problem. Study of solution submitted.
w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page no. 4 of 5
GUJARAT TECHNOLOGICAL UNIVERSITY
Program Name: Bachelor of Engineering
Level: UG
Subject Code : BE03000091
Subject Name : Database Management System
the problem and
solution finding,
Total = 15h
13 Industry/Research laboratory visit Visit = 5h, Report Based on report submitted.
preparation = 5h Report should contain
Total = 10h observations and calculations
based on industry/ lab data.
14 Videos on Industrial safety aspects Duration of video = Based on quiz/report
based on subject 5h submitted
Report preparation =
5h
Total = 10h
15 Industrial exposure for 2-3 days to Duration = 15 h for Based on evaluation of critical
observe and provide tentative industrial exposure problems and solutions
solutions on society/environment
/health/any other issue Problem
identification and
tentative solution =
10 h
Total = 20 h
Note:
All the suggested activity should be related to the subject.
Min 3 activities must be carried out as per the availability of faculties and students.
The number of hours is suggestive. Faculty can sub-divide the number of hours based on the
activity. However, total number of hours is fixed.
Rubrics for the evaluation can be prepared by the faculty.
All records pertaining to the evaluation and assessment of self-learning activities must be properly
maintained and preserved at the institute level. These records should be made available to the
university upon request.
Institutes are encouraged to utilize digital platforms, such as Microsoft Teams, for effective
record-keeping and to ensure transparency in the evaluation and assessment of self-learning
activities.
*******
w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page no. 5 of 5
