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 anexample throughout this course.)Instructions:1. Reread your selected scenario at the end of all previous chapters.2. Read your scenario for Chapter 6 on pages 123-124.3. Review the “Deliverables” section below.4. Review the “Suggestions for Scenarios” section on page 124 of your textbook for important details and ideas to assist you with your deliverables.5. 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.6. Your final deliverable will be a script file that you create from your database. To generate an SQL Script, rightclick on the database, go to TASKS on the context menu, and then GENERATE SCRIPTS. In the wizard youshould change “Script Data” from “false” to “true” and then generate a script of the database you have built to turnin.Deliverables:1. Complete the numbered tasks in the “To Do” section for your scenario, EXCEPT number 6. You DO NOT need tocreate a data dictionary. The table below shows where you can find each list of tasks:Scenario Page Number for “To Do” ListWild Wood Apartments Page 123-124Vince’s Vinyl Page 124Grandfield College Page 124TEXTBOOK:Conger, S. (2014). Hands on database: An introduction to database design and development (2nd ed.). Upper SaddleRiver, NJ: Pearson.Taylor, A. G. (2013). SQL for Dummies (8th ed.). Hoboken, NJ: Wiley.See below specifics from professoryou either need to submit the database schema from SQL Server or the SQL statements that could be used to build your database, including the CREATE TABLE and INSERT statements.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|