HYPERCASE ® EXPERIENCE 13

“I hear very good things about your team from the people in Management Systems. You even got some hard-earned praise from Tom Ketcham who isn’t easy to please these days. Even he is seeing some possibilities. I think you’ll pull us together yet . . . unless we all go off in different directions again. I’m just teasing you. I told you to think about whether we are a family, a zoo, or a war zone. Now’s the time to start designing systems that fit us. You’ve been here long enough now to form those opinions. I hope they’re favorable. I think our famous Southern hospitality coupled with my noticeably British sense of humor should help influence you, don’t you? I was so busy persuading you that we’re worth the effort that I almost forgot to tell you: Tom and Snowden have agreed to think about moving toward a database of some sort. Would you have this ready in the next two weeks? Tom is at a conference in Minneapolis, but when he returns you should have some database ideas worked up for Snowden and him to discuss. Keep at it.”

HYPERCASE Questions

1. Assume your team members have used the Training Unit Client Characteristics Report to design a database table to store the relevant information contained on this report, with the following result:

2. Apply normalization to the table your team has developed to remove repeating groups. Display your results.

3. Remove transitive dependencies from your table and show your resulting database table.