Handbook of [Link]. Programmes offered by USICT at Affiliated Institutions of the University.
Introduction to Database Management Systems L P C
3 3
Discipline(s) / EAE / OAE Semester Group Sub-group Paper Code
OAE 6 SD-OAE SD-OAE-2B OSD-336T
EE-VDT/EC-ACT 7 OAE-ECE-EA OAE-2 OCSE-407T
OAE 7 CSE-OAE CSE-OAE-3 OCSE-407T
Marking Scheme:
1. Teachers Continuous Evaluation: 25 marks
2. Term end Theory Examinations: 75 marks
Instructions for paper setter:
1. There should be 9 questions in the term end examinations question paper.
2. The first (1st) question should be compulsory and cover the entire syllabus. This question should be
objective, single line answers or short answer type question of total 15 marks.
3. Apart from question 1 which is compulsory, rest of the paper shall consist of 4 units as per the syllabus.
Every unit shall have two questions covering the corresponding unit of the syllabus. However, the student
shall be asked to attempt only one of the two questions in the unit. Individual questions may contain upto
5 sub-parts / sub-questions. Each Unit shall have a marks weightage of 15.
4. The questions are to be framed keeping in view the learning outcomes of the course / paper. The standard
/ level of the questions to be asked should be at the level of the prescribed textbook.
5. The requirement of (scientific) calculators / log-tables / data – tables may be specified if required.
Course Objectives :
1. To introduce basic concepts, architecture and characteristics of database systems.
2. To introduce relational model concepts and PL/SQL programming.
3. To introduce relational database design and Normal forms based on functional dependencies.
4. To introduce concepts of object oriented & distributed databases.
Course Outcomes (CO)
CO 1 Ability to understand advantages of database systems.
CO 2 Ability to use SQL as DDL, DCL and DML.
CO 3 Ability to design database and manage transaction processing.
CO 4 Understand object oriented & distributed databases systems and use them.
Course Outcomes (CO) to Programme Outcomes (PO) mapping (scale 1: low, 2: Medium, 3: High)
PO01 PO02 PO03 PO04 PO05 PO06 PO07 PO08 PO09 PO10 PO11 PO12
CO 1 3 3 2 2 2 - - - 3 2 2 3
CO 2 3 3 2 2 2 - - - 3 2 2 3
CO 3 3 3 2 3 3 - - - 3 2 2 3
CO 4 3 3 2 3 3 - - - 3 2 2 3
UNIT – I
Basic concepts: database & database users, characteristics of the database systems, concepts and
architecture, date models, schemas & instances, DBMS architecture & data independence, data modelling
using the entity-relationship approach.
SQL – DDL, DCL & DML views and indexes in SQL. Basics of SQL, DDL, DML,DCL, structure – creation, alteration,
defining constraints – Primary key, foreign key, unique, not null, check, IN operator.
UNIT - II
Enhanced ER Concepts: Specialization/Generalization, Aggregation, Mapping of ER model to Relational Model.
SQL – Functions - aggregate functions, Built-in functions – numeric, date, string functions, set operations, sub-
queries, correlated sub-queries, Use of group by, having, order by, join and its types, Exist, Any, All , view and
its types. Transaction control commands – Commit, Rollback, Save point.
Applicable from Batch Admitted in Academic Session 2021-22 Onwards Page 990
Handbook of [Link]. Programmes offered by USICT at Affiliated Institutions of the University.
UNIT - III
Relational Model: Concepts, relational model constraints, relational algebra.
Relational Database Design: functional dependencies & normalization for relational databases, normal forms
based on functional dependencies, (1NF, 2NF, 3NF & BCNF), lossless join and dependency preserving
decomposition.
Database Programming – control structures, exception handling, stored procedures, Triggers.
UNIT - IV
Properties of Transaction, Transaction states, Transaction Schedule, Serializability, Concurrency control
techniques, locking techniques, Recoverable schedules, Deadlock detection and Recovery, recovery
techniques: recovery concepts.
Concepts of Object Oriented Database Management systems & Distributed Database Management Systems
Textbooks:
1. R. Elmsari and S. B. Navathe, “Fundamentals of database systems”, Pearson Education, 7th Edition, 2018
2. V. M. Grippa and S. Kumichev, “Learning MySQL”, O’Reilly, 2021.
3. SQL/ PL/SQL, The programming language of Oracle, Ivan Bayross, 4th Edition BPB Publications
References:
1. A. Silberschatz, H. F. Korth and S. Sudershan, “Database System Concept”, McGraw Hill, 6th Edition,2013.
2. Date, C. J., “An introduction to database systems”, 8th Edition, Pearson Education, 2008.
3. Desai, B., “An introduction to database concepts”, Galgotia publications, 2010
4. H. Garcia-Molina, J. D. Ullman, J. Widom, “Database System: The Complete Book”, PH.
5. Oracle and MySQL manuals.
Applicable from Batch Admitted in Academic Session 2021-22 Onwards Page 991
Handbook of [Link]. Programmes offered by USICT at Affiliated Institutions of the University.
Introduction to Database Management Systems Lab L P C
2 1
Discipline(s) / EAE / OAE Semester Group Sub-group Paper Code
OAE 6 SD-OAE SD-OAE-2B OSD-336P
EE-VDT/EC-ACT 7 OAE-ECE-EA OAE-2 OCSE-407P
OAE 7 CSE-OAE CSE-OAE-3 OCSE-407P
Marking Scheme:
1. Teachers Continuous Evaluation: 40 marks
2. Term end Theory Examinations: 60 marks
Instructions:
1. The course objectives and course outcomes are identical to that of (Introduction to Database Management
Systems) as this is the practical component of the corresponding theory paper.
2. The practical list shall be notified by the teacher in the first week of the class commencement under
intimation to the office of the Head of Department / Institution in which the paper is being offered from the
list of practicals below. Atleast 10 experiments must be performed by the students, they may be asked to
do more. Atleast 5 experiments must be from the given list.
13. Experiments based on DDL commands – CREATE, ALTER, DROP and TRUNCATE.
14. Apply the integrity constraints like Primary Key, Foreign key, Check, NOT NULL, etc. to the tables.
15. Experiments based on basic DML commands – SELECT, INSERT, UPDATE and DELETE.
16. Write the queries for implementing Built-in functions, GROUP BY, HAVING and ORDER BY.
17. Write the queries to implement the joins.
18. Write the queries to implement the subqueries.
19. Write the queries to implement the set operations.
20. Write the queries to create the views and queries based on views.
21. Demonstrate the concept of Control Structures.
22. Demonstrate the concept of Exception Handling.
23. Demonstrate the concept of Functions and Procedures.
24. Demonstrate the concept of Triggers.
Applicable from Batch Admitted in Academic Session 2021-22 Onwards Page 992