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 properl

/in /by

We offer a 100% refund guarantee for all orders because we are highly confident that you will be delighted with the final outcome and that our paper will meet all your academic needs. In the unlikely event that you are dissatisfied with the end result, you have two options: you can request a revision, or we can promptly refund your entire payment.
When you choose to work with our essay writers, you can have absolute peace of mind knowing that your paper will be handled with utmost care. We will go above and beyond to ensure that every aspect is meticulously addressed, guaranteeing 100% customer satisfaction.
We are committed to delivering within the deadline, and in the rare event that we are unable to meet the deadline, we guarantee 100% compliance and offer a full refund. Additionally, if urgency is a concern, we are capable of crafting an essay in six hours or less. Our team of skilled authors is prompt and efficient in their work, ensuring your satisfaction.

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. 

 

 

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.