Data base systems

Part 1: Answer the Module Review Questions listed below. These questions were chosen to demonstrate your understanding and help you assess your progress.

1. What is the purpose of creating a logical process model and then a physical process model? What information is found on the physical DFD that is not included on the logical DFD?

2. Distinguish between a control module, subordinate module, and library module on a structure chart. Can a particular module be all three? Why or why not?

3. Where does the analyst find the information needed to create a structure chart? Describe the purpose of program specification.

4. What is the difference between structured programming and event-driven programming?

End of Module Questions - Part 2

Critique the following structure chart that depicts a guest making a hotel reservation. Describe the chart in terms of fan-in, fan-out, coupling, and cohesion. Redraw the chart to improve the design.

1

RESERVE

ROOM

Guest Record

Reservation

Record

Preference Record

Updated Customer Record

Updated Reservation Record

Guest Record

Guest

ID

Hotel

Full

Date

1.1

LOCATE AVAILABLE ROOM

1.2

READ

GUEST

RECORD

1.3

EDIT NEW GUEST INFORMATION

1.4

EDIT OLD

GUEST INFORMATION

1.5

ASSIGN

ROOM AND PREFERENCE INFO

1.6

WRITE UPDATED CUSTOMER RECORD

1.7

WRITE NEW RESERVATION

1.8

PRINT RESERVATION CONFIRMATION

1