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.

RESERVE

ROOM

Guest Record

Reservation

Record

Preference Record

Updated Customer Record

Updated Reservation Record

Guest Record

Guest

ID

Hotel

Full

Date

1