Could you please answer the following question and explain it in the best way po
ID: 645440 • Letter: C
Question
Could you please answer the following question and explain it in the best way possible on how to go about solving it.
Q1. The following questions are based on a database schema described below. The keys are underlined. Assume there are no indices in the database.
Student(Name, StudentNumber, Class, Major)
Course(CourseName, CourseNumber, CreditHours, Department)
Prerequisite(CourseNumber, PrerequisiteNumber)
Section(SectionIdentifier, CourseNumber, Semester, Year, Instructor)
Grade_Report(StudentNumber, SectionIdentifier, Grade)
a) Write an SQL query for the following:
Explanation / Answer
it is better to use E-Rdiagrams
and I suggest to use Oracle which is best relational schema..