Compatibility of auto parts: Zip Guys, Inc., runs a large network of auto part stores. Each part they offer for sale is identified by an SKU code assigned by Zip Guys. For each part, they want to store the part manufacturer name, a manufacturer’s part number, a unit price, and the associated part type; each part has only one type. Part types are identified by a code, along with a description: for example “FUELFILT” for “fuel filter” or “SIGLAMP” for “signaling lamp.” A critical function of Zip Guys’ database is to identify the compatibility of each part with each type of vehicle. Each type of vehicle is identified by a specific “vehicle type code” that corresponds to a specific combination of vehicle make, model name, year, and engine description (such as “2.8 liter V6”). Usually, a given part fits more than one vehicle type, and there are, of course, a large variety of parts that can fit any given vehicle. The database needs to be organized so that when a customer has a request such as “I need a tail light bulb for a 2008 Toyota Matrix,” the store staff can query the database to find out which appropriate part(s) the store sells will fit the customer’s vehicle. Your database should also contain a table of known vehicle makes (but, for simplicity, do not include separate tables for known model names and engine types). Design a database for this information, creating an ER diagram and a database design outline.
![find the cost of your paper](https://essaybureau.com/wp-content/themes/essaybureau-child/images/findout.jpg)
The post Design a database for this information, creating an ER diagram and a database design outline. appeared first on Best Custom Essay Writing Services | EssayBureau.com.