5-38
Write SQL data definition commands for each of the following queries:
How would you add an attribute, Class, to the STUDENT table?
How would you remove the REGISTRATION table?
What would you need to take into account if you wanted to remove the COURSE table?
How would you change the FacultyName column from 25 characters to 40 characters?
5-39
Write SQL queries to answer the following questions:
Which students have an ID number that is less than 50000?
What is the name of the faculty member whose ID is 4756?
What is the smallest section number used in the first semester of 2018?
5-40
Write SQL queries to answer the following questions:
How many students are enrolled in Section 2714 in the first semester of 2018?
What are the numbers of the faculty members who are currently qualified to teach the course ISM 3113?
Which faculty members have qualified to teach a course since 2011? List the faculty ID, course, and date of qualification.
The post “SQL Data Definition and Query Commands” appeared first on around the clock essays.