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

  Explaining security risks for computing infrastructure

In your new position at XYZ Corporation, you have been asked to lead risk assessment team. As part of project to assess security risks for computing infrastructure.

  Writing viruses-worms and trojan horses

Course taught students how to write viruses, worms, and Trojan Horses. It also explained the history of computer viruses as well as how to block attacks.

  Determine the date in opening of letter

If /home/jenny/draft and /home/alex/letter are links to same file and following sequence of events occurs, what will be date in opening of letter? Alex gives command vim letter.

  Identify and describe specific capabilities of computing

Identify and describe 5 specific capabilities of computing (e.g., speed, permanence/storage) made possible or enhanced by computing technology.

  Develop requirements traceability matrix

The GlobalUBid.Com Case Study will be used to develop a requirements traceability matrix describing and following the life of requirements in both the forward and backward direction.

  Tools or tactics used by risk assessment team

In your new position at XYZ Corporation, you have been asked to lead risk assessment team. How can you bring everyone to agreement an what are there any tools or tactics you might use to help?

  Draw logic diagram of circuit having flip-flop equations

A sequential circuit has two D flip-flops A and B, two inputs x and y, and one output z. The flip-flop equations and circuit. Draw the logic diagram of the circuit.

  Draw comparisons with software architecture

Draw comparisons with software architecture. How are the disciplines of classical architecture and the software architecture similar? How do they differ?

  Storing and compiling a large amount of data

Because information systems are able to store and compile a large amount of data, many people worry that, their private data will end up in the wrong hands. Explain your position.

  Evaluate archiver-s method opitmally

You've been hired as the outside consultant to evaluate archiver's method, in part as company is interested in automating this phase of process. Is archiver's method optimal?

  Compare performance-one-level split-two-level unified cache

Compare the performance (using AMAT) of a one-level split cache and a two-level unified cache system. For the one-level split cache, suppose a hit takes 2 clock cycles.

  Question about flight function

An airline vice president in charge of operations requires to determine whether the current estimates of flight times are accurate. because there is a larger possiblity of variations due to wether and air traffic in the longer flights.

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