MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION

TSSM'S
Bhivarabai Sawant College of Engineering and Research,

Polytechnic, Narhe, Pune-411041.

MICRO PROJECT
Academic year: 2023-24

TITLE OF PROJECT
“ER DIAGRAM ON HOSPITAL
MANAGEMENT”

Program : Computer Program code : CO

Course : Database Management System

Course code : 22319
 MAHARASHTRA STATE

BOARD OF TECHNICAL EDUCATION

Certificate

This is to certify that Mr. Tanay U. Gaikwad, Aryan N. Kumbhar, Aditya A.

Paygude, Pruthviraj A. Phad Roll No. 28, 48, 63, 65of 3rd Semester of Diploma in
computer engineering of Institute, BSCOER POLYTECHNIC (Code:1606) has
completed the Micro Project satisfactorily in Subject – Database Management System
(22319) for the academic year 2023-2024 as prescribed in the curriculum.

Place : Pune Enrollment No.: 2216060095

2216060117
Exam Seat No:
2216060062
2216060092

Subject Teacher Head of the Department Principal

 Jayawant Shikshan Prasarak Mandal (JSPM) PolytechnicThe
Shetkari Shikshan Mandal Sangli, Pune (TSSM)

COMPUTER ENGINEERING DEPARTMENT

VISION AND MISSION OF THE INSTITUTE

❖ VISION:
Achieve excellence in quality technical education by imparting knowledge, skills and abilities
to build a better technocrat.

❖ MISSION:
M1: Empower the students by inculcating various technical and soft skills.

M2: Upgrade teaching-learning process and industry-institute interaction

VISION AND MISSION OF THE COMPUTER DEPARTMENT

❖ VISION:

“Enhance skills by providing value based technical education for fulfilling global needs in
the field of computer engineering.”

❖ MISSION:

M1: To provide quality education in computer engineering by improving psychomotor

skills.

M2: To develop positive attitude, communication skills, team spirit and entrepreneurship.

M3: To develop awareness about societal and ethical responsibility for professionalism.
All India Shri Shivaji Memorial Society’s Polytechnic
COMPUTER ENGINEERING DEPARTMENT

PROGRAM OUTCOMES (POs)

PO1 Basic and Discipline specific knowledge: Apply knowledge of basic mathematics, science
and engineering fundamentals and engineering specialization to solve the engineering
problems.

PO2 Problem analysis: Identify and analyze well-defined engineering problems using codified
standard methods.

PO3 Design/ development of solutions: Design solutions for well-defined technical problems
and assist with the design of systems components or processes to meet specified needs.

PO4 Engineering Tools, Experimentation and Testing: Apply modern engineering tools and
appropriate technique to conduct standard tests and measurements.

PO5 Engineering practices for society, sustainability and environment: Apply appropriate
technology in context of society, sustainability, environment and ethical practices.

PO6 Project Management: Use engineering management principles individually, as a team

member or a leader to manage projects and effectively communicate about well-defined
engineering activities.

PO7 Life-long learning: Ability to analyze individual needs and engage in updating in the
context of technological changes.

PROGRAM SPECIFIC OUTCOMES (PSO)

The Diploma in Computer Engineering will prepare students to attain:

PSO 1: Apply computing knowledge with standard practices to develop software.

PSO 2: Maintain Computer Hardware and Software System
 CERTIFICATE

Certified that this micro project report titled ‘Create a Database for Gym
Management System’ is the bona fide work of Roll no. 34 , 25 , 42 , 43 of second year
diploma in Computer Engineering for the course: Database Management System
Course code: 22319 during the academic year 2023-2024, who carried out the micro
project work under my supervision.

Prof. Budhner .N .K

Name & signature subject teacher

 COs addressed by the Micro Project:

C22319.1: Design Normalized database on given data.

C22319.2: Create and Manage Database using SQL command.

Major Learning Outcomes achieved by students by doing the micro project:(a)Practical

Outcomes:
• Design E-R diagram and Create Normalized Database on given.
• Create and Execute DDL commands using SQL.
• Apply Integrity constraints on table.
• Create and Execute DML commands using SQL.

❖ Unit Outcomes in Cognitive domain

• Draw the E-R diagram of the given Relational.
• Design Normalized database structure in the given problem.
• Identify the operators for queries implementation of the given problem.

❖ Outcomes in Affective Domain

1. Can reduce duplicate entries.
2. This will help us in maintain the exact count of any product.
3. Demonstrate working as a leader/a team member.
4. Maintain tools and equipment.
5. Follow ethical practices.
 ACKNOWLEDGEMENT

• We are deeply indebted to our project guide Mr. Prof. Budhner .N .K

for guiding us in a proper way in order to complete our micro project.
We wouldlike to express our gratitude towards our guide for her
valuable guidance, suggestion, and continues support throughout in
preparing the short-term training report.
• We also express our thanks to our seniors for their great
support and suggestions.

.
 GROUP DETAILS

Sr.No Name of group members Roll Enrollment Seat No.

No. No.
1. Tanay U. Gaikwad 28 2216060095
2. Aryan N. Kumbhar 48 2216060117
3. Aditya A. Paygude 63 2216060062
4. Pruthviraj A. Phad 65 2216060092
Sr. Index
no.
1. Introduction

2. ER Diagrams in DBMS
3. Symbols used in ER Diagram
4. ER Diagram on Hospital Management
• Introduction
An Entity Relationship Diagram (ER Diagram) pictorially explains the
relationship between entities to be stored in a database. Fundamentally, the
ER Diagram is a structural design of the database. It acts as a framework
created with specialized symbols for the purpose of defining the relationship
between the database entities. ER diagram is created based on three
principal components: entities, attributes, and relationships.

The following diagram showcases two entities - Student and Course, and
their relationship. The relationship described between student and course is
many-to-many, as a course can be opted by several students, and a student
can opt for more than one course. Student entity possesses attributes -
Stu_Id, Stu_Name & Stu_Age. The course entity has attributes such as
Cou_ID & Cou_Name.
• ER Diagrams in DBMS.

1) ER Diagram helps you conceptualize the database and lets you know
which fields need to be embedded for a particular entity

2) ER Diagram gives a better understanding of the information to be

stored in a database

3) It reduces complexity and allows database designers to build

databases quickly

4) It helps to describe elements using Entity-Relationship models

5) It allows users to get a preview of the logical structure of the database

• Symbols Used in ER Diagrams

1) Rectangles: This Entity Relationship Diagram symbol represents entity

type.

2) Ellipses: This symbol represents attributes

3) Diamonds: This symbol represents relationship types

4) Lines: It links attributes to entity types and entity types with other
relationship types

5) Primary key: Here, it underlines the attributes

6) Double Ellipses: Represents multi-valued attributes

 ER DIAGRAM ON HOSPITAL
MANAGEMENT
 ANNEXURE III
Rubric for Assessment of a Micro Project

Sr. Characteristic Indicators for different Levels of Performance (Evaluation Scale: 1-10)
No to be assessed Poor (1-3) Average (4-5) Good (6-8) Excellent (9-10)
1 Relevance to Related to vary Related to some Addressed at-least Addressed more than
the course few LOs Los one CO one CO

2 Literature Not more than At least five At least 7 relevant About 10 relevant
review/ two sources( relevant sources, sources, most sources, most latest
information Primary and at least 2 latest latest
collected secondary), very
old references
3 Completion of Completed less Completed Completed Completed more than
target as per than 50% 50 to 60% 60 to 80 % 80 %
project
proposal
4 Analysis of Sample size Sufficient and Sufficient and Enough data collectedby
data and small, data neither appropriate appropriate sufficient and
representatio organized nor sample, enough sample, enough appropriate sample
n presented well data generated but data generated size. Proper interference
not organized and which is drawn byorganizing and
not presented organized and presenting data through
well. No or poor presented well but tables, charts
interference poor interference and graphs.
drawn. drawn.
5 Quality of Incomplete Just assembled/ Well assembled / Well assembled/
prototype/Mo fabrication/ fabricated and fabricated with fabricated with proper
del assembly parts are not proper functioning parts. In
functioning well. functioning parts. proper shape, with
Not in proper In proper shape, intolerance dimensions
shape, dimensions with in tolerance and good appearance/
beyond tolerance dimensions and finish. Creativity in
limit. good finish. But design and use of
Appearance/ no creativity in material.
finish shabby. design and use of
material.
6 Report Very short, poor Nearly sufficient Detailed, correct Very Detailed, correct
Preparation quality sketches, and correct details and clear and clear description of
details about about methods, description of methods, materials,
methods, material, methods, precautions and
material, precautions and materials, conclusions. Enough
precaution and conclusion, but precautions and tables, charts and
conclusions clarity is not there conclusions. sketches.
omitted, some in presentation. Sufficient
details wrong But not enough graphical
graphic description.
description.
7 Presentation Major Includes major Includes major Well organized ,
of the micro information is not information but information well includes major
project included, not well organized but not information, well
information is not organized and not presented well. presented
well organized. presented well.
19
ANNEXURE IV

Micro Project Evaluation Sheet

Name of Student: Tanay Gaikwad Enrollment No: 2216060095

Name of Program: Computer Engineering Semester: 3I

Course Name: Database Management System Code: 22318

Title of the Micro-project: ER diagram on Hospital Management

Course Outcomes Achieved:-

a. Design Normalized database on given data.

b. Create & Manage Database using SQL command.

Sr. Characteristic to be Poor Average Good Excellent Sub

No. accessed (Marks 1- (Marks 4- (Marks 6- (Marks 9- Total
3) 5) 8) 10)

1. Process and Product Assessment (Convert above total marks out of 6 Marks)
1 Relevance to the
course
2 Literature
Review/information
collection
3 Completion of the
Target as per project
proposal
4 Analysis of Data and
representation
5 Quality of the
Prototype/Model
6 Report Preparation
2. Individual Presentation/ Viva (Convert above total marks out of 4 Marks)
7 Presentation
8 Viva

(A) (B) Total Marks

Process and Product Assessment Individual Presentation/ 10
(6 Marks) Viva
(4 Marks)

Comments/ suggestions about Team work/ Leadership/Inter-Personal communication (If

any)…………………………………………………………………………………………

Name and Designation of the Teacher – Prof. Budhner .N .K

Dated Signature…………………………………

21
ANNEXURE IV

Micro Project Evaluation Sheet

Name of Student: Aryan Kumbhar Enrollment No: 2216060117

Name of Program: Computer Engineering Semester: 3I

Course Name: Database Management System Code: 22318

Title of the Micro-project: ER diagram on Hospital Management

Course Outcomes Achieved:-

a. Design Normalized database on given data.
b. Create & Manage Database using SQL command.

Sr. Characteristic to be Poor Average Good Excellent Sub

No. accessed (Marks 1- (Marks 4- (Marks 6- (Marks 9- Total
3) 5) 8) 10)

1. Process and Product Assessment (Convert above total marks out of 6 Marks)
1 Relevance to the
course
2 Literature
Review/information
collection
3 Completion of the
Target as per project
proposal
4 Analysis of Data and
representation
5 Quality of the
Prototype/Model
6 Report Preparation
2. Individual Presentation/ Viva (Convert above total marks out of 4 Marks)
7 Presentation
8 Viva

(A) (B) Total Marks

Process and Product Assessment Individual Presentation/ 10
(6 Marks) Viva
(4 Marks)

Comments/ suggestions about Team work/ Leadership/Inter-Personal communication (If

any)…………………………………………………………………………………………

Name and Designation of the Teacher – Prof. Budhner .N .K

Dated Signature…………………………………

22
ANNEXURE IV

Micro Project Evaluation Sheet

Name of Student: Aditya Paygude Enrollment No: 2216060062

Name of Program: Computer Engineering Semester: 3I

Course Name: Database Management System Code: 22318

Title of the Micro-project: ER diagram on Hospital Management

Course Outcomes Achieved:-

a. Design Normalized database on given data.
b. Create & Manage Database using SQL command.

Sr. Characteristic to be Poor Average Good Excellent Sub

No. accessed (Marks 1- (Marks 4- (Marks 6- (Marks 9- Total
3) 5) 8) 10)

1. Process and Product Assessment (Convert above total marks out of 6 Marks)
1 Relevance to the
course
2 Literature
Review/information
collection
3 Completion of the
Target as per project
proposal
4 Analysis of Data and
representation
5 Quality of the
Prototype/Model
6 Report Preparation
2. Individual Presentation/ Viva (Convert above total marks out of 4 Marks)
7 Presentation
8 Viva

(A) (B) Total Marks

Process and Product Assessment Individual Presentation/ 10
(6 Marks) Viva
(4 Marks)

Comments/ suggestions about Team work/ Leadership/Inter-Personal communication (If

any)…………………………………………………………………………………………

Name and Designation of the Teacher – Prof. Budhner .N .K

Dated Signature…………………………………

23
ANNEXURE IV

Micro Project Evaluation Sheet

Name of Student: Pruthviraj Phad Enrollment No: 221606092

Name of Program: Computer Engineering Semester: 3I

Course Name: Database Management System Code: 22318

Title of the Micro-project: ER diagram on Hospital Management

Course Outcomes Achieved:-

c. Design Normalized database on given data.
d. Create & Manage Database using SQL command.

Sr. Characteristic to be Poor Average Good Excellent Sub

No. accessed (Marks 1- (Marks 4- (Marks 6- (Marks 9- Total
3) 5) 8) 10)

1. Process and Product Assessment (Convert above total marks out of 6 Marks)
1 Relevance to the
course
2 Literature
Review/information
collection
3 Completion of the
Target as per project
proposal
4 Analysis of Data and
representation
5 Quality of the
Prototype/Model
6 Report Preparation
2. Individual Presentation/ Viva (Convert above total marks out of 4 Marks)
7 Presentation
8 Viva

(A) (B) Total Marks

Process and Product Assessment Individual Presentation/ 10
(6 Marks) Viva
(4 Marks)

Comments/ suggestions about Team work/ Leadership/Inter-Personal communication (If

any)…………………………………………………………………………………………

Name and Designation of the Teacher – Prof. Budhner .N .K

Dated Signature…………………………………

24
 Evaluation Sheet for the Micro Project

Academic Year: 2023-2024 Name of Faculty: Prof. Budhner .N .K

Course: Data Base Management System (DMS)

Course Code: 22319 Semester: 3-I-Scheme

Title of the Project: Create a Database for Gym Management System

.
Comments/Suggestions about team work/leadership/inter-personal communication (if any).:

Roll Student Name Marks out of 6 Marks out of 4 Total

No for performance in for performance in oral / out of
group activity (D5 presentation (D5 :Col. 10
:Col. 8) 9)

34
Tanay Gaikwad

25
Aryan Kumbhar

42
Aditya Paygude

43
Pruthviraj phad

Prof. Budhner .N .K (Name

& Signature of faculty)

25
 Log Book of the Student (Weekly Work Report)Academic Year: 2023-24

Name of Student: Tanay Gaikwad, Aryan Kumbhar , Aditya Paygude, Pruthviraj phad

Title of the Project: ER diagram on Hospital Management

Course: Database Management System Course Code: 22318 Semester: 3I

Sr. No./ Date Time Work Done

Hour No.

1. 26/08/2023 1 hr. Group discussion on topic

2. 26/08/2023 1 hr. Assign task to group

3. 02/09/2023 1 hr. Giving particular information

4. 02/09/2023 1 hr. Get some Course Outcomes and Practical

Outcomes
5. 09/09/2023 1 hr. Taking review about collected data

6. 16/09/2023 1 hr. Verify material in sequence

7. 23/09/2023 1 hr. Discussion on suggestions

8. 30/09/2023 1 hr. Arrange data in sequence

9. 07/10/2023 1 hr. Prepare Proposal of the Project

10. 14/10/2023 1 hr. Verify the draft from teacher

11. 21/10/2023 1 hr. Rearrange the Data

12. 04/11/2023 1 hr. Share the data among group

13. 11/11/2023 1 hr. Prepare the report

14. 25/11/2023 1 hr. Work on data

15. 02/12/2023 1 hr. Prepare soft copy

16. 09/12/2023 - Submission

Prof. Budhner .N .K
(Name & Signature of faculty)