Autoparts warehouse, AutoParts Warehouse is a small auto

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).

User Account

All Pages