Database Scenario:
The Music Stop is a locally owned music store in your hometown. It buys and sells CDs, cassettes, and recordswith a staff of 8 people. Up until this point, it has beenusing 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 hascalled you and asked you to create a simple Microsoft Access table so it can keep track of the customers selling music and its employees.
Individual Assignment Details (100 points):
Each individual shouldcreate an Access database that includes 2 different tables: an employee table and a customer table.
- Field titles for theemployee table should be as follows:
- Employee ID number
- First name
- Last name
- Address
- Date of hire
- Date of birth
- Social security number
- Hourly wage
- Field titles for the customer table should be the following:
- Customer ID number
- First name
- Last name
- Address
- Phone number
- Number of items sold to store
- Select the appropriate data type for each field title (for example: social security number would be number type)
- For the employee table,enter 8 fake employees into the table
- For the customer table, enter 10 fake customers into the table
- Appropriately title each table
- If you think of other field titles that should be included, make sure to include them.
- Some things to consider:
- To create a new table, click “Create” on the top toolbar and then select table.
- To addfield titles on the “Home” toolbar switch to Design View.
