HyperCase Additional Exercises

Chapter 11 - Designing Effective Output

Note: the data elements or attributes from the tables mentioned below may be found on classes (class diagram), entities (entity-relationship diagram) or data store descriptions (data flow diagrams).

  1. Design a report for each client. A separate page should be printed for each client. The report should list all client projects and include information from the Project Master, Milestones and Task Master tables. You should decide which of the elements on these tables would be appropriate to include on this external report to the client.

  2. Design a report that lists all the projects and tasks for each resource. Refer to the Project Master and Task Master tables. Choose which of the elements on these tables should be included on this report.

  3. Design a report that shows all milestones that have not been met (the milestone completion date contains zeros. List the milestone, the project the milestone is for and the tasks for each milestone. Refer to the Milestone Master, the Project Master and Task Master tables. Choose the elements found in these tables that should be included on this report. Include a count of all outstanding milestones.

  4. Create the Requirement Inquiry screen or Web Page. The elements and description of the screen may be found in the Requirement Inquiry Response data flow.

  5. Create the Leader Inquiry screen or Web Page. The elements and description of the screen may be found in the Leader Inquiry Response data flow.

  6. Create the Milestone Inquiry screen or Web Page. The elements and description of the screen may be found in the Milestone Inquiry Response data flow.

  7. Create the Project Inquiry screen or Web Page. The elements and description of the screen may be found in the Project Inquiry Response data flow.

  8. Create the Assignment Inquiry screen or Web Page. The elements and description of the screen may be found in the Assignment Inquiry Response data flow.

  9. Create the Resource Inquiry screen or Web Page. The elements and description of the screen may be found in the Resource Inquiry Response data flow.

  10. Create the Task Inquiry screen or Web Page. The elements and description of the screen may be found in the Task Inquiry Response data flow.

  11. Create a Web page for displaying items that MRE would sell to the general public. Include a search feature and an area showing special sale items. Include a means for customers to add an item to a shopping cart.