Show the student roster (use the format: , in a single column) for each section that Todd Smythe teaches. Identify the section using course number AND section number. (18 rows)
What will be an ideal response?
```
SELECT s.course_no Course, s.section_no Section,
st.last_name||', '||st.first_name Name
FROM section s, student st, enrollment e, instructor i
WHERE s.section_id = e.section_id
AND e.student_id = st.student_id
AND i.instructor_id = s.instructor_id
AND i.last_name = 'Smythe'
AND i.first_name = 'Todd'
```
You might also like to view...
Section 6.1. states that message passing is both time- and space-coupled – that is, messages are both directed towards a particular entity and require the receiver to be present at the time of the message send. Consider the case, though, where messages are directed towards a name rather than an address and this name is resolved using DNS. Does such a system exhibit the same level of indirection?
What will be an ideal response?
A named pipe is removed with the system call
A. close B. unlink
A(n) ________ query removes all the records in the underlying table of a query dataset that meet specific criteria
Fill in the blank(s) with correct word
There are three major kinds of controls: inbound, unbound, and calculated
Indicate whether the statement is true or false