Create a new database with the name Lab08Exercise. Use Lab08Exercise to accomplish the below tasks. Create...

 

Transcribed Image Text:

Create a new database with the name Lab08Exercise. Use Lab08Exercise to accomplish the below tasks. Create a table Faculty based on the following chart: Data type Constraints INT (6) Primary Key Last Name Varchar(15) First Name Varchar(15) Dept Char(3) Column Faculty_id Not NULL Dept Code Dept Name Not NULL Create a table Dept based on the following chart: Column Data type Char (3) Varchar(20) Constraints Primary Key Not NULL Add a new column Location to Dept table which has data type Char(7). Add a new FOREIGN KEY constraint to column Dept on table Faculty that refers to the column Dept Code on table Dept. Add ON DELETE CASCADE option. Increase Last Name column to 25 characters long Remove the column Location (the one added in Task #3 above) from Dept. Create a table course based on the following chart: Column Data type Constraints course Code Char (3) Primary Key course Name Varchar(20) Not NULL ). Add a new column Instructor_ID to course which has data type corresponding to Faculty. Faculty_ID . Add a new FOREIGN KEY constraint (named faculty_course_fk) to course Instructor_ID that refers to the column Faculty. Faculty_ID. Create a new database with the name Lab08Exercise. Use Lab08Exercise to accomplish the below tasks. Create a table Faculty based on the following chart: Data type Constraints INT (6) Primary Key Last Name Varchar(15) First Name Varchar(15) Dept Char(3) Column Faculty_id Not NULL Dept Code Dept Name Not NULL Create a table Dept based on the following chart: Column Data type Char (3) Varchar(20) Constraints Primary Key Not NULL Add a new column Location to Dept table which has data type Char(7). Add a new FOREIGN KEY constraint to column Dept on table Faculty that refers to the column Dept Code on table Dept. Add ON DELETE CASCADE option. Increase Last Name column to 25 characters long Remove the column Location (the one added in Task #3 above) from Dept. Create a table course based on the following chart: Column Data type Constraints course Code Char (3) Primary Key course Name Varchar(20) Not NULL ). Add a new column Instructor_ID to course which has data type corresponding to Faculty. Faculty_ID . Add a new FOREIGN KEY constraint (named faculty_course_fk) to course Instructor_ID that refers to the column Faculty. Faculty_ID. Create a new database with the name Lab08Exercise. Use Lab08Exercise to accomplish the below tasks. Create a table Faculty based on the following chart: Data type Constraints INT (6) Primary Key Last Name Varchar(15) First Name Varchar(15) Dept Char(3) Column Faculty_id Not NULL Dept Code Dept Name Not NULL Create a table Dept based on the following chart: Column Data type Char (3) Varchar(20) Constraints Primary Key Not NULL Add a new column Location to Dept table which has data type Char(7). Add a new FOREIGN KEY constraint to column Dept on table Faculty that refers to the column Dept Code on table Dept. Add ON DELETE CASCADE option. Increase Last Name column to 25 characters long Remove the column Location (the one added in Task #3 above) from Dept. Create a table course based on the following chart: Column Data type Constraints course Code Char (3) Primary Key course Name Varchar(20) Not NULL ). Add a new column Instructor_ID to course which has data type corresponding to Faculty. Faculty_ID . Add a new FOREIGN KEY constraint (named faculty_course_fk) to course Instructor_ID that refers to the column Faculty. Faculty_ID. Create a new database with the name Lab08Exercise. Use Lab08Exercise to accomplish the below tasks. Create a table Faculty based on the following chart: Data type Constraints INT (6) Primary Key Last Name Varchar(15) First Name Varchar(15) Dept Char(3) Column Faculty_id Not NULL Dept Code Dept Name Not NULL Create a table Dept based on the following chart: Column Data type Char (3) Varchar(20) Constraints Primary Key Not NULL Add a new column Location to Dept table which has data type Char(7). Add a new FOREIGN KEY constraint to column Dept on table Faculty that refers to the column Dept Code on table Dept. Add ON DELETE CASCADE option. Increase Last Name column to 25 characters long Remove the column Location (the one added in Task #3 above) from Dept. Create a table course based on the following chart: Column Data type Constraints course Code Char (3) Primary Key course Name Varchar(20) Not NULL ). Add a new column Instructor_ID to course which has data type corresponding to Faculty. Faculty_ID . Add a new FOREIGN KEY constraint (named faculty_course_fk) to course Instructor_ID that refers to the column Faculty. Faculty_ID.

Answer rating: 100% (QA)

It appears that youre trying to create tables for a database with specific constraints and relations... View the full answer