RDBMS

Teacher

Sanjib Kumar Naik

Category

Core Courses

Course Attendees

Still no participant

Course Reviews

Still no reviews

Course Name : RDBMS

Code(Credit) : BCA2302(3-2-1)

Course Objectives

  • List and explain the fundamental concepts of a relational database system.
  • Utilize a wide range of features available in a RDBMS package.
  • Analyze database requirements and determine the entities involved in the system and their relationship to one another.
  • Develop the logical design of the database using data modeling concepts such as entity-relationship diagrams.
  • Create a relational database using a relational database package.
  • Manipulate a database using SQL.
  • Assess the quality and ease of use of data modeling and diagramming tools.
  • I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Learning Outcomes

Understand database concepts and structures and query language
Understand the E R model and relational model
To design and build a simple database system and demonstrate competence with the fundamental tasks involved with modeling, designing, and implementing a DBMS.
Understand Functional Dependency and Functional Decomposition.
Apply various Normalization techniques
Package and Triggers
Execute various advance SQL queries related to Transaction Processing & Locking using concept of Concurrency control.
Understand query processing and techniques involved in query optimization.
Understand the principles of storage structure and recovery management.
  • I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Course Syllabus

BCA2302 RDBMS-(3-2-1)

MODULE I ( 5 HRS)
Introduction to Database Systems and File Based Systems: Database Systems, Common

uses of Database Systems, File Based Approach, Limitations of File Based Approach,

File-oriented Systems vs. Database Systems

Database Approach: Database, Database Management System (DBMS), Database

Application Programs
Assignment 1: Explain File-oriented Systems vs. Database Systems ?

MODULE II ( 5 HRS)
Components of DBMS Environment, Advantages and Disadvantages of DBMS.
Roles in Database Environment: Data and Database Administrators (DBA),
Database Designers, ApplicationDevelopers, End-Users.
Assignment 2: Explain Components of DBMS Environment ?

MODULE-III (5 HRS):
Database System Architecture: Three Level Architecture, External Level, Conceptual

Level, Internal Level,Schemas, Mappings, and Instances, Data Independence, Data

Abstraction Database Languages: Data Definition Language (DDL), Data Manipulation

Language (DML).
Assignment 3: Explain Three Level Architecture of Database ?
Practice:
1. Introduction to Database and Database languages.

MODULE-IV (5 HRS):
Data Models and Conceptual Modelling: Data models, E-R models, Relational models,

Network and Object Oriented Data models, Mapping E-R model to Relational model.
Normalization: Normal forms: 1NF, 2NF, 3NF
Terminologies of Relational Model: Relational Data Structure, Mathematical

Relations, Database Relations
Assignment 4: Explain Normalizations and types of Normalizations ?

MODULE-V (5 HRS):
Properties of Relations, Relational Keys, Representing Relational Database Schema.
Integrity Constrains and Views: Nulls, Entity Integrity, Referential Integrity,

General Constraints, Views,Purpose of Views.
SQL: Introduction: Objectives of SQL
Assignment 5: Explain views and purposes of Views ?

MODULE-VI (3 HRS):
Writing SQL Command. SQL: Data Definition: Data Definition,
Creating a Database, Table Operations (Create, Alter, and Drop), Creating an Index,

Removing an Index.SQL:Data Manipulation: Simple Queries, Sorting Results (Order By)

Practice:
2. Use of SQL syntax: insertion, deletion using SQL.
3. Use of SQL syntax: updation, modification using SQL.
4. Programs on join statements and SQL queries including where clause.

MODULE-VII (2 HRS):
Aggregate Functions, Join, Grouping Results
(Group By) Query-By-Example: Introduction to QBE, Building Select queries using

QBE.

Practice:
5. Programs on procedures and functions.
6. Programs on database triggers.
7. Programs on packages.
8. Programs on data recovery using check point technique.
9. Concurrency control problem using lock operations.
10. Programs on JDBC and ODBC using database.

TEXT BOOKS:
1. Database Systems By Thomas M. Connolly and Carolyn E. Begg – Pearson Education-

4th, edition (Chapters: 1,
2, 3, 5, 6, 7.1, 7.2, 11, 13)
2. Fundamentals of Database System By Elmasari & Navathe – Pearson Education-5th,

Edition.

REFERENCE BOOKS:
1. An introduction to Database System – Bipin Desai, Galgotia Publications
2. Database System: concept, Design & Application – S.K.Singh (Pearson Education)
3. Fundamentals of Database Management System – Gillenson, Wiley India
4. Database System Concepts – Sudarshan, Korth (McGraw-Hill Education) -6th,

edition

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Session Plan

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Session 2

File Based Approach, Limitations of File Based Approach
File-oriented Systems vs. Database Systems

https://tutorialink.com/dbms/advantage-and-disadvantages-of-file-oriented-system.dbms

https://www.youtube.com/watch?v=8dYCZFTtYjY

Session 7

Database System Architecture: Three Level Architecture

https://www.youtube.com/watch?v=dfEgLlTVQNQ

Session 8

Schemas, Mappings, and Instances

https://www.tutorialspoint.com/dbms/dbms_data_schemas.htm

Session 12

Network and Object Oriented  Model
Mapping E-R model to Relational model

https://en.wikipedia.org/wiki/Network_model

https://www.tutorialspoint.com/dbms/er_model_to_relational_model.htm

Session 10

Database Languages: Data Definition Language (DDL), Data Manipulation Language (DML)

https://www.youtube.com/watch?v=kx6m8ABU4ZE

Session 13

Normalization: Normal forms: 1NF, 2NF, 3NF

https://beginnersbook.com/2015/05/normalization-in-dbms/

Session 20

Objectives of SQL

http://www.sqlcourse.com/intro.html

Session 19

Views  and  Purpose of Views.

https://www.tutorialspoint.com/sql/sql-using-views.htm

Session 17

Representing Relational Database Schema

https://www.tutorialspoint.com/dbms/dbms_data_schemas.htm

 

 

Session 21

Writing SQL Command

https://www.tutorialspoint.com/sql/sql-syntax.htm

Session 24

Data Manipulation: Simple Queries, Sorting Results (Order By)

https://www.w3schools.com/sql/sql_orderby.asp

Session 23

Creating and  Removing an  Index

https://www.w3schools.com/sql/sql_create_index.asp

Session 22

Creating a Database, Table Operations (Create, Alter, and Drop)

https://www.w3schools.com/sql/sql_create_db.asp

Session 29

Building Select queries using QBE.

https://en.wikipedia.org/wiki/Query_by_Example

Session 28

Query-By-Example: Introduction to QBE

https://en.wikipedia.org/wiki/Query_by_Example

Session 27

Grouping Results  Group  By

https://www.tutorialspoint.com/sql/sql-group-by.htm

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Case Studies

Case Studies

Our Main Teachers

Sanjib Kumar Naik

Asst Prof Dept of IT
VIEW PROFILE