SQL for data management

Nov 9th, 2014
Steve1995
Category:
Programming
Price: $40 USD

Question description

This assignment requires you to take your extended design from Week 4 IP and add proper indexes, a function, and a stored procedure.  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.

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

Phase 4 SP.docx 

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: University of Maryland
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
pmallory
Dec 9th, 2016
" Totally impressed with results!! :-) "
mixedballz
Nov 30th, 2016
" excellent work as always thanks for the help "
Five Star Tutor
Nov 25th, 2016
" Outstanding Job!!!! "
kiln82
Nov 17th, 2016
" awesome work thanks "
darnay
Nov 8th, 2016
" The best tutor out there!!!! "
likeplum4
Nov 3rd, 2016
" Excellent work as usual "
kpcutie
Oct 12th, 2016
" Excellent job "
Joemoe
Oct 3rd, 2016
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1824 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors