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

Questions Cloud

Does the rise of regional trading blocs : Does the rise of regional trading blocs threaten free trade progress made by the World Trade Organization?
How might you assess system requirements : How do these attributes impact the quality of requirements? How might you assess system requirements based off these attributes?
?control over price and an oligopoly leveraging : ?Control over price and an oligopoly leveraging it can be a problem, just look at what happened to the price for insulin.
Define arbitrage-economic data and analyses : Define arbitrage. Economic data and analyses have failed to explain international asset arbitrage behaviour or condition with economic variables
Make the entity-relationship diagram : "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
What is the mean number of differences per base-pair : BIOL B215 Experimental Design and Statistics Assignment - What is the mean number of differences per base-pair between the two species
Flowchart and pseudocode for a program : Flowchart and pseudocode for a program that takes a user input consisting of an integer number between 0 and 99 and outputs its conversion as binary.
Child relationships between the processes : Identify that parent/child relationships between the processes.
Reflect on the struggles of these courageous people : Reflect on the struggles of these courageous people. They fought and sacrificed for the opportunity to get into school.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Define a class named hotdogstand

You operate several hot dog stands distributed throughout town. Define a class named HotDogStand that has a member variable for the hot dog stand's ID number

  Why are multiple levels of cache needed in computer

Modern CPU chips have one, two, or even three levels of cache on chip. Why are multiple levels of cache needed? Suppose that a CPU has a level 1 cache and a level 2 cache, with access times of 1 nsec and 2 nsec, respectively.

  What is the general solution to handle such game trees

The min max algorithm cannot handle some games (even-with alpha-beta pruning) because of the depth of the search trees involved. What is the general solution to handle such game trees?

  How flow control can be achieved at the sender site in tcp

Using Figure 24.19, explain how flow control can be achieved at the sender site in TCP (from the sending TCP to the sending application). Draw a representation.

  Lecture and webtext materials

Based on the lecture and Webtext materials, address the following:

  How a simple serial number stored in a cookie

1.) Explain how a simple serial number stored in a cookie can be used to store personal information. 2.) Describe why the argument on whether computers can think has little impact on our daily lives. Use your word processor to answer this.

  Steps to follow to get evidence in investigating files

Drive that you are investigating comprises several password-protected files and other files with headers which do not match extension. What procedures would you require to follow to retrieve evidence?

  Track of business trips of salespersons

Consider the following relations for a database that keeps track of business trips of salespersons in a sales office:

  What is the price that you should charge

You are currently charging $10 for your product. What is the price that you should charge, if demand elasticity is -3? (Essay)

  National identification card for the united states

What are the pros of a national identification card for the United States? Examples?

  Compute the total number of consonants in the sentence

Write a function that takes as input an English sentence (a string) and prints the total number of vowels and the total number of consonants in the sentence.

  Android program for a rock paper spear scissors game

Android program for a rock paper spear scissors game - Incorporate a scoreboard such as player wins vs opponent wins

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