For this assignment, you will continue to work with the scenario you began in Chapters 1-5. Reread the information from each of these assignments at the end of each chapter. (Again, the â€œWestlake Research Hospitalâ€ scenario will act as an example throughout this course.)
Reread your selected scenario at the end of all previous chapters.
Read your scenario for Chapter 6 on pages 123-124.
Review the â€œDeliverablesâ€ section below.
Review the â€œSuggestions for Scenariosâ€ section on page 124 of your textbook for important details and ideas to assist you with your deliverables.
Read the â€œWestlake Research Hospitalâ€ scenario on page 18, pages 41-45, page 61, page 80, page 101, and page 124. Click here to review the suggested answer for this scenario to gain an understanding of what is expected of you on this assignment.
Your final deliverable will be a script file that you create from your database. To generate an SQL Script, right click on the database, go to TASKS on the context menu, and then GENERATE SCRIPTS. In the wizard you should change â€œScript Dataâ€ from â€œfalseâ€ to â€œtrueâ€ and then generate a script of the database you have built to turn in.
Complete the numbered tasks in the â€œTo Doâ€ section for your scenario, EXCEPT number 6. You DO NOT need to create a data dictionary. The table below shows where you can find each list of tasks:
Scenario Page Number for â€œTo Doâ€ List
Wild Wood Apartments Page 123