SILVER OAK UNIVERSITY
College of Technology (01)
Bachelor of Technology in (CE/IT/CE-CC/CE-MLAI/CSE-CS) Engineering
Subject Name: Data Base Management Systems
Subject Code: 1010043217
Semester: 3rd
Prerequisite:
1. Basic knowledge of Computer Programming
Objective:
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 and Examination Scheme:
Teaching Scheme Evaluation Scheme
Theory Practical Total
Contact
L T P Credit CIE ESE CIE ESE Marks
Hours
(TH) (TH) (PR) (PR)
4 0 4 8 6 40 60 20 30 150
Content:
Unit Teaching Weightage
Contents
No. Hours %
1 Database system architecture: Data Abstraction, Data 03 05
Independence, Data Definition Language (DDL), Data
Manipulation Language (DML).
2 Data models: Entity-relationship model, network model, 05 12
relational and object oriented data models, integrity
constraints, data manipulation operations.
Relational query languages: Relational algebra, Tuple and 04 08
domain relational calculus, SQL3, DDL and DML constructs,
3
Open source and Commercial DBMS - MYSQL, ORACLE, DB2,
SQL server.
Relational database design: Domain and data dependency, 04 10
4 Armstrong's axioms, Normal forms, Dependency
preservation, Lossless design.
Query processing and optimization: Evaluation of relational 05 10
5 algebra expressions, Query equivalence, Join strategies, Query
optimization algorithms.
6 Storage strategies: Indices, B-trees, hashing 04 07
7 Transaction processing: Concurrency control, ACID 04 15%
property, Serializability of scheduling, Locking and
timestamp based schedulers, Multi-version and optimistic
Concurrency Control schemes, Database recovery.
8 Database Security: Authentication, Authorization and access 04 07%
control, DAC, MAC and RBAC models, Intrusion detection, SQL
injection.
9 SQL Concepts: Basics of SQL, DDL,DML,DCL, structure – 07 18%
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.
10 PL/SQL Concepts: Cursors, Stored Procedures, Stored 03 08%
Function, Database Triggers
Course Outcome:
Sr. No. CO statement Unit No
CO-1 Recognize the various elements of Database Management Systems 1,2
CO-2 Given a problem statement, identify the entities and their relations and
3,4
draw an E-R diagram and design database applying normalization
CO-3 Solve the given problem using Relational Algebra, Relational Calculus, SQL
5,7,9,10
and PL/SQL
CO-4 Apply and relate the concepts of transaction, concurrency control, recovery
6,7,8
and security in database
CO-5 Recognize the purpose of query processing, optimization and demonstrate
8,9,10
the SQL query evaluation
Teaching & Learning Methodology: -
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 an
appreciation 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.
List of Experiments:
1. To study DDL-create and DML-insert commands.
2. Create table and insert sample data in tables.
3. Create Table with Constraints.
Ø Required data constraints/Null Constraints
Ex: In the student database, every student must have an associated student name.
Student_name should not be NULL.
Ø Check Constraints
Ex: Customer table having name and gender which can be M or F.
Ø Primary Key Constraints
Ex: Employee table having Emp_id which must be a Primary key.
4. Perform queries involving predicates LIKE, BETWEEN, IN etc.
5. To perform various data manipulation commands, aggregate functions and sorting
concept on all created tables.
6. To study Single-row functions.
7. Displaying data from Multiple Tables (join)
8. To apply the concept of Aggregating Data using Group functions.
9. To solve queries using the concept of sub query. 10. To apply the concept of security
and privileges
11. To study Transaction control commands.
12. DDL Command:
Alter table: add column, remove column, add constraint, remove constraint, Drop
table
13. Write Cursor. 14. Write Trigger.
15. Design a database for Online Examination.
16. Design a database for Online Attendance System.
Books Recommended: - (minimum 3 books)
1. List of Open “Database System Concepts”, 6th Edition by Abraham Silberschatz,
Henry F. Korth, S. Sudarshan, McGraw-
2. Hill.
3. “Fundamentals of Database Systems”, 7th Edition by R. Elmasri and S. Navathe,
Pearson
4. “An introduction to Database Systems”, C J Date, Pearson.
5. “Modern Database Management”, Hoffer , Ramesh, Topi, Pearson.
6. “Principles of Database and Knowledge – Base Systems”, Vol 1 by J. D. Ullman,
Computer Science Press.
7. “Understanding SQL”, Martin Gruber, BPB
8. “SQL- PL/SQL”, Ivan bayross
Source Software/learning website:
• [Link]
• [Link]
• [Link]