Your task is to develop a database for a company that runs a network of auto part stores.

Each auto part offered by the company for sale is identified by a stock-keeping unit (SKU) code assigned by the company. For each part, they want to store the part manufacturers name, a manufacturers own part number, the unit price of the part, and the associated part type code (we assume that each specific part has only one type). Part types are identified by their code, and a short description: for example the code FUF could abbreviate the description fuel filter, and the code SIL could abbreviate signaling lamp.

The database will include a table of all vehicle makes (manufacturers) that are considered in this database: for example, Honda, Ford, and so on. We assume that this table will not include further information for known model names and engine types.

Vehicle types are identified by a vehicle type code that corresponds to a specific combination of vehicle make, model name, year, and engine description. For example, Ford, Focus, 2018, 2.0 L 4-cylinder is a vehicle type code.

An essential feature of the new database will be to identify the compatibility of each part with certain vehicles. (Often, a given part fits more than one vehicle type.)

The database needs to be organized so that if a customer requests e.g., a tail light bulb for a 2015 Honda Civic from the company at one of its stores, then store staff can query the database to find out which are appropriate parts to fit this customers vehicle.

Design a database to hold all the above listed information. You do not have to enter any data or create forms in Access, just work on your answer sheet.

1. Create an ER diagram. To do this, you can use in MS Word the option Insert -> Shapes.

2. Create a database design outline; you can introduce synthetic keys as needed.