Autoparts warehouse

Assignment Help Basic Computer Science
Reference no: EM13134845

AutoParts Warehouse 

AutoParts Warehouse is a small auto parts supplier with locations in several Midwestern metro areas. The business is based on the idea of discount prices for auto parts that are always in stock or can be delivered within hours. The owners have decided to computerize their operations to allow them to better track their business and manage their inventories for just in time deliveries for sales. Data to be gathered for each customer sale includes invoice number, date, parts number, cost, retail price. Customer data is collected that includes basic contact information and vehicles owned, which includes vehicle make and model. For parts that have to be delivered to the store to fulfill a customer purchase, a transfer request is created. Data associated with these transfers include tracking number, invoice number, date, parts number, origination location (store or warehouse) number, destination store number. 

Assignment 2 Task 1 
Draw an ERD for AutoParts Warehouse indicating the types of relationships between the entities. 

Task 2 
For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys. 

Task 3 
Create fully normalized 3NF table designs for the system. 

Task 4 
Suggest ways AutoParts Warehouse can use codes to simplify output, input, and data formats

Reference no: EM13134845

Questions Cloud

What is the final temperature : A 45.5 g sample of copper at 99.8 degrees celsius is dropped into a beaker containing 152 g of water at 18.5 degrees celsius. What is the final temperature when thermal equilibrium is reached?
What type of variable for patient-s heart attack as mild : Patient's heart attack as mild, moderate or severe. The nurse's classification of the severity of the patient's heart attack is an example of what type of variable?
Determine the accounting principles of the foreign : Access the financial statements from the most recent annual report of a foreign company and a domestic company with which you are familiar to complete this assignment.
What is the average atom weight of the element : A hypothetical element Z has two stable isotopes: Z-46 = 46.046 u 64.08% Z-51 = 50.826 u 35.92% What is the average atom weight of the element?
Autoparts warehouse : AutoParts Warehouse is a small auto parts supplier with locations in several Midwestern metro areas. The business is based on the idea of discount prices for auto parts that are always in stock or can be delivered within hours. The owners have decide..
Year-end market price of share : Ralite Company had net income for the year of $20 Million. It had 2 Million sharees of comon stock outstanding, with a year-end market price of $82 a share. Dividends during the year were $5.74 a share.
What is the maximum amount of interest expenditures : What is the maximum amount of interest expenditures that the government would be permitted to report on the bonds for 20X7?
How much work has been done : A piston has an external pressure of 8.00 torr How much work has been done if the cylinder goes from a volume of 0.130 liters to 0.450 liters.
Mathematics-coordinate geometry : Sketch the given region R and then find its area. R is the rectangle with vertices (1, 0), (-2, 0), (-2, 5), and (1, 5).

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Explain the concept of supply chain management

Explain the concept of supply chain management. Although R/Way offers services rather than products, could that concept apply to the design of R/Way's new system? If so, how?

  Reverse a sixteen-bit binary number by lc program

How to reverse a 16-bit binary number by LC-3 program? Program should assume that the word to be reversed is stored in memory location x3100.

  Explain us supreme court-s reaction bribery of internal

Explain what was U.S. Supreme Court's reaction to case where business executive was found guilty of aiding and abetting in bribery of Internal Revenue Service Agent.

  Create an incident-response policy

Create an incident-response policy that covers the development of incident-response team, disaster-recovery processes, and business-continuity planning.

  Find whether bit string contains two consecutive one bits

You wish to find out whether bit string contains two consecutive 1 bits. Obviously, you can do this using n probes. For which values of n in range {3, 4, 5, 6, 7} can this be done using fewer than n probes?

  User interface design guidelines used for new system

Design a suitable source document for ads that are telephoned or mailed in. Suggest at least four user interface design guidelines that could be used for the new system.

  Importance of top management commitment

Discuss the importance of top management commitment and the development of standards for successful project management. Provide examples to illustrate the importance of these items.

  Write name of storage location involved in the code

Recognize each dependency by type; write the two instructions involved; recognize which instruction is dependent; and name storage location involved.

  Find probability of having no umbrella if it rains

When rain is forecast, Mr. Pickwick takes his umbrella. When rain is not forecast, he takes it with  probability 1/3. Find the probability that Pickwick has no umbrella, given that it rains.

  Verify local police department-s findings on current case

Your computer investigation firm has been hired to verify local police department's findings on current case. Tension over the case is running high in the city.

  Converting binary numbers in decimal

Convert the given binary numbers in decimal: 101110; 1110101; and 110110100. Convert the given decimal numbers to bases indicated.

  Explain remote batch-processing operation

A band is always equal to? In signal power as light travels down fiber is called. what does remote batch-processing operation in which data is only input to central computer would need?

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