Part $1-$ Creating a Database

$1.$ Create a new database in MS Access.

$2.$ Import the following tables from the Excel file.

The EMPLOYEE table keeps track of employee details. The DEPARTMENT table stores data about the departments. The REGION table contains the location and region for each department. The DEPENDENT table stores data about the dependents of the employees. The CUSTOMER table contains data about the customers. The PRODUCT table contains data about the products. The SALES$\_$ORDER table contains data regarding each sales order.

$3.$ Identify the keys $($Primary and Foreign$)$ in each table. $($Some of the tables may require a composite key for Primary Key$).$

Part $2-$ Oueries

Now answer the following queries. Store the query designs as Q$1,$ Q$2,$ Q$3,$ Q$4,$ Q$5,$ Q$6,$ Q$7,$ Q$8,$ Q$9,\backslash$& Q$10$ to match up with the following queries

$1.$ List the names and addresses of all employees.

$2.$ Who are the employees with salary more than $\backslash (\backslash$$ $25,000\backslash )?$

$3.$ What is the name of the department in which the employee Jennifer Wallace works?

$4.$ Who are the dependents of John B$.$ Smith?

$5.$ List the locations which belong to the East.

$6.$ What is the name of the department of each employee?

$7.$ List all the Customers who purchased Helmet.

$8.$ List all the sales employees with the number of orders taken by each employee.

$9.$ List the names of the customers who were served by Ramesh Narayan.

$10.$ List the Names of the customers who placed an order between $1$st October $2009$ and $31$st December $2009.$