Study the following simple university database and SQL statements
(a) Write SQL statement to create and populate SECTION table with referential constraint.
You need to show how to insert one tuple into the table.
(b) Write a SQL state
CMP 420/758 Database Systems
Final Exam Study Guide
Study based on the course handouts (hard copied; also available from the course web site)
Chapters 8 and 9 : Relational DB Design by
Due Date: October 29, 2015 (submit answers as hard copy)
[Q.1] Answer the following questions
(a) Explain the following query in English (based on company database)
SELECT FNAME, LNAME, SSN
WHERE NOT EXISTS (SEL