Question: Suppose you are given a relation grade points that provides conversion from letter grades in the takes relation to numeric scores; for example, an A

Suppose you are given a relation grade points that provides conversion from letter grades in the takes relation to numeric scores; for example, an “A” grade could be specified to correspond to 4 points, an “A−” to 3.7 points, a “B+” to 3.3 points, a “B” to 3 points, and so on. The grade points earned by a student for a course offering (section) is defined as the number of credits for the course multiplied by the numeric points for the grade that the student received.

Given the preceding relation, and our university schema, write each of the following queries in SQL. You may assume for simplicity that no takes tuple has the null value for grade.

a. Find the total grade points earned by the student with ID '12345', across all courses taken by the student.

b. Find the grade point average (GPA) for the above student, that is, the total grade points divided by the total credits for the associated courses.

c. Find the ID and the grade-point average of each student.

d. Now reconsider your answers to the earlier parts of this exercise under the assumption that some grades might be null. Explain whether your solutions still work and, if not, provide versions that handle nulls properly.

Step by Step Solution

★★★★★

3.50 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a SELECT sumcreditspoints FROM takes gradepoints WHERE ID 12345 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database System Concepts Questions!

The harmonic mean (HM) is defined as the number of values divided by the sum of the reciprocals of each value. The formula is For example, the harmonic mean of 1, 4, 5, and 2 is This mean is useful...

The economic dependency ratio is defined as the number of persons in the total population who are not in the workforce per 100 in the workforce. Since 1960, Baby Boomers in the workforce coupled with...

The economic dependency ratio is defined as the number of persons in the total population who are not in the workforce per 100 in the workforce. Since 1960, Baby Boomers in the workforce and a...

Do not answer if you cannot answer all of them. Problem 2. Answer 2.1-2.3 using university schema classroom (building, room number, capacity) department (dept name, building, budget) course (course...

You work as an analyst for Jokull Rafnkelsson; the manager of a branch of a local bank in Reykjavik, Iceland. The bank specializes in lending to the fishing industry. Your job is to analyze the...

based on the information below, how is Board Composition and Firm Performance affected? Abstract Corporate governance comprises of the policies and procedures that align a firm's activities with the...

based on the report below, how is Board Composition and Firm Performance affected in the retail and manufacturing industries? Abstract Corporate governance comprises of the policies and procedures...

Please read chapter 8 and answer the questions and see the (guide to answer number 3) For each case study, you will view the material as the student's teacher, read the information provided and write...

Please read chapter 8 and answer the questions and see the ( guide to answer number 3) For each case study, you will view the material as the student's teacher, read the information provided and...

It is becoming widely expected that interest rates will rise in the coming year. In recent weeks the 10 year US bond has risen from about 1.50% to 1.80%. Using the appendix for chapter 2 on Webster...

Cambria Winery in Santa Maria, California, has two departments: Fermenting and Pack-aging. Direct materials are added at the beginning of the fermenting process (grapes) and at the end of the...

What role does a warehouse play in geographic postponement of inventory?

1. As the owner, how would you manage social media that contains negative opinions about the bar/organization?

What happens to the body during each of the three stages of the stress reaction?

Let R = (A, B, C), and let r1 and r2 both be relations on schema R. Give an expression in SQL that is equivalent to each of the following queries. a. r1 r2 b. r1 r2 c. r1 r2 d. II AB(r1) 1 BC(r2)

Let R = (A, B) and S = (A, C), and let r(R) and s(S) be relations. Write an expression in SQL for each of the queries below: a. { | b ( r b = 17)} b. { | r

Show that, in SQL, all is identical to not in.

Dynamico is a startup company that is interested in recruiting dynamic executives from established companies. The Dynamico founders and venture capital investors recognize that Dynamico cannot...

Consider a retail firm with a net profit margin of 3.03%, a total asset turnover of 1.88, total assets of $43.6 million, and a book value of equity of $18.1 million a. What is the firm's current ROE?...

Drop down options: 1: Neither, she broke even. No. Yes. 2: More than. Less than. The same as. 3: The more premium her empolyer pays, the more coverage there is. Her employer only contributes to...