Database I: Team Project
Step 1: Form Project Team
Team ID- 14
Team Members
1. Chandra Vaddeman – 1001247485 – chandrashekarre.vaddeman@mavs.uta.edu
2. Priya Tilavi – 1001289436
Priya.tilavi@mavs.uta.edu
Step 2: Problem Definition
Topic – Hospitality Management System for Motels
Description of the topic – System is designed to capture the rooms available and the guests booking, In-house, arrival, Depart list and the required reports. System should capture Guest information and generate reports at the End of the day. System to be designed as follows
1. Application level
Maintain user accounts – (User accounts for the front office persons and manager)
Display In House, Arrival and Depart folios
Take Individual reservation
Search for past stay management
Ad-hoc Reports
2. Database Level
Master Table for floor plan
Table for maintaining rates
In house guest table
Arrival table
Stays table (includes history)
User accounts and passwords
Guest details
Step 3: Formulate 10 realistic Queries
1. Show total payments of the day through Cash, Card, Direct Bill, Cheque, etc. (Parameter from GUI= today’s date)
2. Show guest list report – Room number, Conference number, arrival date, departure date during date1 to date2 (Parameter from GUI= Date 1 and Date 2)
3. Show clerk activity report – includes, amount paid for each room during clerk shift report through various payment methods, for a given day (Parameter from GUI = a date)
4. Show Arrival/cancel/No show report of the day (Parameter from GUI= today’s date)
5. Show room availability based on type of room, for a given day (Parameter from GUI = a date)
6. Show customer details for the given last name and first name (Parameter from GUI= First name and last name)
7. Show Check outs of the day (Room number, guest name, conference number) (Parameter from GUI = today’s date)
8. Show Check ins of the day (Room number, guest name, conference number) (Parameter from GUI = today’s date)
9. Show...