Writing Data Definition Script, Load Data v$2$

To complete this assignment, you are to script the Data Definition Language $($DDL$)$ to create the

Sunny Skies Landscaping LLC database, tables, foreign key constraints, and other constraints

that were added to the database in last week$$s assignments.

Include the create and drop commands

$1.$ Write the DDL to form the new tables. Steps to follow:

a$.$ Append to the script file that was written prior for Sunny Skies Landscaping LLC$.$ Prior

to this assignment, the script should hold:

i$.$ Drop and Create commands for the Sunny Skies Landscaping LLC database.

ii$.$ Drop and Create commands for the following tables:

$1.$ Customers

$2.$ Jobs

$3.$ CustomersJobs

iii. The data loads for tables above.

iv$.$ Drop and create commands for the stored procedures written thus far.

b$.$ Appending to the script, write the DDL to drop, if exists, and create the following

tables:

i$.$ Employees

ii$.$ CustomersJobsEmployees

Note: Boolean, true $/$ false fields should use TINYINT data type with $0$

indicated false and $1$ indicating true.

c$.$ After writing the DDL for each object, test the script to make sure it runs as

expected. Don$$t forget to script the primary and foreign key constraints.

$2.$ Append to the script above to load the following data into the Employees table. Use the

default value for the EmployeeID field.

First Name: Sunny

Last Name: Sky

Email Address: Sunny.Sky@SomeDomain.com

First Name: Mary

Last Name: Patterson

Email Address: Mary.Patterson@SomeDomain.com

First Name: Jeff

Last Name: Firrelli

Email Address: Jeff.Firrelli@SomeDomain.com

First Name: William

Last Name: Patterson

Email Address: William.Patterson@SomeDomain.com

First Name: Gerard

Last Name: Bondur

Email Address: Gerard.Bondur@SomeDomain.com

First Name: Anthony

Last Name: Bow

Email Address: Anthony.Bow@SomeDomain.com

$3.$ Append to the script above to load the following data in the CustomersJobsEmployees table.

The following Employees are scheduled:

CustomerID: $1$

JobID: $5$

Scheduled On: XXXX$-10-24$

Employees:

Jeff Firrelli $($Team Lead$)$

William Patterson

CustomerID: $3$

JobID: $1$

Scheduled On: XXXX$-10-28$

Employees:

Gerard Bondur $($Team Lead$)$

Anthony Bow

$4.$ Append to the Enhanced Entity Relationship Diagram $($EER$)$ diagram the Employees and the

CustomersJobsEmployees tables, including all primary keys, foreign keys, and relationships.

Capture this as a screenshot.

$5.$ Upload the completed script $(.$sql$)$ file and the screenshot from $4$ above to this assignment

drop$-$box.