Let us consider the following relational database. Professors(id, fName, IName, ssn, email) Students (id,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Related Book For
Contemporary Business Mathematics with Canadian Applications
ISBN: 978-0133052312
10th edition
Authors: S. A. Hummelbrunner, Kelly Halliday, K. Suzanne Coombs
Posted Date:
Students also viewed these finance questions
-
In a FOUR-server model, what percentage of the time will a server be busy?
-
Create a scenario within a healthcare organization that would require an improvement team be established to help address the issue. Who do you think should be included as project participants? Why?...
-
A program file named foo exists in the current directory, but when we try to execute it by entering foo, we see the message foo: command not found. Explain how that can happen.
-
Solve the linear equation with the x-intercept method. Check your answer. Approximate the solution to the nearest thousandth whenever appropriate. -1-x = = 0
-
Choose a business that you would like to own and write a short description of that business, including the business name, the products or services it would sell, and the types of customers the...
-
A firm is considering buying a new machine and has to choose between two options. The specifications of each are given below: For each machine, assume a three-year MACRS (GDS) recovery property and...
-
What advantages are there in buying 100% of the capital of a limited share partnership?
-
Strategic analysis of operating income (continuation of 13-26). Refer to Exercise 13-26. 1. Calculate the operating income of Snyder Corporation in 2008 and 2009. 2. Calculate the growth,...
-
#7.) (Review - Similar Triangles) Given that AB ||DE, find the value of x. Round your nearest tenth. 11 B 7 E A X D 15
-
Question 11 (1 point) Listen Saved Under eminent domain, Mayor Cyrus can take Citizen Ella's land for any use he deems appropriate as long as he pays Ella just (fair) compensation. True False
-
An object rolls off a tabletop with a horizontal velocity v2,0 = 4 m/s. The table is at a height yo = 1.05 m, above the floor. Use a coordinate system with its origin on the floor directly beneath...
-
eBook Determining net income from net cash flows from operating activities Curwen Inc. reported net cash flows from operating activities of $224,400 on its statement of cash flows for the year ended...
-
Vectors u = 6(cos 601 + sin60), v = 4(cos 3151 + sin315), and w = -12(cos 3301 + sin330) are given. Use exact values when evaluating sine and cosine. Part A: Convert the vectors to component form and...
-
1. A 45 kg sled is pulled at a constant velocity across a horizontal slippery surface. If a force of 320.0 N is being applied to the sled rope at an angle of 28.0 degrees to the ground, what is the...
-
Condensed financial data of Flint Company for 2017 and 2016 are presented below. FLINT COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 2017 2016 Cash $1,790 $1,170 Receivables...
-
The slide F, of the mechanism shown in the figure, moves to the right with a constant horizontal speed of 1 m/s. The dimensions in the drawing are in mm. Determine the number of GDL of the mechanism...
-
A handrail, which weighs 120 N and is 1.8 m long. was mounted to a wall adjacent to a small set of steps (Figure P4.26). The support at A has broken, and the rail has fallen about the loose bolt at 8...
-
Define the following: asset retirement obligation retirement accretion promissory estoppel legally enforceable obligation obligating event
-
Define the following: impairment asset group traditional present value approach expected present value approach
-
Determine whether the following statements are true or false. a. Full cost companies do not book AROs. b. An oral agreement to dismantle equipment and restore the environment at the end of the...
Study smarter with the SolutionInn App