User:KMSG/MIS101 Collaboration p178

MIS 101 Collaboration Exercise P178, Due 9 am 10/23/09 (no face to face meetings)

Group Members Kathy M George Kathy Dang Tania Choua Vue

There are five parts to this assignment

Part 1 = 1a) Page 158 analyze spreadsheet Part 2 = 1b)  Figure 5-29(a) three parts to question (Identifiers) (data integrity problems discussion) DB model speicfy key and foreignkey columns) Part3 = 1c) Figure 5-29b)  Five parts to this portion of the Second alternative data model.     1.  Identifiers     2.  Design Eliminate potential for data integrity problems          and discussion.     3.  Design Data Base using Work_Version2.  Specify key          and foreign key colums.     4.  Design Database for data models          using Work_Version3.Specify key and foreign key columns.     5.  Discuss Work_Version2 and 3 design. Why or Why          not are versions better. Part 4=1d)  Figure 5-29c  Choose Work-Version 2 or 3 for sheet-music tracking problem. This has three parts: 1=Identifiers, 2= Summarize difference3s between data model and that in figure 5-29b. Which model is better; why or whynot, 3= Disign a DB for this data model. Specify key and foreign key columns. Part 5 =1e: Whichof the three data models is the best? Justify your answer.

(Using MIS second edition; David M Kroneke;ch5 -pp142-179, copyright 2009-2007, Prentice Hall, Seattle, WA.)

We need a data base set up Final document ideas use Google Doc Use attached documents with emails Spread sheets MicroSoft Groove