Find the id and the grade-point average of every student

Assignment Help Basic Computer Science

Reference no: EM131057939

Suppose you are given a relation grade points(grade, points), which provides a 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 above relation, and our university schema, write each of the following queries in SQL. You can 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 every student.

Reference no: EM131057939

Questions Cloud

How many outstanding shares will acquirer : Target Company is trading at $20 a share at the end of the year 2006 and has 1 million shares outstanding. Acquirer Corp. is trading at $50 a share and has 3 million shares outstanding. How many outstanding shares will Acquirer have if they are succe..

What is the required rate of return : Fee Founders has perpetual preferred stock outstanding that sells for $34.00 a share and pays a dividend of $3.00 at the end of each year. What is the required rate of return? Round your answer to two decimal places.

Share and is expected to pay annual dividends : The Border Crossing just paid an annual dividend of $4.20 per share and is expected to pay annual dividends of $4.40 and $4.50 per share the next two years, respectively. After that, the firm expects to maintain a constant dividend growth rate of 2 p..

Determine the number of solutions : Determine the number of solutions you will have for the system 4y+x=16 and y=4-x. Is it none, impossible to determine, indefinite or one.

Find the id and the grade-point average of every student : 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.

Use the payback decision rule to evaluate this project : Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 7 percent, and that the maximum allowable payback and discounted payback statistics for the pr..

Price of a child ticket and a senior ticket : The first day she sold 4 senior citizen tickets and 2 children's tickets for a total of $80.00. The 2nd day she received $145.00 for 5 senior citizen tickets and 7 children's tickets. What is the price of a child's ticket and a senior ticket?

The cart wheel plans to pay an annual dividend : The Cart Wheel plans to pay an annual dividend of $1.20 per share next year, $1.00 per share a year for the following two years, and then cease paying dividends altogether. How much is one share of this stock worth to you today if you require a 17 pe..

Find the highest salary of any instructor : Find all instructors earning the highest salary (there may be more than one with the same salary).

User Account

All Pages