Write SQL queries to answer the following questions: a. Which students are enrolled in Database and Networking?
Question:
Write SQL queries to answer the following questions:
a. Which students are enrolled in Database and Networking? (Use SectionNo for each class so you can determine the answer from the Registration table by itself.)
b. Which instructors cannot teach both Syst Analysis and Syst Design?
c. Which courses were taught in the first semester of 2008 but not in the second semester of 2008?
The class scheduling 3NF relations along with some sample data shown in Figure 6-10. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
Question Posted: