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

User Account

All Pages