Fandom

Scratchpad

SWOSU - System Analysis and Design 07

216,218pages on
this wiki
Add New Page
Discuss this page0 Share

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.

SWOSU - System Analysis and Design 07 at Wikia


Welcome to the SWOSU - System Analysis and Design 07 mini wiki at Scratchpad!

You can use the box below to create new pages for this mini-wiki. Make sure you type [[Category:SWOSU - System Analysis and Design 07]] on the page before you save it to make it part of the SWOSU - System Analysis and Design 07 wiki (preload can be enabled to automate this task, by clicking this link and saving that page. Afterwards, you may need to purge this page, if you still see this message).


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)

Also on Fandom

Random wikia