Relationship diagram and a database design outline

Assignment Help Business Management
Reference no: EM132275328

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

Questions Cloud

Options for enhancing the spanning tree protocol : What are some options for enhancing the Spanning Tree Protocol?
How do support centers pass on the costs of managing : How do support centers pass on the costs of managing end-user services to clients. Find a company that has different support charges for different types of serv
Advantages describe the company strategic advantages : Advantages Describe the company’s strategic advantages and market position over the other three.
Iscuss some of the strengths and weaknesses of that model : Discuss some of the strengths and weaknesses of that model in comparison to what is offered in the United States.
Relationship diagram and a database design outline : Design a database for this information and hand in an entity-relationship diagram and a database design outline." I am really not sure
Compare the performance of the three merged banks : Bank Management Assignment - Bank Project. Compare the performance of the three merged banks 3 years before and 3 years after merger
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
Compare an existing organizations three major functions : Compare and contrast an existing organization's three major functions and then justify the interdependence that operations have to finance and marketing.
How can managers overcome obstacles to diversity : How can managers overcome obstacles to diversity such as mistrust and tension, stereotyping, and communication problems?

Reviews

Write a Review

Business Management Questions & Answers

  General and discretionary fiscal policy in particular

Define fiscal policy in general and discretionary fiscal policy in particular. Identify the tools of implementing fiscal policy and the goals intended by the use of these tools.

  Explain the four steps in on-boarding

Explain the four steps in on-boarding. What should new hires learn at each step? How might social media or the Internet aid the on-boarding process?

  Funding implications for severable service contracts

What are the funding implications for severable service contracts vs. non-severable service contracts?

  Daily sales

Each record on the table represents a day of total sales for each product and the data covers the last five years. Your boss asks you to create a visual report of the sales performance of each product during the last 12 months.

  Types of diversity when communicating professionally

Adapting Messages - types of diversity when communicating professionally

  Investment affects economic and social development

1. Explain how trade and investment affects economic and social development. Provide example of a country that had economic and social development from trade and investment. Also, provide example of a country that receives little to no trade. Plea..

  Can you establish the sales potential

Can you establish the sales potential?

  Calculate the cost of goods completed during june

Determine the number of units in the June 30 work-in-process inventory.- Calculate the cost of goods completed during June and prepare the appropriate journal entry to record completed production.

  Categories of consumer decision making

How does Tesla seem to view the type of decision making that consumers go through when they purchase their vehicles?

  What would be some challenges in using business analytics

Why should you have an understanding of statistics in order to utilize and implement business analytics?

  Provide getters and setters for attribute

Make an Invoice class that might serve as a receipt for items sold. An Invoice should be defined by the following attributes:

  Relationship between annual bonus and years of experience

The annual bonuses ($1,000s) of six employees with different years of experience were recorded as follows.

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