Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Let us consider the following relational database. Professors(id, fName, IName, ssn, email) Students (id, Name, IName, dob, gpa, email) Teaches Courses (number, sectionNo, semester,

image text in transcribed 

Let us consider the following relational database. Professors(id, fName, IName, ssn, email) Students (id, Name, IName, dob, gpa, email) Teaches Courses (number, sectionNo, semester, creditHrs, title, profID) CompLanguages(studentID, complanguage) Enrolls(studentID, number, sectionNo. semester, courseGrade) UseGrading Schema(number, sectionNo, semester, cutoff, letterGrade) HasGradingCategoriess (category, weight, mumber, sectionNo, semester) Grading Activites (category, title, maxPoints) Submit(studentID, category, title, point) The primary key for each relation is underlined. The foreign keys for this database are as follows: the column profID of relation Teaches Courses that references table Professors. the column studentID of relation CompLanguages that references table Students, the column studentID of relation Enrolls that references table Students, the columns number, section No, semester of relation Enrolls that references table Teaches Courses, the columns number, sectionNo, semester of relation Use Grading Schema that references table TeachesCourses, the columns number, sectionNo, semester of relation HasGrading Categoriess that references table Teaches Courses, the column category of relation Grading Activites that references table HasGrading Categoriess. the column studentID of relation Submits that references table Students, and the columns category and tile of relation Submits that references table Grading Activites Task: Write exactly one SQL statement for the following question. Also, the query answers must not contain duplicates, but you should use the SQL keyword distinct only when necessary. Use ecLab.sql to test your code, and its output should be like the one listed here. Otherwise, your SQL code has a logic error(s). Q: Retrieve the course titles offered in Spring 2020, along with their professor's ID. Hints: It can be solved by using one input table. /*************Output*************** Course Title | Professor ID | | Biology I 50783 | Biology II 50783 Chemistry I 50123 Chemistry II 50123 Database I 87654 Database I Lab | 87654 | English I 09785 English II 09785 Calculus I 72121 Calculus I 71376 Calculus II 71376 | Calculus II 72121 12 rows in set (0.002 sec)

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

Step: 3

blur-text-image

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

Contemporary Business Mathematics with Canadian Applications

Authors: S. A. Hummelbrunner, Kelly Halliday, K. Suzanne Coombs

10th edition

133052311, 978-0133052312

More Books

Students also viewed these Finance questions