تكلم مع الذكاء الاصطناعي
Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
النسخة 6الرقم المعياري الدولي: 0136086209Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
النسخة 6الرقم المعياري الدولي: 0136086209 تمرين 1
-Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2.
التوضيح
موثّق
موثّق
(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
لماذا لم يعجبك هذا التمرين؟
أخرى 8 أحرف كحد أدنى و 255 حرفاً كحد أقصى
حرف 255
