Add $/**/$ Comments to your script to include your Name, class, and Assignment Name.

This assignment will create a Database with a name of your choosing. Do not use Database names from previous class work.

Create the following SQL code using the specified DDL statement in the query window. Comment each step in the script.

Create the Database and Script.

Using the Object Explorer, open the Databases Folder. Right Click and Select New Database

Generate a Database Name.

In the New Database Dialog, Select the Script Download and select "Script Action to New Query Window".

Save this Script. Recommendation for VDI users: Save this to your OneDrive for future editing.

Create a New Query.

Add the following lines:

USE master

GO

IF DB$\_$ID$(\text{'}$YourDBNameHere$\text{'})$ IS NOT NULL

DROP DATABASE YourDBNameHere

CREATE DATABASE $[$YourDBNameHere$]$

Use YourDBNameHere

GO

$--$ DB Build complete

Test your script. Press F$5$ in the Object explorer to refresh your database list.

Generate the SQL required for the tables. Include verbose data definitions, indexes and constraints as needed.

Note: SSMS has ways to create tables visually and you can later retrieve a build table script to use and modify. $($Script Table as $...)$

Add your SQL code to your script in Step $3.$

Create the SSMS Database Diagram.

Open the Database in the Object Explorer. Right click on the Database Diagrams folder and create a new Diagram.

Arrange the diagram so it fits mostly all on the screen.

Right click in a blank area of the diagram. Select "Copy Diagram to ClipBoard".

Open MS Paint or Word and Paste the diagram and save the file.