21CSC205P Database Management

Systems

Project Report

Register No. :

Name of the Student :

Semester :

Programme : B.Tech.

Academic Year : 2023-2024

SRM INSTITUTE OF SCIENCE AND TECHNOLOGY

TIRUCHIRAPPALLI
TIRUCHIRAPPALLI COLLEGE OF ENGINEERING AND TECHNOLOGY
 SRM INSTITUTE OF SCIENCE AND TECHNOLOGY
TIRUCHIRAPPALLI
TIRUCHIRAPPALLI COLLEGE OF ENGINEERING AND TECHNOLOGY

REGISTER NO.

BONAFIDE CERTIFICATE

Certified as the bonafide record of work done by

, Register No.

of (Semester/Year),

B.Tech. Programme in the

project-based course 21CSC205P, Database Management Systems at SRM Institute

of Science and Technology, Tiruchirappalli Campus during the Academic Year

2023-2024.

Faculty In-charge Head of the Department

Submitted for the End Semester Examination held on

Examiner-1 Examiner-2
 SRM Institute of Science and Technology
Faculty of Engineering and Technology
School of Computing
Department of Computational Intelligence
VISION AND MISSION OF THE DEPARTMENT
Vision
To become a world-class department in imparting high-quality knowledge and providing students
with a unique learning and research experience in Computer Science and Engineering.

Mission

1. To impart knowledge in cutting edge technologies in part with industrial standards.

2. To collaborate with renowned academic institutions in research and development.
3. To instill societal and ethical responsibilities in all professional activities.

Program Educational Objectives (PEO)

PEO - 1 Graduates will be able to perform in technical/managerial roles ranging from design,
development, problem solving to production support in software industries and R&D sectors

PEO - 2 Graduates will be able to successfully pursue higher education in reputed institutions.

PEO - 3 Graduates will have the ability to adapt, contribute and innovate new technologies and
systems in the key domains of Computer Science and Engineering.
PEO - 4 Graduates will be ethically and socially responsible solution providers and
entrepreneurs in Computer Science and other engineering disciplines.

PEO - 5 Graduates will possess the additional skills in core computer science discipline with
knowledge of Hardware, Software, Programming, Logic & Reasoning.

Mission of the Department to Program Educational Objectives (PEO) Mapping

H – High correlation, M – Medium Correlation, L – Low Correlation

Program Outcomes as defined by NBA (PO)

Engineering Graduates will be able to:
1. Engineering knowledge: Apply the knowledge of mathematics, science, engineering
fundamentals, and an engineering specialization to the solution of complex engineering
problems.
2. Problem analysis: Identify, formulate, review research literature, and analyze complex
engineering problems reaching substantiated conclusions using first principles of mathematics,
natural sciences, and engineering sciences.
3. Design/development of solutions: Design solutions for complex engineering problems and
design system components or processes that meet the specified needs with appropriate
consideration for the public health and safety, and the cultural, societal, and environmental
considerations.
4. Conduct investigations of complex problems: Use research-based knowledge and research
methods including design of experiments, analysis and interpretation of data, and synthesis of
the information to provide valid conclusions.
5. Modern tool usage: Create, select, and apply appropriate techniques, resources, and modern
engineering and IT tools including prediction and modeling to complex engineering activities
with an understanding of the limitations.
6. The engineer and society: Apply reasoning informed by the contextual knowledge to assess
societal, health, safety, legal and cultural issues and the consequent responsibilities relevant to
the professional engineering practice.
7. Environment and sustainability: Understand the impact of the professional engineering
solutions in societal and environmental contexts, and demonstrate the knowledge of, and need
for sustainable development.
8. Ethics: Apply ethical principles and commit to professional ethics and responsibilities and
norms of the engineering practice.
9. Individual and team work: Function effectively as an individual, and as a member or leader
in diverse teams, and in multidisciplinary settings.
10. Communication: Communicate effectively on complex engineering activities with the
engineering community and with society at large, such as, being able to comprehend and write
effective reports and design documentation, make effective presentations, and give and receive
clear instructions.
11. Project management and finance: Demonstrate knowledge and understanding of the
engineering and management principles and apply these to one’s own work, as a member and
leader in a team, to manage projects and in multidisciplinary environments.
12. Life-long learning: Recognize the need for, and have the preparation and ability to engage
in independent and life-long learning in the broadest context of technological change.

PSO – Program Specific Outcomes (PSO)

Mapping Program Educational Objectives (PEO) to Program Learning Outcomes (PLO)

H – High correlation, M – Medium Correlation, L – Low Correlation

COURSE DESIGN

Course Learning At the end of this course, learners will be able to:
Outcomes (CLO):
CO – 1 Acquire knowledge on DBMS architecture and languages
CO – 2 Acquire knowledge on Relational languages and design a database
CO – 3 Implement the Database structure with SQL
CO – 4 Removal of anomalies using Normalization concepts
CO – 5 Visualizing storage structure, handling concurrency, Failure and
recovery principles, NoSQL concept

CLO-PO Mapping

CLO Program Outcomes (PO)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Engineering Knowledge

Design & Development

Project Mgt. & Finance

Modern Tool Usage

Life Long Learning

Individual & Team
Society & Culture
Problem Analysis

Analysis, Design,

Communication
Environment &
Sustainability
Research

PSO – 3
PSO - 1

PSO - 2
Ethics

Work

CO1 - 2 - - - - - - - - - - 2 1 -
CO2 1 2 - - - - - - - - - - 2 1 -
CO3 1 - 2 - - - - - - - - - 2 1 -
CO4 1 - - - - - - - - - - - 2 1 -
CO5 1 2 - - - - - - - - - - 2 1 -
 Report Evaluation:

Test
Date Artifacts Total
Components Mark Split-up
Marks

Marks to be evaluated based on

1 (a) 23.01.2024 Project Title selection, presentation
Abstract Project title – 2 Marks
04
Presentation – 2 Marks

Problem understanding, Marks to be evaluated based on

Identification of Entity and presentation and demo
1 (b)
07-02-2024
Relationships, Problem Identification – 1 Marks
Construction of DB using Presentation – 2 Marks
ER Model for their project 06 Demo - 2 Marks
Viva - 1 Marks

Marks to be evaluated based on demo

Design of Relational
and viva voce
Schemas, Creation of
2 28-02-2024 Demo - 4 Marks
Database and their Tables
10 Viva voce – 3 Marks
for their project
Report - 3 Marks

Marks to be evaluated based on demo

Writing the complex queries
and viva voce
based on the concepts of
27-03-2024 Demo - 4 Marks
3 constraints, sets, joins,
10 Viva - 3 Marks
views, Triggers and Cursors
Report -3 Marks
 Marks to be evaluated based on demo
Analyzing the pitfalls, and viva voce
27-03-2024 identifying the dependencies Demo - 4 Marks
4 and applying normalizations 10 Viva - 3 Marks
Report - 3 Marks

Marks to be evaluated based on demo

Implementation of and viva voce
27-03-2024 concurrency control and Demo - 4 Marks
5
recovery mechanisms. 10 Viva - 3 Marks
Report - 3 Marks
Marks to be evaluated based on
presentation and demo
Module Description and Final Presentation - 2
6 15-04-2024
Functionalities 10 Demo - 2 Marks
Viva - 3 Marks
Report - 3 Marks
Marks to be evaluated based on
Database Connectivity and presentation and demo
Final Presentation - 2
7 15-04-2024 Embedded SQL 10
Demo - 2 Marks
operations Viva - 3 Marks
Report - 3 Marks
Marks to be evaluated based on
presentation and demo
PL/SQL procedures to
Final Presentation - 2
8 29-04-2024 Operate on the database 10
Demo - 2 Marks
of your project Viva - 3 Marks
Report - 3 Marks
Marks to be evaluated based on
presentation and demo
Final Presentation - 2
9 29-04-2024 Front End Design 10
Demo - 2 Marks
Viva - 3 Marks
Report - 3 Marks
Marks to be evaluated based on
presentation and demo
Report Generation using
Final Presentation - 2
10 07-05-2024 Crystal Reports/Report 10
Demo - 2 Marks
Generation Tool Viva - 3 Marks
Report - 3 Marks
LABORATORY EXPERIMENTS MAPPED WITH CLO, PO, PSO

Sl. CLO PO / PSO

Title of the Experiments
No. Mapping Mapping
1 (a) Project Title selection, Abstract 1 2
(b) Problem understanding, Identification of Entity
and Relationships, Construction of DB using ER
Model for your project
2 Design of Relational Schemas, Creation of Database 1,2 1,2
and Tables for your project
3 SQL Queries based on the concepts of constraints, 3 1,3
sets, joins
4 Applying Normalization for your project 4 1

5 Concurrency control and Recovery mechanisms for 5 1,2

your project
6 Module Description and Functionalities 1,2 1,2

7 Database Connectivity and Embedded SQLoperations 1,2 1,2

8 PL/SQL procedures to Operate on the database of 2,3 1,2,3

your project
9 Front End Design, Sample Code for each module, 5 1,2
Screen Shots for each module
10 Report Generation using Crystal Reports/Report 5 1,2
Generation Tool
 INDEX
Expt. Date of Name of the Experiment Page Marks Signature
No. Experiment No. (50) of Faculty

1 07-02-2024 (a) Project Title selection, Abstract

(b) Problem understanding, Identification

of Entity and Relationships, Construction
of DB using ER Model for your project
2 28-02-2024 Design of Relational Schemas, Creation
of Database and Tables for your project

3 27-03-2024 SQL Queries based on the concepts of

constraints, sets, joins
4 27-03-2024 Applying Normalization for your project
5 27-03-2024 Concurrency control and Recovery
mechanisms for your project
6 15-04-2024 Module Description and Functionalities
7 15-04-2024 Database Connectivity and Embedded
SQL operations
8 29-04-2024 PL/SQL procedures to Operate on the
database of your project
9 29-04-2024 Front End Design, Sample Code foreach
module, Screen Shots for each module
10 07-05-2024 Report Generation using Crystal
Reports/Report Generation Tool
11 07-05-2024 Online Course Completion Certificate