Write a user-defined function that calculates a student gpa

Assignment Help Basic Computer Science
Reference no: EM131041670

This assignment requires you to take your extended design from Week 4 IP and add proper indexes, a function, and a stored procedure. Your changes will provide functionality used by the teachers for screens such as a grade book. Be sure any code is properly formatted and has appropriate comments.

Part 1: Function

Write a user-defined function (UDF) that calculates a student's GPA for a given time frame. Inputs are StudentId int, ClassStartDateStart datetime, and ClassStartDateEnd datetime. The output should be the student's GPA for all classes that were taken between ClassStartDateStart and ClassStartDateEnd. Also, supply the script to call this new function, passing it parameter values of your choice.

Part 2: Stored Procedure

Write the DDL script to make a stored procedure that returns data needed to display a grade book screen for a professor. The only input for the stored procedure is a ClassId. Outputs need to include student names and grades for all assignments as well as a calculated overall grade for the class for each student. Provide an example calling this new stored procedure, passing it parameter values of your choice. Include a screenshot of the output.

Part 3: Indexes

Provide a list of suggested indexes and the DDL script to create them. Include an explanation of the purpose of indexes and how you made your decision for the fields to include in your list of suggested indexes.

Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Upload your document to the Submitted Tasks.

Reference no: EM131041670

Troubleshooting and testing strategies

You must comment your code including comments at the beginning of each function that explains what the program does and comments for every line of code that explains what is

Calculate the pressure at the wall

A 20° inclined manometer attached to a piezometer opening is used to measure the pressure at the wall of airflow. If the reading is measured to be 4 cm of mercury, calculate

Design a suitable microchannel cooling system

Also, compare the temperature difference achievable with the microchannel design with a conventional design using water-forced convection cooling in a channel covering the c

How much electric power would be produced by these falls

Water flows over a waterfall, which is 120 m high, at a rate of 1.30E+6 kg/s. If half the potential energy of this water were converted into electric energy, how much electr

How many cities and towns there are in the united states

Estimate how many cubic miles of water flow out of the mouth of the Mississippi River each day. Do not look up any supplemental facts. Describe all assumptions you made in a

Cost of equity capital is closest

Suppose the cost of capital of the Gadget Company is 12 percent. If Gadget has a capital structure that is 60 percent debt and 40 percent equity, its before-tax cost of debt i

Program whose input is number n and output is square of n

Write a program whose input is the number n and whose output is the magic square of order n if n is odd. Implement a class MagicSquare with a constructor that constructs the

Requirements for a banking application

A bank account has an account number, an opening date and a balance. There are two types of accounts: checking and saving. An account must be at least either saving or check


Write a Review

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