Suppose you are given a relation grade_points(grade, points) that 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 preceding relation, and our university schema, write each of thefollowing queries in SQL. You may assume for simplicity that no takes tuple has the null value for grade. Find the ID and the grade-point average of each student.

This is an object oriented programming question Draw the class diagram only The diagram should be well defined Describe every relation that they are one to many or not. Mr.Fayyaz is a milkman who is supplying milk to many customer. Each customer has its name CNIC Home_Address and phone number. Mr Fayyaz wants to keep the track of daily milk supply quantity and price. He also wants to monthly record of each customer. Customer could also login and use the milkman application to view its bill. Mr Fayyaz could see the total sales of each customer. The milk has two types buffalo milk and cow milk. Mr Fayyaz also want to maintain the record of workers in the application.   Define the classes (attributes, behaviors or function) Make getter or setter and constructor Define Generatebill() function in milkman class. Define viewbill() function in customer class.