(Solved) : Write Sql Data Definition Command Following Query Would Remove Registration Table B Write Q36690588 . . .
a. Write a SQL data definition command for the following query:How would you remove the Registration Table?
b. Write a SQL command that will remove Lopez from the Studenttable.
c. Write the SQL query to answer the following question: What isthe name of the faculty member whose ID is 4756?
are based on the class scheduling is this figure are data for an ASSIGNMENT relation between faculty and salong with some sample data s ts a many-to-many relationshi StudentID (integer, primary key) StudentName (25 characters) FacultyID (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key) CourseName (15 characters) DateQualified (date) SectionNo (integer, primary key) Semester (7 characters) ,database description for each of the relations shown, DDL (shorten, abbreviate, or change any 1sing as needed for your SQL version). Assume the fol awing atibute data types: mes, STUDENT (StudentID, StudentName) QUALIFIED (FacultylD, CourselD, DateQualified) StudentlD StudentName FacultyID DateQualified CourseID Letersky Altvater Aiken Marra 2143 2143 3467 3467 4756 4756 ISM 3112 ISM 3113 ISM 4212 ISM 4930 ISM 3113 ISM 3112 9/1988 9/1988 9/1995 9/1996 9/1991 9/1991 54907 66324 70542 FACULTY (FacultylD, FacultyName SECTION (SectionNo, Semester, CourselD) FacultylD Semester CourselD 2143 3467 4756 Birkin Berndt Collins 2712 2713 2714 2715 1-2008 1-2008 1-2008 1-2008 ISM 3113 ISM 3113 ISM 4212 ISM 4930 REGISTRATION (StudentID, SectionNo, Semester) COURSE (CourselD, CourseName) Semester StudentD SectionNo CourselD CourseName ISM 3113 ISM 3112 ISM 4212 ISM 4930 Syst Analysis Syst Design Database Networking 38214 54907 54907 2714 2714 2715 2713 1-2008 1-2008 I-2008 -2008 6-11 Class scheduling relations (missing ASSIGNMENT) Show transcribed image text
Expert Answer
Answer to Write Sql Data Definition Command Following Query Would Remove Registration Table B Write Q36690588 . . .
OR