Problems and Exercises 1 through 9 are based on the class scheduling 3NF relations along...

Problems and Exercises 1 through 9 are based on the class scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.

Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types:

StudentID (integer, primary key)

StudentName (25 characters)

FacultyID (integer, primary key)

FacultyName (25 characters)

CourseID (8 characters, primary key)

CourseName (15 characters)

DateQualified (date)

SectionNo (integer, primary key)

Semester (7 characters)