SCHOOL OF ARTS AND SCIENCE

COURSEPLAN RECORD
Strategy is important, but execution is everything.
Incredibly successful people focus on executing
incredibly well

Academic Year : 24-24

Programme : B.Sc
Semester : IV
Class :COMPUTER SCIENCE
Course Title : DATABASE MANAGEMENT SYSTEMS
Course Code : A20CPT408
Credits allotted/ week :4
Periods allotted / week : 12
Total Periods allotted / sem : 60

Name of the Faculty : P Sangeetha

Department :DEPARTMENT OF COMPUTATIONAL STUDIES

:
SCHOOL OF ARTS AND SCIENCE

Instructions for planning the academic classes

1. For a 3 credit course ( Part I and II language courses) a maximum of 4 periods

are to be allotted per week
2. For a 4 credit course, maximum 6 hours and 1 test hour could be allotted per
week in case of DSC and DSE courses
3. For 2 credit practical courses, a maximum of 4 periods/ week are to be allotted
4. For open elective courses, a maximum of 2 periods / week are to be allotted
5. 1 period per week for library is be allotted
6. Out of 48 periods, all these could be planned for 40 periods, 5 periods for value
added coaching classes and 3 periods for department activities
7. A minimum of 5 invited lectures, 5 student forums, 1 state level/national level
convention are to be planned for one semester
SCHOOL OF ARTS AND SCIENCE

Sl. DATE PERIO UNIT CLASS CONTENT

N D
o. Lecture content Workshop / Expert talk
Seminar

1 UNIT - I Introduction of
Data Base

2 Data Base System

Application

3 Purpose of
Database System

4 DBMS –
Approaches

5 Advantages of
DBMS

6 Limitation of
DBMS

7 View of data SEMINAR

8 Relational
database

9 Advantages and
disadvantages of
RDBMS

10 Database design

11 System structure

12 Database
architecture
13 UNIT – II Database Design

14 ER Model

15 Overview of design
process

16 The ER model SEMINAR

17 Constraints

18 ER Diagram

19 Relational Algebra

20 Relational Algebra
– Detailed
Explanation

21 Tuples Relational SEMINAR

Calculus

22 Tuples Relational
Calculus

23 Domain relational
calculus

24 ER Model
Explanation

25 UNIT - III Relational

database design

26 Relational SEMINAR
database design -
concept
explanation

27 Features of Good
Relational Designs

28 Normalization
using functional
dependencies

29 First normal form

30 First normal form –
explanation

31 Second normal
form

32 Second normal
form – explanation

33 Third normal form

34 Third normal form

– explanation

35 Fourth normal form

36 BCNF

37 UNIT - IV SQL- SQL

Statements

38 Data Retrieval:
SELECT

39 Data Definition
Languages:
CREATE

40 ALTER, DROP

41 RENAME, and SEMINAR

TRUNCATE

42 Data
Manipulation
Language:
INSERT

43 UPDATE

44 DELETE

45 Transactional
Control:
COMMIT
46 Rollback

47 SAVEPOINT

48 Data
Control
Language:
GRANT,
REVOKE
49 UNIT-V PL/SQL-Blocks

50 PL/SQL

51 Basic programs

52 Procedures

53 Functions

54 Cursor SEMINAR

55 Triggers

56 Exception
Handling
57 Sample programs
of basic

58 Sample programs-
procedures

59 Sample programs-
functions

60 Sample programs-
triggers

61 REVISION –UNITI

62
FACULTY HOD DEAN DEAN -ACADEMICS

L T P C Hrs
A20CPT408 DATABASE MANAGEMENT SYSTEMS
4 0 0 4 60
Course Objectives
 To learn about Database Structure and Data Models.
 To study SQL Commands for storing and retrieving data into the database.
 To study the Relational database system design
 To understand the concept of Transactions
 To understand the concept of procedural language/Structured Query Language

Course Outcomes
After completion of the course, the students will be able to
CO1 – Design conceptual data model using Entity Relationship
Diagram. CO2 – Design conceptual and logical database
models for an application. CO3 – Normalize relational
database design of an application.
CO4 – Explain the need for Indexing, Hashing in database.
CO5 – Understand the strategies for procedural language/Structured Query Language.

UNIT I INTRODUCTION (12Hrs)

Introduction: Database System – Database-System Applications – Purpose of Database
Systems – Advantages of using DBMS approach - View of Data – Relational Database –
Database Design – System Structure – Database Architecture.

UNIT II DATABASE DESIGN AND E-RMODEL (12Hrs)

Database Design and E-R Model: Overview of the Design Process – The E-R Model –
Constraints – E-R Diagrams – Relational Algebra – Tuple Relational Calculus – Domain
Relational Calculus.

UNIT III RELATIONAL DATABASE DESIGN (12Hrs)

Relational Database Design: Features of Good Relational Designs – Normalization
Using Functional Dependencies - First Normal Form - Second Normal Form - Third Normal
Form - Fourth Normal Form and BCNF.

UNIT IV SQL

(12Hrs)
SQL Statements: Data Retrieval: SELECT, Data Definition Languages: CREATE, ALTER,
DROP, RENAME, and TRUNCATE - Data Manipulation Language: INSERT UPDATE, DELETE -
Transactional Control: COMMIT ROLLBACK, SAVEPOINT, and Data Control Language: GRANT,
REVOKE.

UNIT V PL/SQL (12Hrs)

PL/SQL blocks – PL/SQL - Basic programs - Procedures – Functions – Cursor –
Triggers - Exception Handling.

Text Books
1. Abraham Silberschatz, Henry F Korth, S Sudharshan, “Database System Concepts”,
McGraw-Hill, 7th Edition, 2019.
2. RamezElmasri and ShamkantNavathe, Durvasula V L N Somayajulu, Shyam K
Gupta, “Fundamentals of Database Systems”, Pearson Education, 2018.
3. Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom, “Database Systems The
Complete Book”