ER DIAGRAM FOR HOSTEL MANAGEMENT SYSTEM PDF DOWNLOAD

17 Jul Download Entity Relationship Diagarm ER Diagram of Hostel Management System. 1 Nov Data Design 42 Introduction 42 Data Modelling 42 ER Diagram 42 Data PROBLEM STATEMENT The Hostel Management System is. You should probably have a table “StaffHostel” which has StaffID/HostelID FKs. It should also have another field called “IsManager”, which can.

Author: Dujinn Dir
Country: Lebanon
Language: English (Spanish)
Genre: Health and Food
Published (Last): 28 January 2013
Pages: 99
PDF File Size: 1.98 Mb
ePub File Size: 14.71 Mb
ISBN: 988-4-59659-995-2
Downloads: 15037
Price: Free* [*Free Regsitration Required]
Uploader: Grogis

That will complicate your design significantly.

mysql – Online Hostel Management System ER Diagram – Database Administrators Stack Exchange

This manatement is design to implement the our project named as hostel management database system. It can be considered as marketing strategy so more students will come in this hostel because every hostel do not give this facility. Amin Khan May 10, at 8: This entity is added as the extra entity so that our project can be look complete from every aspect. It is amazing and wonderful to visit er diagram for hostel management system site.

When students will live in hostel there will be fees charges on the monthly basis. For the food service the hostel management er diagram for hostel management system providing the facility of mess for students so students and easily get the meal in hostel.

It contains all of We are also creating some type scenario so that our design can be bit specific for some kind of situation.

Sitara Sysetm May 8, at 6: Otherwise looks pretty good, the only thing I can imagine you might want to do differently is to hand off the payment to another provider, storing Credit Card information is a very dangerous thing to do, leave it to the big boys who implement stringent security practices.

New E-R Diagram for Hostel management ( Entity Relationship Diagram) | Creately

CNIC is considered as primary key. The admin will enter the data of students this entityon the basis of different attributes like age, department the administrator maagement assign the room so that the students of same age fellow and alike department hoste share the room.

Please advise me if this diagram makes sense or needs improvement. Sign up using Facebook. Room will be allotted to different students, so the students can be accessed by the attributes of room as well. Don’t got your Catalog table,other wise looks er diagram for hostel management system. People design them according to their thinking.

But in ER diagram we can see there is direct relation of admin and room so admin can retrieve the condition and data of room directly as well. There will be few er diagram for hostel management system because it is the weak entity and just made to.

The basic purpose of designing this project is to get rid from manual entry and record system and try to give easy and simple database management system for hostels. As we can see that our university has the facility of hostel for boys and girls.

The data will move from here to different side like er diagram for hostel management system branches of tree. Sign up or log in Sign up using Google. It used structure data and to Er diagram for hostel management system Fahad May 8, at 9: There will be mess managmeentwho will handle the mess, there will be monthly expenses of each student, students name to know which have got their meal or not. Students come in the hostel to get the room. The details of Hostel is store into the Hostel tables respective with all tables Each entity Payments, Rooms, Allotees, Beds, Hostel contains primary key and unique keys.

It used structure data and to define the relationships between structured data groups of Hostel Management System functionalities. Changes can be possible later on!

Hostel Management System Dataflow Diagram

This is just showing that any institute can have many hostel but we will take the only one of them er diagram for hostel management system will manage the data for them. M Fahad May 7, at By clicking foe Your Answer”, you acknowledge that you have read our updated terms of hostflprivacy policy and cookie policyand that your continued use of the website is subject to these policies. Table would look like:.

Train Enquiry System Dataflow Diagram Train Enquiry System Data flow diagram is often used as a preliminary step to create an overview of the Train Enquiry without going into great detail, which can later be elaborated.

New E-R Diagram for Hostel management ( Entity Relationship Diagram)

Table would look like: If this is for a Hostel, note that people often don’t book Rooms, but book beds! Google “credit card payment gateway”. Faculty Management System Dataflow Diagram Faculty Management System Data flow diagram is often used as a preliminary step to create an overview of the Faculty Management without going tor great detail, which can later be elaborated.

The data will follow the route, admin to student and then fees. Library Information System Dataflow Diagram Library Information System Data flow diagram is often used as a preliminary step to create an overview of the Er diagram for hostel management system without going into great detail, which can er diagram for hostel management system be elaborated.

The entity-relationship diagram of Leave Management System shows all the visual instrument of database tables and the relations between Branch, Leave, Company, Employee etc.

Only administrator will get in the system and manage the database and check the status of students and will allocate the room to new students. The reason for choosing this entity is that ,student is the main entity in the hostel and we will keep the database of students and logically related things with the students.

It will also do the check and balance of mess. Division of labour and Main feature of project has diatram been mentioned in the project.

Each attribute have the suitable data-type and size according to the requirement.