Supplier with locations in several midwestern metro areas

Assignment Help Operation Management

Reference no: EM132164542

Auto Parts Warehouse

Auto Parts 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.

1. Draw an ERD for Auto Parts Warehouse indicating the types of relationships between the entities.

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.

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

4. Suggest ways Auto Parts Warehouse can use codes to simplify output, input, and data formats.

Reference no: EM132164542

Questions Cloud

New performance management system : The Case of Bridgeport Academy of a new performance management system designed specifically for support staff at a school in the United Kingdom.

Using the economic ordering quantity model : Using the economic ordering quantity model, the order size that would minimize the total costs is equal to?

Human sexuality apply to public-societal aspects of ethics : Explain how the topics of morality, marriage and human sexuality apply to the public and societal aspects of ethics.

Driving the organization culture from leader perspective : Discuss the significance of driving the organization’s culture from a leader’s perspective.

Supplier with locations in several midwestern metro areas : Auto Parts Warehouse is a small auto parts supplier with locations in several Midwestern metro areas.

Describe three significant hr issues : Describe three significant HR issues that you and your people will likely face after your company is acquired.

Firm whose employees primarily work in office setting : You are working as an HR professional for a firm whose employees primarily work in an office setting.

What are three benefits of creating process map : What are three benefits of creating a process map? What circumstances would warrant the creation of a process map?

Metropolitan richmond from one central bakery : Piece Of Pie is a commercial bakery which provides freshly made pies throughout metropolitan Richmond from one central bakery.

User Account

All Pages