Database Reference
In-Depth Information
16.
16a.
State three (3) advantages of logical views.
{03}
16b.
State three (3) scenarios that could render a logical view
non-updateable.
{03}
16c.
Referring to the college database of Figure
26-13
, define
a view that “stores” computer science courses only
(assume that all computer science course-codes begin
with the acronym 'CS').
{03}
16d.
Assuming that the program code for Computer Science is
'P11SC, construct a second logical view for computer science
majors only. Your view must include all attributes of the
student record, the full descriptive name of the computer
science program, and the descriptive name of the hall
dormitory that the students reside in.
{05}
16e.
Provide the SQL statement that will create the
Student
table of Figure
26-13
, with its primary key and foreign keys
appropriately defined (assume that referenced tables have
been previously defined).
{06}
Figure 26-13.
Section of a College Database
