DBMS
DBMS
DBMS
College of Technology
Bachelor of Technology
Information Technology
Course Name: Database Management Systems
Course Code: 1010043223
Semester: 3rd
Prerequisite:
1. Basic knowledge of Computer Programming
Course Objectives:
1. Database is an integral part of real-life application system. The course will enable student understand the
different issues involved in the design and implementation of a database system. Student will learn the
physical and logical database designs, database modeling, relational, hierarchical, and network models.
2. Student will learn to use data manipulation language to query, update, and manage a database. Student
will understand essential DBMS concepts such as: database security, integrity, concurrency, storage
strategies etc. The students will get the hands-on practice of using SQL and PL/SQL concepts.
Teaching Scheme:
Teaching Scheme
L T P Contact Hours Credit
4 0 4 8 6
Contents:
Course Outcomes:
Sr.
CO Statement Unit
No.
CO-1 Recognize the various elements of Database Management Systems 1,2
Given a problem statement, identify the entities and their relations and 3,4
CO-2
draw an E-R diagram and design database applying normalization
Solve the given problem using Relational Algebra, Relational Calculus, 5,7,9,10
CO-3
SQL and PL/SQL
Apply and relate the concepts of transaction, concurrency control, recovery 6,7,8
CO-4
and security in database
Recognize the purpose of query processing, optimization 8,9,10
CO-5
and demonstrate the SQL query evaluation
The various methods or tools follows by the faculties to teach the above subject are:
1. The course includes a laboratory, where students have an opportunity to build anappreciation for
the concepts being taught in lectures.
2. Lectures with live practical example using Projector and Computer.
3. Experiments shall be performed in the laboratory related to course contents.
Books Recommended:
1. List of Open “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. “Understanding SQL”, Martin Gruber, BPB
7. “SQL- PL/SQL”, Ivan bayross
1. http://silveroakuni.ac.in/video-lecture
2. https://nptel.ac.in/
3. https://nptel.ac.in/courses/106/105/106105175/