utilize structured query language sql to create and interact with the database 1
Instructions
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.)
Instructions:
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.
Deliverables:
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