This quiz is to be turned in at 2:05 PM.
All answers to this quiz should be based on a same database used in Homework 4 and Homework 5. In particular this database contains two tables: CourseEnroll with fields
Field | Type | Length |
---|---|---|
Year | int | 4 |
Term | char | 1 |
Number | int | 4 |
Section | char | 3 |
Enrollment | int | 4 |
CH | int | 4 |
which describes CSCI course offerings at UNCA over the last several years and CourseNamewith fields
Field | Type | Length |
---|---|---|
Number | int | 4 |
Title | char | 30 |
which gives the titles of CSCI courses. The CHfield in CourseEnrollis the number of credit hours associated with the course, and the Termfield of CourseEnrollcontains 1 for Spring, 3 for Summer, and 6 for Fall.
Write both relational algebra expressions andSQL SELECTstatements to find the following information:
Write SQL SELECTstatements to find the following information: