Problems and Exercises (Chapters 8 & 9) - from "Essentials of Systems Analysis and Design" Book

·         Chapter 8, Problems/Exercises, Questions 3 and 4 (top of page 268)

3.  Imagine the worst possible reports from a system. What is wrong with them? List as many problems as you can. What are the consequences of such reports? What could go wrong as a result? How does the prototyping process help guard against each problem?

4.  Given the guidelines presented in this chapter, identify flaws in the design of the Report of Employees shown below. What assumptions about users and tasks did you make in order to assess this design? Redesign this report to correct these flaws.

·         Chapter 9, Problems/Exercises, Question 3 (bottom of page 312)

    3. Transform the E-R diagram of Figure 9-21 into a set of 3NF relations. (attached image)