Entity relationship diagram

Assignment Help Business Management
Reference no: EM132283737

"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: EM132283737

Questions Cloud

What elements are included are entirely up to each : For the final paper you will individually be drafting a project charter for the project you selected during the residency weekend.
What are the conclusions and recommendations : From an article of your choice from the Harvard Business Review, choose an article that deals with one or more of the elements of marketing strategy.
What are your thoughts on having a global currency : The different currencies are having negative consequences on the different economies around the globe.
Prepare a powerpoint presentation on norma mccorvey : Prepare a 5-8-page PowerPoint Presentation on your assigned topic. Prepare a synopsis, telling me the significance of your topic, the ethical dilemma presented.
Entity relationship diagram : I am really not sure how i'm supposed to make the entity- relationship diagram. what are my primary keys supposed to be?
Write a pae internal business proposal to the dean : Write a 5 page internal business proposal to the dean of Lehman College.
Code below that uses the fork system call : Consider the code below that uses the fork system call:
Describe what imc tactics were used : Please find an example of an integrated marketing communications campaign (meaning the campaign synthesizes advertising, marketing and public relations).
Create three specific performance measures : Based on the information learned, create and justify the need for four categories of measurement, such as customer satisfaction or financial performance.

Reviews

Write a Review

Business Management Questions & Answers

  Significant barrier to reflection on experience

In your opinion, what is the most significant barrier to reflection on your experience? Support your comments with reasoning and evidence.

  Determining the private vs public control

The major payers in private healthcare (other than government programs) are employers, and this has been true since the inception of health insurance programs.

  Discuss the suitability of the general business research

MIS771 Descriptive Analytics and Visualisation - Discuss the suitability of the general business research approach taken. In your response, include possible alternative approaches and other sources of (secondary) data

  American economy and how it workshow does the

american economy and how it workshow does the political-economic system affect the problems related to the american

  How supervisors at the organization motivate employee

What are some organizational examples of each of these needs? Evaluate the organization you have selected for study during the course. How do managers and supervisors at the organization motivate and improve employee performance

  State financial information is reported in real sec filings

The general objective of the project is to provide an opportunity for you to see how financial information is reported in real SEC filings. The primary focus is on ACC 100C topics and how they are reported in the financial statements and footnoted..

  Consumer perception of a product

Examine two ways in which advertising can change the consumer's perception of a product and thereby affect the decision to purchase. Support your answer with examples.

  How the first amendment may affect you as an employee

Think about how the First Amendment may affect you as an employee. Should your first amendment protection extend to you as an employee?

  Where do business and financial risk come from

How does one define business and financial risk? Where do business and financial risk come from?

  Consider the four main generic strategies

Consider the four main generic strategies. Select one of them (cost leadership, differentiation, focused cost leadership

  Explain how can franchises guarantee its products

Explain how can franchises guarantee its products are appropriate for international markets? Should governments guard its industries by placing tariffs on imported products?

  Difference in a firms commitment to ethics

In what ways do individuals make a difference in a firm's commitment to ethics.

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