Chat with AI
Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Edition 6ISBN: 0136086209Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Edition 6ISBN: 0136086209 Exercise 1
-Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2.
Explanation
Verified
Verified
(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 < CourseName,
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.
(b) (Query) What are the prerequisites of the Database course?.
(c) (Query) Retrieve the transcript of Smith. This is a list of < CourseName,
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.
Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
