Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2.
What will be an ideal response?
(a) (Query) List the names of all students majoring in Computer Science.
(b) (Query) What are the prerequisites of the Database course?
(c) (Query) Retrieve the transcript of Smith. This is a list of
(d) (Update) Insert a new student in the database whose Name=Jackson,
StudentNumber=23, Class=1 (freshman), and Major=MATH.
(e) (Update) Change the grade that Smith received in Intro to Computer Science section
119 to B.
You might also like to view...
________ refers to the control that is selected and currently being acted upon
Fill in the blank(s) with correct word
Briefly describe the difference between the Pen tool and the Curvature tool
What will be an ideal response?
User ________ are defined as a default set of capabilities assigned to built-in domain local groups that define what members of these groups can and cannot do on the network
Fill in the blank(s) with correct word
With faster data speeds and higher-resolution screens, smartphones and tablets are becoming a favorite way to watch TV shows, movies, or video clips.
Answer the following statement true (T) or false (F)