DBMS

Download as pdf or txt
Download as pdf or txt
You are on page 1of 3

SILVER OAK UNIVERSITY

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:

Unit Topics Teaching % Weightage


Hours
1 Database system architecture: 3 5%
Data Abstraction, Data Independence, Data Definition Language
(DDL), DataManipulation Language (DML).
2 Data models: 5 12%
Entity-relationship model, network model,relational and object
oriented data models, integrity Constraints, data manipulation
operations.
3 Relational query languages: 4 8%
Relational algebra, Tuple and domain relational calculus, SQL3,
DDL and DML constructs, Open source and Commercial DBMS -
MYSQL, ORACLE, DB2, SQL server.
4 Relational database design: 4 10%
Domain and data dependency, Armstrong's axioms, Normal forms,
Dependency preservation, Lossless design.
5 Query processing and optimization: 5 10%
Evaluation of relationalalgebra expressions, Query equivalence,
Join strategies, Query optimization algorithms.
6 Storage strategies: 4 7%
Indices, B-trees, hashing
7 Transaction processing: 4 15%
Concurrency control, ACID property, Serializability of scheduling,
Locking and timestamp based schedulers, Multi-version and
optimistic Concurrency Control schemes, Database recovery.
8 Database Security: 4 7%
Authentication, Authorization and access control, DAC, MAC and
RBAC models, Intrusion detection, SQLinjection.
9 SQL Concepts: 7 18%
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.
10 PL/SQL Concepts: 3 8%
Cursors, Stored Procedures, StoredFunction, Database Triggers

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

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 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.

List of Experiments: Total Hours: 56

Sr. No. Practical Name


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 sortingconcept
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 securityand
privileges.
10 To study Transaction control commands.
11 DDL Command: Alter table: add column, remove column, add constraint, remove
constraint, Droptable
12 Write Cursor. 14. Write Trigger.
13 Design a database for Online Examination.
14 Design a database for Online Attendance System.

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

List of Open-Source Software/learning website:

1. http://silveroakuni.ac.in/video-lecture
2. https://nptel.ac.in/
3. https://nptel.ac.in/courses/106/105/106105175/

You might also like