90 likes | 186 Views
MGS 351 Group Project. Alexandra Emmi John Kaminski Kevin Mathias Nathan Moynihan Alex Raouf. Our Business. The United States National Tennis Center Fully-functioning tennis club year round Includes 20 indoor courts and 25 outdoor court Hosts U.S. Open tournament
E N D
MGS 351Group Project Alexandra Emmi John Kaminski Kevin Mathias Nathan Moynihan Alex Raouf
Our Business • The United States National Tennis Center • Fully-functioning tennis club year round • Includes 20 indoor courts and 25 outdoor court • Hosts U.S. Open tournament • Has been running for 44 years • Still uses paper database • Unorganized • Outdated
Database adds value • Increases reliability and efficiency • Eliminates scheduling issues • What employees per court • What employees per class • Marketing • Finds demographic • Target customers from a certain area
Who uses our database • Front desk employees use database in order to manage: • Employee data • Customer data • Class data • Registration data • Courts data
Tables • Classes • Courts • Customers • Employees • Registration • Switchboard
Forms • Class • Customer • Courts • Employees • Registration
Subform • Registration Subform
Reports • Class • Customer • Courts • Employees • Registration