HDLP

All of our employee information is stored in the Employees table. This contains their name, hours worked per week, the date the employee started working, their tips earned per week, and their total earned sales. Another table tracks all total sales of the restaurant per week, and links them to a specific employee. Lastly, our Products and Order Details table stores specific information about the products that we sell and their frequency sold in individual orders. We then translate that information in the tables to generate forms, queries and reports.

Primary location: Rochester United States