Human Resource Databases
Database Scenario:
The Environmental Expert is a locally owned business that provides training to small businesses regarding environmental regulations that may affect them It has a staff of 8 people. Up until this point, it has been using paper-based records to keep track of customers who come in to sell used music; realizing this system is very outdated and problematic, the store has called you and asked you to create a simple Microsoft Excel workbook so it can keep track of both customers selling music and its employees.
Individual Assignment Details (100 points):
- Each individual should create an create an Excel workbook that includes 2 different tables: an employee table and a customer table. Each table must appear on a different tab in the Excel workbook.
- Field titles for the employee table should be as follows: Employee ID numberFirst nameLast nameAddressDate of hireDate of birthSocial security numberHourly wage Field titles for the customer table should be the following: Customer ID numberFirst nameLast nameAddressPhone numberNumber of items sold to store For the employee table, enter 8 hypothetical employees into the tableFor the customer table, enter 10 hypothetical customers into the tableAppropriately title each submit a single Excel file to the Individual Submissions within the Unit 2 Group Project Submissions area.