Scribd
Upload
12 views2 pages

RDBMS Course Overview and Objectives

This document provides an overview of a 7-day Relational Database Management System (RDBMS) course. The course objectives are to introduce basic RDBMS concepts, database design using ER modeling and normalization, SQL commands, embedded SQL concepts, and online transaction processing (OLTP) concepts. The course is divided into 5 units covering introduction to RDBMS, ER modeling, normalization, SQL, and OLTP and online analytical processing (OLAP) concepts. The course is designed for software engineers and requires knowledge of basic file handling and programming fundamentals.

Uploaded by

wanya64
Copyright
© Attribution Non-Commercial (BY-NC)
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
12 views2 pages

RDBMS Course Overview and Objectives

This document provides an overview of a 7-day Relational Database Management System (RDBMS) course. The course objectives are to introduce basic RDBMS concepts, database design using ER modeling and normalization, SQL commands, embedded SQL concepts, and online transaction processing (OLTP) concepts. The course is divided into 5 units covering introduction to RDBMS, ER modeling, normalization, SQL, and OLTP and online analytical processing (OLAP) concepts. The course is designed for software engineers and requires knowledge of basic file handling and programming fundamentals.

Uploaded by

wanya64
Copyright
© Attribution Non-Commercial (BY-NC)
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

Relational Database Management System

Course Description
Course number DB07 Course RDBMS
Author(s) Seema Acharya. Name
Pre-requisites for attending course
Knowledge of basic file handling concepts, programming fundamentals
Stream Target Compet Type Category3
PM Role1 encies2 Essential DB
SE TK, D
Estimated course 7 days ( 3.5 hours of lecture and 4.5 hours of practical/day)
duration

Course Objectives
Sl# Objective Demonstrable knowledge/skills
1. To introduce basic RDBMS concepts Knowledge of basic concepts and terminology

2. To introduce database design Knowledge of ER modeling and normalization

3. To introduce SQL commands Knowledge of DDL , DML and DCL commands

4. To introduce embedded SQL concepts Ability to understand a PRO*C program

5. To introduce OLTP concepts and Knowledge of serializability of transactions,


introduction to OLAP concurrency and recovery

Course Design
Sl# Unit name Unit objectives and keywords Lecture
Duration
(hrs.)
1. Introduction To explain basic RDBMS concepts and 1.5
introduce basic terminology

2. ER modeling To explain ER modeling notations, 3


construct ER diagrams and convert ER
diagram to relational schema
3. Normalization To explain functional dependency and 3
normal forms (1NF, 2NF, 3NF , BCNF)

4. SQL To explain the basic DDL ,DML 10


commands, the concept of sub queries
(independent and correlated), Views, set
operations (union, intersect, minus), Joins,
Embedded SQL,
5. OLTP & Intro to OLAP To introduce basic transaction processing 7
concepts , ACID properties of transactions,
serializability of transactions, Locking,
Timestamping and Recovery mechanisms
To introduce OLAP, data warehousing, data
marts, Star schema and Snowflake schema

1
PM Stream (Choose one)-SE: Software Engineer, PA: Programmer Analyst, PM: Project Manager
2
Competencies (Choose appropriate ones)-TK:Technical Knowledge, P:Programming, T:Testing, D:Design,
A:Analysis, PS:Pre-sales.
3
Category (Choose one)-PL: Programming or Programming Language, OS: Operating Systems, DB: Database, NM:
Networks and Middleware, SE: Software Engg, TO: Technical Overview

ER/CORP/CRS/DB07/001 Version No: 1.0 1


Sources
1. “Database system concepts”, Henry F Korth, Abraham Silberschatz, Second ed., McGraw-Hill
International editions, Computer Science series(1991)

2. "Fundamentals of Database Systems", Elmasri, Navathe, Third ed, Addison Wesley

3. "An introduction to Database Systems", [Link], Sixth ed, Narosa Publications

ER/CORP/CRS/DB07/001 Version No: 1.0 2

You might also like