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) 

Transcribed Image Text:

STUDENT (StudentlD, StudentName) QUALIFIED (FacultylD, CourselD, DateQualified) StudentName StudentID CourselD FacultyID DateQualified ISM 3112 ISM 3113 38214 Letersky Altvater 2143 9/1988 2143 54907 9/1988 9/1995 66324 70542 Aiken Marra 3467 ISM 4212 3467 4756 ISM 4930 ISM 3113 9/1996 9/1991 4756 ISM 3112 9/1991 FACULTY (FacultylD, FacultyName) SECTION (SectionNo, Semester, CourselD) FacultyID SectionNo FacultyName Semester CourselD ISM 3113 2143 3467 Birkin 1-2008 1-2008 2712 Berndt 2713 ISM 3113 1-2008 1-2008 4756 Collins 2714 ISM 4212 ISM 4930 2715 COURSE (CourselD, CourseName) REGISTRATION (StudentID, SectionNo, Semester) SectionNo CourselD CourseName StudentID Semester ISM 3113 ISM 3112 ISM 4212 Syst Analysis Syst Design Database Networking 38214 54907 54907 2714 1-2008 1-2008 1-2008 2714 2715 2713 ISM 4930 66324 1-2008