Scribd
Upload
40 views4 pages

DBMS Proposal

This microproject aims to design an entity relationship (ER) diagram and database tables for a hotel management system. A group of students will work together to first analyze the hardware and software requirements, then design the ER diagram representing entities like hotels, customers, rooms, and employees. They will also design the database tables to model the relationships between entities. The group will test their work and submit a final project report on time.

Uploaded by

nonijop950
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
40 views4 pages

DBMS Proposal

This microproject aims to design an entity relationship (ER) diagram and database tables for a hotel management system. A group of students will work together to first analyze the hardware and software requirements, then design the ER diagram representing entities like hotels, customers, rooms, and employees. They will also design the database tables to model the relationships between entities. The group will test their work and submit a final project report on time.

Uploaded by

nonijop950
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

MICRO PROJECT PROPOSAL

(PART A)

Making an ER diagram and Database table For Hotel Management System

1.0 Brief Introduction:


ER-Model is a representation of the Database. In this project, we are designing the
database model for the hotel management system. The entities present are hotel,
customers, rooms, owner and employees. Each of them has some relation between
them represented in the ER-Diagram and the table structure to be made in actual
database is also described.

2.0 Aim of the Micro-Project:


This Micro-project aims at:
1. To make an ER diagram and database table.
2. To learn how to make various types of diagrams and tables in DBMS.
3. To develop skills of working in a group with unity.
3.0 Action Plan:

Sr.no Details of activity Planned Planned Name of


start date end date responsible group
members

1. Requirement and 01/09/20 04/09/20


analysis of hardware &
software All the group members

2. Identification of project 8/09/20 11/09/20


goal & project
deliverables

3. Making proposal for the 05/10/20 09/10/20 Darshan Zolge


project

4. Designing ER- Diagram 13/10/20 28/10/20 Yash Dabhade,


Swastik Patil

5. Designing Database 2/11/20 13/11/20 Yash Dabhade


Tables Swastik Patil

6. Testing and analysis of 18/11/20 20/11/20 All group member


test result

7. Preparation of final 20/11/20 1/12/20 Swapnil Chavan,


project report Yash Dabhade

8. Submission of the 15/01/21 17/01/21 All group members


Project
4.0 Resources Required:

Sr. Name of Specification


No. resources/Material

1. Computer system intel i5 8TH gen processor


8250U

2. RAM 8GB

3. Hard disk 1TB

4. Operating system Window 10 HOME 64-BIT

5. MySQL Workbench Version 8.0

Mrs. Aarati Patil


(Microproject Guide)

You might also like