Create the SQL statements needed to create the following tables and relationships. Please note the primary and foreign keys, nullable and non-nullable fields, and the data types. Look at page 254, figure 6-6 for an example of what is needed. On page 253, figure 6-5 gives a more general syntax of the create table statement needed for this assignment. You also may use MySQL Workbench to help create these statements for you. Please submit the SQL statements.

STUDENT STUDENT ID INT N STUDENT _NAME VARCHAR(150) NN REGISTRATION STUDENT_ID INT N CAMPUS-ADDRESS VARCHAR (400) NN GRADE CHAR(1) NN MAJOR VARCHAR(45) NN Indexes 0 0 INSTRUCTOR INSTRUCTOR_ID INT N NAME VARCHAR( 150) NN Oo COURSE COURSE_ID CHAR(6) N TITLE VARCHAR( 100) NN LOCATION VARCHAR(45) INSTRUCTORINSTRUCTOR ID INT - 0 0