SWOSU - System Analysis and Design 07

Systems Analysis and Design - Fall 2007 Assignment 1 - Assigned: September 18, 2007 Due: October 3, 2007, in class

Note: You must document your assumptions and justify your choices.

CH. 5 Page 192 Review Question 1.
(10 points)

Q: What are some of the reasons for creating models during system development?

A: -

CH. 5 Page 193 Problems 11, 12, 13 and 14.
'''Develop a relational database schema for the ERD in problem 13. In what normal form is the database? Justify your answer. Normalize the database to 3NF if required. Develop an ODL database schema for the domain model class diagram in problem 14. (5 + 5 + 10 + 10 points)'''

Q11
Consider the entity-relationship diagram shown in Figure 5-28, the refined ERD showing course enrollment with an associative entity. Does this model allow a student to enroll in more than one course section at a time? Does the model allow a course section to contain more then one student? Does the model allow a student to enroll in several sections of the same course and get a grade for each enrollment? Does the model store information about all grades earned by all students in all sections?

Answer: -

Q12
Again consider the entity-relationship diagram shown in Figure 5-28. Add the following to the diagram and list any assumptions you had to make. A faculty member usually teaches many course sections, but some semesters a faculty member may not teach any. Each course section must have at least one faculty member teaching it, but sometimes teams teach course sections. Furthermore, to make sure that all course sections are similar, one faculty member is assigned as course coordinator to oversee the course, and each faculty member can be coordinator of many courses.

Answer: -

Q13
Answer: -

Q14
Answer: -

CH. 7 Page 278 Problem 1.
'''Develop an ODL database schema for the domain model class diagram in problem 1. (20 points)'''

CH. 7 Page 278 Problem 3.
'''Develop an ODL database schema for the domain model class diagram in problem 3. (20 points)'''

CH. 12 Page 479 Review Questions 13, 18, 30, 31, 32.
(5 X 5 points)

Assume each table in figure 12-4 on page 446
'''Assume each table in figure 12-4 on page 446 of the text book is stored in a different Server (“ProductItem : Table” in Server A and “InventryItem : Table” in Server B). Also assume that we want to know all the Sizes and Colors of Polo Shirts with QuantityOnHand greater than 30. If the query arrives at Server B, list the intermediate steps that are required to obtain the desired information. (10 points)'''

For the Domain model class diagram (Figure 1) on page 2
'''For the Domain model class diagram (Figure 1) on page 2 of this assignment, develop an ERD. Then develop a relational database schema from the ERD. In what normal form is the database? Justify your answer. Normalize the database to 3NF if required. (15 points)'''

Consider the table in Figure 2 on page 2
'''Consider the table in Figure 2 on page 2 of this assignment. This table is in first normal form. Decompose the table such that the resulting tables are in second normal form. Are the resulting tables also in third normal form? (10 points)'''

Consider the table in Figure 3 on page 3
'''Consider the table in Figure 3 on page 3 of this assignment. This table is in second normal form. Decompose the table such that the resulting tables are in third normal form. (10 points)'''