brierwood country club
Our database was created to increase functionality of the Brierwood Country Club as a whole. The system will provide one place for all employee and member information to be stored and organized, which will eliminate the previous paper filing system.
New employee information is stored in the employees table, where every employee is assigned an employee ID number. Employees are assigned to their job specific tables; servers are assigned to dinner reservations, golf instructors to golf lessons in the lessons table, and swim instructors to swimming lessons in the lessons table. In addition, the lessons table assigns a Lesson ID, along with specific group (beginner, intermediate and advanced) to the lesson and what time and day of the week the lesson will occur. The lesson registrations table keeps a record of all member registrations for lessons, and gives them a specific lesson ID number. It also keeps track of whether the payment has been received or not.
Our forms will implement a simple way for employees to input new members, employees, lesson registrations and dinner reservations, among other things. Our reports are an easy way to keep track of employees, class rosters for lessons, payments received, reservations according to restaurant, suspended accounts (members not allowed into the facilities), and a weekly lesson schedule. These reports will help improve the company's overall satisfaction because it will make management's job easier by limiting paperwork and ensure that employees are being paid for all of their work.
New employee information is stored in the employees table, where every employee is assigned an employee ID number. Employees are assigned to their job specific tables; servers are assigned to dinner reservations, golf instructors to golf lessons in the lessons table, and swim instructors to swimming lessons in the lessons table. In addition, the lessons table assigns a Lesson ID, along with specific group (beginner, intermediate and advanced) to the lesson and what time and day of the week the lesson will occur. The lesson registrations table keeps a record of all member registrations for lessons, and gives them a specific lesson ID number. It also keeps track of whether the payment has been received or not.
Our forms will implement a simple way for employees to input new members, employees, lesson registrations and dinner reservations, among other things. Our reports are an easy way to keep track of employees, class rosters for lessons, payments received, reservations according to restaurant, suspended accounts (members not allowed into the facilities), and a weekly lesson schedule. These reports will help improve the company's overall satisfaction because it will make management's job easier by limiting paperwork and ensure that employees are being paid for all of their work.