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
Session 1
| Database Systems |
| Common uses of Database System |
https://whatisdbms.com/application-and-uses-of-database-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.
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
Session 3
| Database, Database Management System (DBMS) |
| Database Application Programs, |
https://www.geeksforgeeks.org/introduction-of-dbms-database-management-system-set-1/
Session 4
| Components of DBMS Environment |
| Advantages and Disadvantages of DBMS |
https://www.dataentryoutsourced.com/blog/components-of-a-database-management-system/
Session 5
| Roles of Database Administrators (DBA) |
| Roles of Database Designers |
Session 6
| Roles of Application Developers |
| Roles of End-Users |
https://www.prospects.ac.uk/job-profiles/applications-developer
Session 7
| Database System Architecture: Three Level Architecture |
Session 8
| Schemas, Mappings, and Instances |
Session 9
| Data Independence |
| Data Abstraction |
https://www.tutorialspoint.com/dbms/dbms_data_independence.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 11
| Data models, E-R models |
| Relational models |
https://www.guru99.com/er-diagram-tutorial-dbms.html
https://www.tutorialspoint.com/dbms/relational_data_model.htm
Session 10
| Database Languages: Data Definition Language (DDL), Data Manipulation Language (DML) |
Session 13
| Normalization: Normal forms: 1NF, 2NF, 3NF |
Session 14
| Relational Data Structure |
| Mathematical Relations |
https://www.tutorialspoint.com/dbms/relational_data_model.htm
Session 15
| Database Relations, |
| Properties of Relations |
https://en.wikipedia.org/wiki/Relation_(database)
https://www.cs.wcupa.edu/~zjiang/RDB_table.htm
Session 17
| Representing Relational Database Schema |
https://www.tutorialspoint.com/dbms/dbms_data_schemas.htm
Session 24
| Data Manipulation: Simple Queries, Sorting Results (Order By) |
Session 22
| Creating a Database, Table Operations (Create, Alter, and Drop) |
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