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 SectionIdentifier, Semester, Year, Grade> for each course section that Smith has completed.

(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.

Computer Science & Information Technology

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

Computer Science & Information Technology

Briefly describe the difference between the Pen tool and the Curvature tool

What will be an ideal response?

Computer Science & Information Technology

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

Computer Science & Information Technology

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)

Computer Science & Information Technology