Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following database schema that keeps track of student enrollment in courses and the books adopted for each course: ENROLL (ID, Course#, Semester, Grade)

Consider the following database schema that keeps track of student enrollment in courses and the books adopted for each course: ENROLL (ID, Course#, Semester, Grade) BOOK_ADOPTION (Course#, Semester, Book_ISBN) TEXT (Book_ISBN, Book_Title, Publisher, Author) Answer the following questions: 1) Use SQL command(s) to add the textbook titled fundamentals of database systems. The book has 110112345 as an ISBN No. and published by McGraw Hill. Then adopt this book for the course# ES325 during the semester Spring 2011. 2) Put the Grade 85 to the student with ID 123456 in the Course# ES325 during the Semester Spring 2011. 3) Retrieve the book-title and course# for the courses offered during the semester "Spring 2011". 4) During 'Fall 2010', retrieve the average Grade for each course and the number of students who enrolled in these courses. 5) During 'Fall 2010', retrieve the sum of Grades for each student in all courses in which the student is enrolled.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

PC Magazine Guide To Client Server Databases

Authors: Joe Salemi

1st Edition

156276070X, 978-1562760700

More Books

Students also viewed these Databases questions

Question

LO1 Understand risk management and identify its components.

Answered: 1 week ago