Make the entity-relationship diagram

Assignment Help Basic Computer Science
Reference no: EM132281136

"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." I am really not sure how i'm supposed to make the entity- relationship diagram. what are my primary keys supposed to be?

Reference no: EM132281136

Design, simulate and verify a 16-bit ripple-carry

Design, simulate and verify a 16-bit ripple-carry adder by performing the following additions/subtractions (the values of a and b are given in decimal): (i) (-10) + (100), (

Converting fahrenheit to celsius temperatures

The table should begin at 0 degrees Fahrenheit, use 2-degree Fahrenheit increments, and terminate when the difference between exact and approximate values is more than 4 deg

Which will have the greatest impact on the back-work ratio

hich will have the greatest impact on the back-work ratio: a compressor isentropic efficiency of 80 percent or a turbine isentropic efficiency of 80 percent? Use constant sp

Convert pseudocode program into javascript

Use notepad to write a pseudocode program that allows a student to enter a percentage and the number of absences and then displays the display the grade and explanation if a

Software and design implementation in completion

Software and design implementation in completion of Phase 1 of the recipe management system, XYZZY management set up a focus group to evaluate the system. The group found th

Deficit spending or balanced budget

Before getting into this discussion, I want you to read the attached "News Flash" from the textbook author, Bradley Schiller, which takes a look at implications of our natio

Why would ambiguity be a problem

Why would ambiguity be a problem? Why are mathematical notions, such as sets, a good foundation for specifications? What is the difference between preconditions, post-conditio

Consider a hypothetic experiment

One of the most widely used applications of spectroscopy is for the quantitative determination of the concentration of biological molecules in solution. The absorbance of a

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd