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”
