Scripting Data

Topic 

Scripting Data

Requirements 

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:

  1. Reread the introduction to your selected scenario (Wild Wood Apartments) and the continuations on pages 37-39, page 60, page 79, and page 100.
  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 40-43, page 61, page 80, page 101, and page 124. 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, 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:

  1. Complete the numbered tasks in the “To Do” section for your scenario, EXCEPT number 6. You DO NOT need to create a data dictionary.

Answer Preview 

GO
/****** Object: Database [Wild Wood] Script Date: 6/7/2017 6:08:17 PM ******/
CREATE DATABASE [Wild Wood]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N’Wild Wood’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL12.MOSES\MSSQL\DATA\Wild Wood.mdf’ , SIZE = 9216KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N’Wild Wood_log’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL12.MOSES\MSSQL\DATA\Wild Wood_log.ldf’ , SIZE = 1280KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Wild Wood] SET COMPATIBILITY_LEVEL = 120
GO
IF (1 = FULLTEXTSERVICEPROPERTY(‘IsFullTextInstalled’))
begin
EXEC [Wild Wood].[dbo].[sp_fulltext_database] @action = ‘enable’
end

Word Count: 800