Scribd
Upload
114 views3 pages

Database Management Systems - Theory

The document provides details about the Database Management Systems course for the fourth semester of the Bachelor of Technology in Computer Engineering program. It includes the course objectives, outcomes, topics, textbooks, and open source software resources. The course covers concepts like the relational model, SQL, ER modeling, normalization, transactions, and indexing techniques.

Uploaded by

Rutvika Ghadiyali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
114 views3 pages

Database Management Systems - Theory

The document provides details about the Database Management Systems course for the fourth semester of the Bachelor of Technology in Computer Engineering program. It includes the course objectives, outcomes, topics, textbooks, and open source software resources. The course covers concepts like the relational model, SQL, ER modeling, normalization, transactions, and indexing techniques.

Uploaded by

Rutvika Ghadiyali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Effective From

BHAGWAN MAHAVIR UNIVERSITY (2022-2023)

Bachelor of Technology (Computer Engineering)

Semester: IV
Teaching Scheme (Hours)
Subject Theory
Subject Title Total
Code Theory Tutorial Credits Examination Marks Marks
Internal External
Database
Management
2010206403 4 0 4 40 60 100
Systems -
Theory

Prerequisite: Basic knowledge of Computer Programming and Data Structure

Objective of the course:

 To introduce about database management systems.


 To give a good formal foundation on the relational model of data and usage of Relational
Algebra.
 To introduce the concepts of basic SQL as a universal Database language.
 To demonstrate the principles behind systematic database design approaches by covering
conceptual design, logical design through normalization.
 To provide an overview of physical design of a database system, by discussing Database
indexing techniques and storage techniques.

Course Outcomes:
Upon completion of the course, the student shall be able:

Sr. Marks %
CO statement
No. weightage
CO-1 Describe a relational database and object-oriented database 20

CO-2 Create, maintain and manipulate a relational database using SQL 20

CO-3 Describe ER model and normalization for database design 20


Examine issues in data storage and query processing and can formulate
CO-4 20
appropriate solutions
Outline the role and issues in management of data such as efficiency,
CO-5 20
privacy, security, ethical responsibility, and strategic advantage

Registrar Dean- Academics Chairman - BOS


Effective From
BHAGWAN MAHAVIR UNIVERSITY (2022-2023)

Detail Content:
Sr. Total
Topic
No. Hrs.
Introduction: Database system, Characteristics (Database Vs File System),
Database Users (Actors on Scene, Workers behind the scene), Advantages of
Database systems, Database applications. Brief introduction of different Data
1 8
Models; Concepts of Schema, Instance and data independence; Three tier schema
architecture for data independence; Database system structure, environment,
Centralized and Client Server architecture for the database.
Relational Model: Introduction to relational model, concepts of domain, attribute,
tuple, relation, importance of null values, constraints (Domain, Key constraints,
integrity constraints) and their importance
12
2 BASIC SQL: Simple Database schema, data types, table definitions (create, alter),
different DML operations (insert, delete, update), basic SQL querying (select and
project) using where clause, arithmetic & logical operations, SQL functions (Date
and Time, Numeric, String conversion).
Entity Relationship Model: Introduction, Representation of entities, attributes,
entity set, relationship, relationship set, constraints, sub classes, super class,
inheritance, specialization, generalization using ER Diagrams.
3 SQL: Creating tables with relationship, implementation of key and integrity 12
constraints, nested queries, sub queries, grouping, aggregation, ordering,
implementation of different types of joins, view(updatable and non-updatable),
relational set operations.
Schema Refinement (Normalization): Purpose of Normalization or schema
refinement, concept of functional dependency, normal forms based on functional
4 dependency(1NF, 2NF and 3 NF), concept of surrogate key, Boyce-codd normal 12
form(BCNF), Lossless join and dependency preserving decomposition, Fourth
normal form(4NF), Fifth Normal Form (5NF).
Transaction Concept: Transaction State, Implementation of Atomicity and
Durability, Concurrent Executions, Serializability, Recoverability, Implementation
of Isolation, Testing for Serializability, Failure Classification, Storage, Recovery
and Atomicity, Recovery algorithm.
5 12
Indexing Techniques: B+ Trees: Search, Insert, Delete algorithms, File
Organization and Indexing, Cluster Indexes, Primary and Secondary Indexes ,
Index data Structures, Hash Based Indexing: Tree base Indexing ,Comparison of
File Organizations, Indexes and Performance Tuning

Registrar Dean- Academics Chairman - BOS


Effective From
BHAGWAN MAHAVIR UNIVERSITY (2022-2023)

Text books:

1. Database Management Systems, 3/e, Raghurama Krishnan, Johannes Gehrke, TMH


2. Database System Concepts,5/e, Silberschatz, Korth, TMH
3. Introduction to Database Systems, 8/e C J Date, PEA.
4. Database Management System, 6/e Ramez Elmasri, Shamkant B. Navathe, PEA
5. Database Principles Fundamentals of Design Implementation and Management, Corlos
Coronel, Steven Morris, Peter Robb, Cengage Learning.

List of Open Source Software/learning website:

1. https://nptel.ac.in/courses/106/106/106106220/
2. https://www.geeksforgeeks.org/introduction-to-nosql/

*******************************************************************

Registrar Dean- Academics Chairman - BOS

You might also like