Question

STUDENT STUDENT_CODE INT STUDENT_FNAME VARCHAR(15) STUDENT_INITIAL VARCHAR(1) STUDENT_LNAME VARCHAR(20) STUDENT_GPA DECIMAL(3,2) STUDENT_DOB DATE STUDENT_PHONE VARCHAR(45) Indexes COURSE COURSE_CODE INT COURSE_NAME VARCHAR(45) COURSE_DATE VARCHAR(45) COURSE_ENROLLMENT INT COURSE_SECTION INT Indexes Write the SQL code to create the table structures for the entities shown in the figure. The structures should contain the attributes specified in the data model diagram. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key as indicated by the diagram. The fields in columns COURSE_ENROLLMENT, COURSE_SECTION should NOT accept NULL values. The values in COURSE_NAME attribute must be UNIQUE. Add the appropriate constraints to each table.

          STUDENT
STUDENT_CODE INT
STUDENT_FNAME VARCHAR(15)
STUDENT_INITIAL VARCHAR(1)
STUDENT_LNAME VARCHAR(20)
STUDENT_GPA DECIMAL(3,2)
STUDENT_DOB DATE
STUDENT_PHONE VARCHAR(45)
Indexes
COURSE
COURSE_CODE INT
COURSE_NAME VARCHAR(45)
COURSE_DATE VARCHAR(45)
COURSE_ENROLLMENT INT
COURSE_SECTION INT
Indexes
Write the SQL code to create the table structures for the entities shown in the figure.
The structures should contain the attributes specified in the data model diagram. Use
data types that are appropriate for the data that will need to be stored in each attribute.
Enforce primary key as indicated by the diagram. The fields in columns
COURSE_ENROLLMENT, COURSE_SECTION should NOT accept NULL values.
The values in COURSE_NAME attribute must be UNIQUE. Add the appropriate
constraints to each table.

STUDENT
STUDENTCODE INT
STUDENTFNAME VARCHAR(15)
STUDENTINITIAL VARCHAR(1)
STUDENTLNAME VARCHAR(20)
STUDENTGPA DECIMAL(3,2)
STUDENTDOB DATE
STUDENTPHONE VARCHAR(45)
Indexes
COURSE
COURSECODE INT
COURSENAME VARCHAR(45)
COURSEDATE VARCHAR(45)
COURSEENROLLMENT INT
COURSESECTION INT
Indexes
Write the SQL code to create the table structures for the entities shown in the figure.
The structures should contain the attributes specified in the data model diagram. Use
data types that are appropriate for the data that will need to be stored in each attribute.
Enforce primary key as indicated by the diagram. The fields in columns
COURSEENROLLMENT, COURSESECTION should NOT accept NULL values.
The values in COURSENAME attribute must be UNIQUE. Add the appropriate
constraints to each table.

Added by Jorge M.

Question

Please give Ace some feedback