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

  How to make system more user-friendly

What improvements or additions to the system do you believe would advantage you or make system more user-friendly? Why?

  Explain chain of custody is critical factor for cases

Think of numerous cases where evidence could potentially be tampered with a cell phone or thumb drive. What can go wrong?

  Kinds of system-building methods used by dorfman

Recognize the kinds of system-building methods used by Dorfman to create its wireless warehouse system. Explain the methodologies you would recommend

  Question based on artificial intelligence

If the brain is a computer and the mind its workings, is this fitting analogy of the computer and its software? What would happen if we had dedicated computers with a huge number of neuron circuits?

  Explaining publication of material in foreign languages

Which of the given statements about publication of material in foreign languages is not right? it is competitive neccessity or it must be accurate.

  Define artificial intelligence

Provide a reference list of at least 8-sources that are properly cited according to APA format. I would like to see a variety of sources, for example not just articles from one journal.

  Determine total hours committed by employee

Assume the weekly hours for all employees are stored in the two-dimensional array. Each row records the employee's seven-day work hours with seven columns. Determine total hours committed by each employee every week.

  Expert systems created-deployed in real-world applications

Expert systems have been created and deployed in many real-world applications to support decision making. Discover one recent case study or academic journal article.

  Determine the source rate r

Suppose that 30 pictures are sent per second. (This digital source is roughly equivalent to broadcast TV standards that have been adopted.) Determine the source rate R (bps).

  Explaining mismatched file headers to extensions

What procedures would you require to follow to retrieve evidence? Identify mismatched file headers to extensions.

  Write and explain briefly three guidelines for sound policy

Write and explain briefly three guidelines for sound policy, as stated by Bergeron and Bérubé. Are policies different from standards? In what way? Are policies different from procedures? In what way?

  Evaluate situation if you lack behind schedule on project

Evaluate a situation where you have fallen behind schedule on a project. How could more effective scheduling have allowed the project to stay on track?

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