PCTE Group Of Institutes
Course: BCA
Subject Name: Database Management System
Subject Code: BSBC 404
Semester: 4th
Credit: 4 Hrs/Week
Course Instructor: Richa Arora,Lata Pant
Email Address: richaarora@[Link],latapant@[Link]
OVEARALLCOURSE OBJECTIVES
To make students aware about the basics of Database Management System and understand its importance in
automation of various Systems and efficient management of data at various levels within an organisation.
Faculty of Computer Applications Page 1
PCTE Group Of Institutes
COURSE OUTCOMES
After studying this Course, the Students will be able to:-
• Understand and create a database that is used in day-to-day life(e.g. online food delivery, online cab booking,
ola etc.)
• Perform all DDL and DML Commands on the database
Faculty of Computer Applications Page 2
PCTE Group Of Institutes
SYLLABUS
SECTION A
An overview of DBMS: Concept of File Processing Systems and database systems, Database Administrator and his responsibilities.
Physical and Logical data independence.
Three level Architecture of Database System: the external level, conceptual level and the
Internal level.
SECTION B
Introduction to Data Models: Entity Relationship Model, Hierarchical, Network and Relational Model. Comparison of Network,
Hierarchical and Relational Model.
SECTION C
Relational data Model: Relational database functional dependency, join, normalization. , relational algebra and calculus, SQL
dependencies, multi-valued dependency
SECTION D
Database protection: Recovery, Concurrency Management, Database Security, Integrity and Control, Disaster Management
Faculty of Computer Applications Page 3
PCTE Group Of Institutes
Recommended Books:
1. C.J. Date, "An Introduction to Data Base Systems", Narosa Publications.
2. Henry F. Korth, "Database System Concepts", McGraw Hill.
3. Naveen Prakash, "Introduction to Database Management", TMH
4. Bipin C. Desai, "An Introduction to Database System", Galgotia Publications.
Text Book:
• DBMS by Atul Kahate
Faculty of Computer Applications Page 4
PCTE Group Of Institutes
EVALUATION CRITERIA
PARAMETER MARKS Marks
Mid Semester Examination 1 40 10
Mid Semester Examination 2 40 10
Presentation 20 10
Full Syllabus Test ( Best two out of
MSE 1, MSE 2 and full syllabus will 40*
be considered)
Class Test 20 5
Attendance (absolute 5 marks in 5
5
internal)
• Attendance 100 % = 5 marks
▪ 95%-100%=4marks
▪ 90%-95%= 3 marks
▪ 85%-90%=2 marks
▪ 80%- 85%=1 mark
Total 165 40
Faculty of Computer Applications Page 5
PCTE Group Of Institutes
Attendance Policy:
It is compulsory for all the students to have 75% attendance at the end of the semester failing which the student will not be allowed to write the
final exam.
Faculty of Computer Applications Page 6
PCTE Group Of Institutes
Presentation:
▪ The Students will deliver presentation on the individual topics assigned to them. The students will
explain their projects starting from requirement analysis till the work completed before the day of
presentation.
Guest Lecture:
Topic Covered: Importance of database in Dynamic Projects.
Speaker Name:[Link]
Company Name:Infino,Ludhiana
Presentation Topic Details:-
Inventory Control Management
1
2 Student Record Keeping System
Faculty of Computer Applications Page 7
PCTE Group Of Institutes
3 Online Retail Application
4 Logistics Management System
5 Railway System
6 Hospital Management System
7 Library Management System
8 Result Management System
9 Healthcare Organization
10 Restaurant Management
11 Blood Donation System
12 Art Gallery Management
13 Hotel Management System
14 School Management
15 Wholesale Management System
16 Salary Management System
17 ATM Management System
18 Bus Booking Portal
19 Hostel Room Allocation System
Faculty of Computer Applications Page 8
PCTE Group Of Institutes
20 GetMaid-Server Project
21 Online-food-delivery Project
22 Trip-Planner
23 Central Bank
24 Online-furniture-store
25 Olx-like-web-portal Project
26 University-Database-System
27 Employee-Management-System
28 Pharmacy-Management-System
29 Laboratory Management System-computer
30 Attendance and Leave Database Management System
31 Online Book Store
32 Laboratory Management System-Patho
33 Job Portal
34 Result Management
35 Alumni Management System
Faculty of Computer Applications Page 9
PCTE Group Of Institutes
36 Table Reservation System
37 Online Movie Booking
38 Wedding Planner
39 SCO allocation in malls
40 Laboratory Management-Chemistry
Faculty of Computer Applications Page 10
PCTE Group Of Institutes
COURSE PLAN
Subject: Database Management System Code: BSBC-404
Class: BCA Semester: 4th
No. of Lect.: 44 Credit: 4 Hrs/Week
Name of Instructor: Richa Arora(RA),Lata Pant (LTP)
Lect.
Topics Sub Topics Remarks
No.
Database
1 Overview of DBMS Database system
DBMS
Why database
2 Introduction to DBMS Types of DBMS
Advantages of DBMS
3 Characteristics of Data in Database [Link]
Physical
4 Data Independence Logical
Database administrator and his responsibilities
5 Three levels of architecture Mapping([Link]
Faculty of Computer Applications Page 11
PCTE Group Of Institutes
Data models- Components of E-R model
6 Entity Relationship model Symbols of E-R model
Attribute inheritance
Generalization
7 ER Model Specification
Aggregation
Hierarchical Model
8 ER Model
Network Model
9 Class Test-1
10 Comparison of Models [Link]
11 Project Allocation
What is a Relation?
12 Relational DBMS RDBMS terminology
Referential integrity
13 Integrity rules
14 Codd’s rules
Operands of relational algebra
15 Relational Algebra-I
Selection operator
Projection operator
16 Relational Algebra-I Union
Intersection
Relational Algebra-I Set-Difference
17-
…contd Cartesian product
18
Remaining operator
Join operator
19 Relational Algebra-II
Division operator
20- Relational Calculus Tuple
Faculty of Computer Applications Page 12
PCTE Group Of Institutes
21 Domain
Domain versus Tuple
Relational Calculus versus
22 Relational Database Design
Relational Algebra
23 Class Test-2
Anomalies in database
24 Functional Dependencies
Functional dependencies
Keys
25 Database Normalization Relationships
Need for normalization
26 First Normal Form
27 Second Normal Form
28 Third Normal Form
29 BCNF
30 Fourth Normal Form
Decomposition and other
31
dependencies
Decomposition and other
32
dependencies…contd
33 Concurrency and Recovery Basic concepts
34 Transaction Processing Transaction,Properties, Major Actions
35 Recovery Concurrent execution of transactions
36 Concurrency control
Physical Security and logical-
37-
Database security and Integrity Encryption,Backups([Link]
38
) [Link]
40 Distributed databases
Faculty of Computer Applications Page 13
PCTE Group Of Institutes
41 Structure of distributed database
42 Comprehensive Viva
43 Design of distributed databases
43-
44
Revision
Faculty of Computer Applications Page 14