Management Information System
Assignment 2Presented by:GHULAM HASSAN L1F10BBAM0277Management Information System2066306323008800Case study:Conference centre booking systemA conference centre takes bookings from clients who wish to hold courses or conferences at the centre. When clients make bookings they specify how many people are included in the booking, and of these, how many will be resident during the booking, and how many will require catered or non-catered accommodation at the centre.The centre contains a number of facilities which may be required by clients making bookings as follows:There are 400 bedrooms for clients who will be resident during the Course or conference.A maximum of 250 catered people can be handled at any one time.Six main lecture theatres providing seating for 200 people.Twenty seminar rooms each able to accommodate 25 people.Video conference facilities. The video conference facilities consist of four separate video conference networks. Each video conference network has a large screen based in one of the main lecture theatres, along with 3 satellite screens each of which is based in one of the seminar rooms. “Draw an entity relationship diagram for the case, stating any assumptions you deem necessary”.Method of solution:Identify the entitiesDetermine the attributes for each entitySelect the primary key for each entityEstablish the relationships between the entitiesDraw an entity modelBookingClientsEntities & their Attributes:Booking noBooking DateRegistered / new customerSeminar roomsbed roomsVideo conference facilitiesAdvanced depositsClients IDRegistered / New ClientsDepositsBookingBed RoomsSeminar Rooms Booking noBooking DateRegistered / new customerSeminar roomsbed roomsVideo conference facilitiesAdvanced depositsClients IDRegistered / New ClientsDepositsBookingBooking noBooking DateRegistered / new customerSeminar roomsbed roomsVideo conference facilitiesAdvanced depositsClients IDRegistered / New ClientsDepositsBookingSeminar room NoBookingClientsDepositsBedroom NoBookingClientsDepositsVideo ConferenceRegistered CustomersID NoBookingClientsDepositsCustomers IDBookingAddressesDepositsBooking ClerkClerk IDClientsBookingDepositLetter /E-mailRegistrationDeposit NoCash / ChequesClientsDateLetter / E-mailID noClient noBooking date*Primary keys are highlighted:Relationship between Entities ClientsSeminar RoomsBookingBed RoomsDepositsRegistered CustomersVideo ConferenceLetter / E-mailFrom these entities, we can remove extra entities like registered customer and client are same, booking, conference, video rooms & booking are same etc…After removing extra entities we can draw an entity model.Entities Relationship Model Booking Client Letter / E-mailDepositsData Flow Diagram (DFD)Case study:Conference centre booking systemWhen a customer wants to book seminar rooms and bedrooms of conference center he/she will fill an application to book the conference center or seminar room. There are 20 seminar rooms and 400 bedrooms in total and a customer may book any number of available rooms. Once the booking clerk gets booking application, he checks whether it is a registered or new customer. If it is a new customer, the customer is registered with the conference center. After registering the customer, the booking clerk checks the availability of seminar room(s) on desired dates. If the numbers of seminar rooms required by the customer are not available on desired date, customer is notified and asked that if he/she would like to book on a different date or reduce numbers of seminar room for booking. If required numbers of seminar rooms are available, the customer is asked to deposit an advance of 50% of the total booking charges. Once customer deposits the booking advance amount and booking clerk confirms the payment amount with the accounts office and notifies the customer through a letter and email that the booking has been finalized.Steps of Developing DFDExternal entitiesData flowsProcessData stores ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.