5-38
Write SQL data definition commands for each of the following queries:
How w
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 208?
5-40
Write SQL queries to answer the following questions:
How many students are enrolled in Section 274 in the first semester of 208?
What are the numbers of the faculty members who are currently qualified to teach the course ISM 33?
Which faculty members have qualified to teach a course since 20? List the faculty ID, course, and date of qualification.
Share this:
FacebookX
