#1 (Chapter 2) [20 points]
Figure 2.8 shows seven (7) examples of E-R diagrams representing seven (7) different types of relationships.
Draw another seven (7) E-R diagrams for seven (7) different types of relationships using the layout format of Figure 2.8.
In each E-R diagram using the layout format of Figure 2.7, write two sentences (i) as you read from left to right and (ii) as you read from right to left.
#2 (Chapter 4) [30 points]
Part A [15 points]
Please response to question "Consulting Opportunity 4.1 (pp. 108)."
Part B [15 points]
Please response to question "Consulting Opportunity 4.2 (pp. 111)."
#3 (Chapter 5) [10 points]
Cheryl Stake is concerned that too many forms are being filled out incorrectly. She feels that about 10 percent of all the forms have an error.
How large a sample size should Ms. Stake use to be 96-percent certain she will be within 0.05?
Suppose Ms. Stake will accept a confidence level of 90 percent that she will be within 0.07. What will the sample size of forms be now?
#4 (Chapter 7) [25 points]
Refer to problems 1, 6 & 7 in Kendall & Kendall pp. 206 [with some modifications])
Part A [10 points]
Up to this point you seem to have had an excellent rapport with Kevin Cahoon, the owner of a musical instrument manufacturing company. When you showed him the data flow diagrams you drew, however, he did not understand them.
a. In a paragraph, write down in general terms how to explain to a user what a data flow diagram is.
Be sure to include a list of symbols and what they mean.
b. It takes some effort to educate users about data flow diagrams. Is it worthwhile to share them with users? Why or why not? Defend your response in a paragraph.
Part B [15 points]
a. Draw a context-level data flow diagram for Perfect Pizza (Problem 5).
b. Explode the context-level diagram in Problem 6 showing all the major processes.
Call this Diagram 0. It should be a logical data flow diagram.