About the Database

A company resells paints to customers both individual and company customers, but same data is recorded for both. The company tracks the sale of products to customers and the purchase of paints from vendors. The database keeps data on customers (CUSTOMER), sales (INVOICE), products (PRODUCTS), which products are on which invoice (LINEITEM), employees (EMPLOYEE), the salary history of each employee (SALARY_HISTORY), departments (DEPARTMENT), product brands (BRAND), vendors (VENDOR), and which vendors supply each product (SUPPLIES).Refer to the ERD diagram shown below for further information on the entities and relationships.Based on the above description and the ERD, create a database using Microsoft Access and answer the following questions:

1. Using Microsoft Access, create all the required tables. Choose appropriate datatype and size for each of the attributes.(9 marks)