User Account

All Pages

Auto-parts warehouse

Assignment Help Operation Management
Reference no: EM132641527

Case Study

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

Tasks 1:

Based on your understanding of the case study, identify the main entities and then develop E.R. diagram for Auto-Parts Warehouse. Within the E.R. diagram you need to show the types of relationship cardinality between the entities.

Tasks 2:

There are different types of attributes, explain in details all these types? In Task 1 you developed E.R. diagram for Auto-Parts Warehouse, from that E.R. diagram you need to give two examples related to each attribute type.

Tasks 3:

From the E. R. diagram that you already developed in Task 1, identify if there are any possible weak entities, explain why?

Tasks 4:

From the E. R. diagram that you already developed in Task 1, identify if there are any possible associative entities, explain why?

Reference no: EM132641527

Questions Cloud

What is the impairment loss : One of the cash-generating units of Twin Corporation is that associated with the manufacture of wine barrels. What is the impairment loss
Prepare the vat account to ascertain the amount : Prepare the VAT account to ascertain the amount to be paid or recovered from the tax authorities as on 31st January 2020
What amount should Jerome record as investment income : ASSOCIATE WITH OUTSTANDING PREFERENCE SHARES - What amount should Jerome record as investment income for the year ended December 31, 2016
Marketing plan for final project : The course is structured so that each week you will work on specific segments of your marketing plan for the Final Project.
Auto-parts warehouse : Auto-Parts Warehouse is a small auto parts supplier with locations in several Midwestern metro areas.
Project team would follow for closing the project : Describe the process you and your project team would follow for closing the project.
Honesty and loyalty are two big characteristics : I believe honesty and loyalty are two big characteristics that leaders must show to be a successful leader.
Contribution factors of trade and supply chain flow : How COVID-19 impacts the contribution factors of trade and supply chain flow?
Stages of hydro one enterprise risk management process : What is Hydro One's strategy and what risks does the company face? Consider the three stages of Hydro One's enterprise risk management (ERM) process:

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd