DEPARTMENT OF FINANCE, OPERATIONS & INFORMATION SYSTEMS

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)
2. Createrelationshipsamong the tables as indicated in the ERD.(4 Marks)
3. Populate the database as follows:(Hint: Before populating CHILD tables with
4. data, populate PARENT tables)(3 Marks)

• Create 10 records each in the CUSTOMER (including your instructor and each member of your team), INVOICE, PRODUCTS, VENDOR, LINEITEM, SUPPLIES tables.
• Create 5 employees (EMPLOYEE table) each of whom has at least two records in the SALARY_HISTORY table
• Create 3 records each in the DEPARTMENT and BRAND tables

1. Createformsto simplify data entry into each of the tables. (See Access Help for
2. directions on creating aform with a subform.)(4 marks)