Use the SQL_PRIMER_ch4p5,mwb file also found one this page
Your assignment is to produce the following queries. Five (5) points per query
Show all classes and their assigned instructors
This will be a simple inner join between the class and instructor entities
Which instructors are not assigned to teach any classes
This will be an outer join (convert inner join to an outer join). Show only the rows for unassigned instructors.
What is the total enrollment for the coming semester
How many classes is Larry Howard signed up to take
How many trainees are signed up to take Algebra
Which courses have no assigned classes
What to turn in
Modify the MWB file on this page to include VIEWs of your queries.
Turn in the modified MWB file
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|