Execute the SQL statement at the beginning of Exercise $7\mathrm{.}14$ to reset the two tables and their relationship before this exercise.

IF OBJECT$\_$ID$($N$\text{'}$Chapter$7$Exercise.Courses'$)$ IS NOT NULL

DROP TABLE Chapter$7$Exercise.Courses;

IF OBJECT$\_$ID$($N$\text{'}$Chapter$7$Exercise.Instructors'$)$ IS NOT NULL

DROP TABLE Chapter$7$Exercise.Instructors;

CREATE TABLE Chapter$7$Exercise.Instructors

$($

InstructorId INT IDENTITY,

InstructorName NVARCHAR$(100)$ NOT NULL,

Office NVARCHAR$(50)$ NULL,

CONSTRAINT pk$\_$Instructors PRIMARY KEY$($InstructorId$)$

$)$;

CREATE TABLE Chapter$7$Exercise.Courses

$($

CourseId INT IDENTITY,

CourseNumber NVARCHAR$(10)$ NOT NULL,

CourseTitle NVARCHAR$(200)$ NULL,

InstructorId INT NULL,

CONSTRAINT pk$\_$Courses PRIMARY KEY$($CourseId$),$

CONSTRAINT fk$\_$Courses$\_$Instructors

FOREIGN KEY $($InstructorId$)$

REFERENCES Chapter$7$Excercise.Instructors$($InstructorId$)$

$)$;

SET IDENTITY$\_$INSERT Chapter$7$Exercise.Instructors ON;

$($CourseNumber$,$ CourseTitle, InstructorId$)$

VALES

$(1,$ 'Ralph Moore', 'Tiger $301\text{'})$;

SET IDENTITY$\_$INSERT Chapter$7$Excercise.Instructors OFF;

INSERT INTO Chapter$7$Exercise.Courses

$($CourseNumber$,$CourseTitle, InstructorId$)$

VALUES

$(\text{'}$CS$101\text{'},$ 'Instroduction to Database', $1)$;

$($CourseNumber$,$ CourseTitle, InstructorId$)$

VALUES

$(\text{'}$CS$102\text{'},$ 'Advanced T$-$SQL$\text{'},1)$;