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

  Select processor or disk for economical view

Similary there is set of disk drives for $7000 which promises two and half times the throughout of your existing disks. Then in economical view whether processor or disk is to select for your computer?

  Steps to follow to verify local police department-s findings

Your computer investigation firm has been hired to verify the local police department's findings on a current case. What do you need to ask the police investigator for, and what procedures should you follow?

  Corporate or government agency policy on instant messaging

What specific questions must a corporate or government agency policy on "Employee use of Instant Messaging (IM) using corporate computers" address?

  Provide explanation for why tablespace might have problem

Provide explanation for why your tablespace might have problem, and write at least two actions you can take to lessen the problem

  Task manager to recognize and troubleshoot problems

Which system resources are probable to be at root of problem? How can you use system tools, like the Task Manager, to help recognize and troubleshoot these problems?

  Describing online services provided by selected companies

Identify and briefly describe the online services provided by the selected companies (e.g. online catalogue search, online information search.

  Tradeoffs involved to improve overall system performance

What are your thoughts on the tradeoffs involved when attempting to improve overall system performance. Provide examples where an increase in the performance of one resource.

  Explain nefarious computer activities known ping sweeps

Write short description of what they are and include assessment of whether this activity is something to worry about or not.

  Find the probability both windows are idle

The post office uses a multiple channel queue, where customers wait in a single line for the first available window.  the probability both windows are idle.

  Distinguish online learning with classroom learning

Write the exploratory essay in which you distinguish online learning with classroom (on-ground) learning. Your estimation may incorporate preparation time.

  Iidentify primary types of media employed

For the network that you have chosen to characterize for this class, identify the primary types of media employed. Be sure to include both how the computers individually connect.

  Perform the usual operations on circle

You should be able to perform the usual operations on the circle, such as setting the radius, printing the radius, calculating and printing the area and circumference.

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