MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION
PILLAI HOC College of Engineering And Technology
DIPLOMA SECTION(1148)
Rasayani
MICRO PROJECT
Academic year: 2021-2022
TITLE OF PROJECT
Library Management System ER Diagram
in Oracle SQL Live
Program: Diploma In Computer Engg. Program
Program code: CO3I
Course: Database Management System
Course code: 22319
MAHARASHTRA STATE
BOARD OF TECHNICAL EDUCATION
Certificate
This is to certify that Mr. Sairaj Baburao Gandharkar
Roll No. 9 of 3rd Semester of Diploma in Computer Engineering of Institute PILLAI HOC
College of Engineering And Technology, Diploma Section (Code: 1148) has completed
the Micro Project satisfactorily in Subject– Database Management System for the
academic year 2021- 2022 as prescribed in the curriculum.
Place:Rasayani Enrollment No: 2011480095
Date: 3-01-2022 Exam. Seat No: 116786
Subject Teacher Head of the Department Principal
MAHARASHTRA STATE
BOARD OF TECHNICAL EDUCATION
Certificate
This is to certify that Ms. Anushka Neeshikant Kamble
Roll No. 10 of 3rd Semester of Diploma in Computer Engineering of Institute PILLAI
HOC College of Engineering And Technology, Diploma Section (Code: 1148) has
completed the Micro Project satisfactorily in Subject– Database Management System
for the academic year 2021- 2022 as prescribed in the curriculum.
Place:Rasayani Enrollment No: 2011480096
Date: 3-01-2022 Exam. Seat No: 116787
Subject Teacher Head of the Department Principal
MAHARASHTRA STATE
BOARD OF TECHNICAL EDUCATION
Certificate
This is to certify that Mr. Praneet Prakash Pawar
Roll No. 11 of 3rd Semester of Diploma in Computer Engineering of Institute PILLAI
HOC College of Engineering And Technology, Diploma Section (Code: 1148) has
completed the Micro Project satisfactorily in Subject– Database Management System
for the academic year 2021- 2022 as prescribed in the curriculum.
Place:Rasayani Enrollment No: 2011480097
Date: 3-01-2022 Exam. Seat No: 116788
Subject Teacher Head of the Department Principal
Group Details:
Sr.No Name of group Roll No Enrollment No Seat No
members
1. Sairaj Baburao 09 2011480095 116786
Gandharkar
2. Anushka Neeshikant 10 2011480096 116787
Kamble
3. Praneet Prakash 11 2011480097 116788
Pawar
Name of Guide: Sumit Dalvi
ANNEXURE II
Evaluation Sheet for the Micro Project
Academic Year: 2021-22 Name of the Faculty: Sumit Dalvi
Course: Database Management System Course code: 22319 Semester: III
Title of the project: Library Management System ER Diagram in Live SQL
Cos addressed by Micro Project:
A: Design Normalised database on given data.
B: Create and Manage Database Using SQL Command.
C: Write PL/SQL code for given database
D: Apply security and confidentiality on given Database.
Major learning outcomes achieved by students by doing the project
(a) Practical outcome:
Draw the ER Diagram On the Given Database and identify relationship between the
entities.
(b) Unit outcomes in Cognitive domain:
A: Demonstrate working as a leader/a team member B: Maintain tools and equipment C:
follow ethical practices
(c) Outcomes in Affective domain:
Understanding The Entity Relationship and database.
Comments/suggestions about team work /leadership/inter-personal communication (if any)
Through this group project team work , time management, responsibility , responding, opinions,
and value are important .
Marks out of 6 Marks out of 4for
for performance performance in
in group activity oral/ presentation Total
out of 10
Roll No Student Name (D5 Col.8) (D5 Col.9)
09 Sairaj Baburao Gandharkar
10 Anushka Neeshikant
Kamble
11 Praneet Prakash Pawar
(Signature of Faculty)
*Library Management System*
i) Er Diagram:
ii) Entities:
1. Reader
2. Staff
3. Books
4. Publisher
5. Supplier
6. Library Authentication/Reservation Data System.
________
*Implementation In Oracle Live SQL*
1. Reader:
Reader View:
Reader(User Data View):
2. Staff:
Staff View:
Staff Details View:
3. Books:
Books View:
Books_Details View:
4. Publisher:
Publisher View:
5. Supplier:
Supplier View:
6. i)Library Authentication System:
Auth_Sys View:
6. ii) Library Reservation Data:
Reserv_Sys View:
_______
