Question: Write SQL queries to answer the following questions: a. List the numbers of all sections of course ISM 3113 that are offered during the semester

Write SQL queries to answer the following questions:
a. List the numbers of all sections of course ISM 3113 that are offered during the semester "1-2015."
b. List the course IDs and names of all courses that start with the letters "Data."
c. List the IDs of all faculty members who are qualified to teach both ISM 3112 and ISM 3113.
d. Modify the query above in part c so that both qualifications must have been earned after the year 2005.
e. List the ID of the faculty member who has been assigned to teach ISM 4212 during the semester 11-2015.

Step by Step Solution

3.27 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

SQL queries a SELECT SectionNo FROM SectionT WHERE CourseID IS... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

613-CS-DB (1802).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!