Analyze it using the normalization concepts

Assignment Help Operation Management
Reference no: EM132136923

You handle administrative support for CyberToys, a small chain that sells computer hardware and software and specializes in personal service. The company has four stores located in malls and is planning more. Each store has a manager, a technician, and between one and four sales reps.Bruce and Marcia Berns, the owners, want to create a personnel records database, and they asked you to review a table that Marcia designed. She suggested fields for store number, location, store telephone, manager name, and manager home telephone. She also wants fields for technician name and technician home telephone and fields for up to four sales rep names and sales rep home telephones.

Draw Marcia’s suggested design and analyze it using the normalization concepts discussed in the chapter.

What do you think of Marcia’s design and why?

What changes would you propose?

Reference no: EM132136923

Questions Cloud

Identify the specific components of an institution : Every country in the world is constructed around the same set of institutional frameworks that differ only in how governments manage them.
Case study - degrandis sporting goods : Strategic Project Management Assessment Case Study - DeGrandis Sporting Goods. Provide Project Performance Scorecard (PPS) Snapshot
What role did the vision statement play in the success : What management strengths and business process expertise did the companies demonstrate that helped make the merger successful?
Concept of respondeat superior : What are your thoughts on the concept of respondeat superior?
Analyze it using the normalization concepts : Draw Marcia’s suggested design and analyze it using the normalization concepts discussed in the chapter.
Reflection of what audiences crave : Do you agree with Grazian, or do you think that test marketing represents an accurate reflection of what audiences crave? Defend your position.
Importance of ndas to suppliers and buyers : Discuss the importance of NDAs to suppliers and buyers. Most consumer fraud cases are not brought because of the small amount involved.
Exam and patient assessment–using emr and eprescribing : Create inventory of processes explicitly stated or implied in this case study. For implied processes, state rationale for why you are certain this process exist
Larger constants denote better indifference curves : Charlie's indifference curves have the equation xB = constant/xA, where larger constants denote better indifference curves. Charlie strictly prefers the bundle

Reviews

Write a Review

 

Operation Management Questions & Answers

  Responsibilities is to conduct training on diversity trends

As a new member of a top management consulting firm's diversity team, one of your responsibilities is to conduct training on diversity trends.

  Noncompliance to full integration of sustainability

For any organization, there are five stages to go from noncompliance to full integration of sustainability into a company’s strategy and purpose. Identify a company or organization that is at the 4th or 5th stage find a link to an article or video th..

  Many of these office workers work from other locations

At one time, most "office" workers sat at a desk and did their work. These days, many of these "office" workers work from other locations.

  Description of the company or organization

Create and write a description of the "Company" or "Organization". Give us an idea of the size of your company as far as how many employees you think you will hire, levels of management, and other details to help us understand this business.

  What roles do nursing homes play in providing rehabilitation

What roles do nursing homes play in providing rehabilitation and extended care for functionally disabled persons? Is the optimal approach, or can you suggest a different model based on current trends?

  What does it take to win back customer loyalty

For each, what was the major operational flaw associated with the company and situation?

  What are the criteria

Please do a search for organizations that have gone through restructuring or the organizations that this process is often outsourced to.

  Identify organizational-level goal-annual business strategy

Identify an organizational-level goal that would be incorporated into an annual business strategy Develop three organizational development strategies relating to HRM you would utilize as a manager to support this goal. Create the goals utilizing SMAR..

  Determine the organizations competitive position

Identify the most important internal environmental factors in the general, industry, and external analysis in relation to the internal analysis.

  The cost estimation to design a new aircraft

Boeing has developed the 787 for production in 2008*. It is expected to perform 20% more efficiently than any other plane. Assume the passenger load is similar to the Boeing 777 (which cost $6 billion to design and went into service in 1993). The BLS..

  Should a drug manufacturer that holds a patent on a drug

Should a drug manufacturer that holds a patent on a drug that is very effective for many AIDS patients be able to sell that drug well above its cost of production during the period of patent protection? If so, under what circumstances? Should these c..

  Explain any information that may help alliance reduce costs

Describe any information that may help Alliance reduce costs while providing better service. Propose a new approach that could be used by Alliance by using the purchase information that can be obtained on individual customers.

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