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

  Discussion of vulnerabilities

The paper should include the features of secure e-mail and how secure e-mail works. Include a discussion of vulnerabilities involved in e-mail and how they can be countered. The presentation should include the following:

  What is universal design and multi-modal system

What is Universal design and Multi-modal system? And how does the self driving cars relate or meet the Universal design and Multi-modal design requirement

  Agile versus process maturity approaches

From the e-Activity, define CMMI, explain its purpose, and describe how two process areas of CMMI deliver on its purpose. Give an example of how the CMMI six-point scale is used to assess the software development process in an organization.

  Next year the economy will be in an expansion

Suppose your client is risk-averse but can invest in only one of the three securities, X, Y, or Z, in an uncertain world characterized as follows.

  Let''s discuss the i/o classes available to us in java

What are the different ways we can use collections and how would go about it?

  Calculate the present value of net benefits

a. Calculate the present value of net benefits assuming that the benefits are realized at the end of each of the three years.

  The psychology of security

The paper "The Psychology of Security" (Communications of the ACM [2008]: 36-41) states that people are more likely to gamble for a loss than to accept

  Transferred in of accounts in response

How much would be transferred in (or out) of these accounts in response to a 30% stock dividend, respectively?

  What will the following code segments print on the screen

What will the following code segments print on the screen

  Analyzing business goals and constraints

"Analyzing Business Goals and Constraints," you learned about ElectroMyCycle, a manufacturer of a new electric motorcycle.

  Major components of a national health policy

What health programs target the three major components of a national health policy: structural determinants of good health

  Construct cumulative frequency and cumulative percentage

Construct cumulative frequency and cumulative percentage distributions for the following prices of personal computers

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