Could you please answer the following question and explain it in the best way po

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

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.