Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 2. Compatibility of Auto Parts Zip Guys, Inc. runs a large network of auto part stores. Each part they offer for sale is identified

Question 2. 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 assigned by Zip Guys. For each part, they want to store the identity of 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" which corresponds to a specific combination of vehicle specific 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 and hand in an entity-relationship diagram and a database design outline.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Experts Guide To Database 2

Authors: Bruce L. Larson

1st Edition

0070232679, 978-0070232679

More Books

Students also viewed these Databases questions