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

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Potential business owner in the hoomaflopper industry

Decision Analysis Problem: You are a potential business owner in the hoomaflopper industry. You have hired Dustin R. Mopps as your industry insider to help you decide which businesses to focus on potentially buying.

  Design a network using either a single lan

Green foods has 5 canteens and each canteen has a manger and an assistant. Each staff will be assigned a PC and all PC will be linked together and have internet access. Design a network using either a single LAN, 5 LANs or 5 VLANs? Present all yo..

  Describe the fields and options associated with user account

Workgroup networks are small. Domain networks are larger. List at least three other distinctions found in a comparison of workgroups and domains.

  Several telephony technologies currently available

2. Based on your research, write an 6-8 page paper that researches the concept of internet telephony, as well as providing an analysis and comparison of several telephony technologies currently available.

  Categorize each of them into the area

During the Sarbanes-Oxley audit of a financial services company, you note the following issues. Categorize each of them into the area to which they belong: IT change management, logical access to data, and IT operations.

  What are the basic steps and components

What are the basic steps and components needed to evaluate submitted proposals?

  Assignment on creating a use case

Refer to the RMO CSMS marketing subsystem shown in Figure 3-11 on page 79-80 of the textbook. Write a two to three (2-3) page paper in which you:

  Show the set of positive powers

Let S show the set of positive powers of 3 , i.e. S = {3, 9, 27, 81,...}. Find if S and N(Natural Numbers) are equipotent. Justify your answer.

  Successful technological innovations

Many successful technological innovations originated in small start-up organizations, while others originated in large, well-established organizations. Successful technological innovations

  Explain what is meant by data validation

(TCO 7) (a) Explain what is meant by data validation and discuss why it is important in programming.

  Class that tests all the methods in the class

Write a test program for each class that tests all the methods in the class.

  How vulnerable do think the united states is to such attack

How would the actions of a hostile nation be any different than the actions of a hostile (competing) foreign company?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd