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.
|
Calculate the weights for source of funds
: Under what conditions can a company's current capital structure be used to calculate the weights for each source of funds?
|
|
Discuss the importance of work-related attitudes
: Discuss how understanding yourself is so important in being a good manager, and describe two methods to increase self-awareness. Discuss the importance of work-related attitudes. Describe what transformational leadership is and explain how managers c..
|
|
Understand the difference among coupon yield
: Demonstrate that you understand the difference among coupon yield, current yield, and yield to maturity with the following illustration for Morgan Stanley debt, par value of $1000: current price of $1032, coupon rate of 4.2%, issue date of Septemb..
|
|
Personal property insured under a homeowners
: James has his home and personal property insured under a Homeowners (special form)policy.The dwelling is insured for $120,000.The replacement cost of the home is $200,000.Indicate the extent to which each of the following losses would be covered unde..
|
|
Write a user-defined function that calculates a student gpa
: 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.
|
|
What is the maximum amount that the investor
: 1. An investment will produce an annual cash flow of $4000 for three years. The investor requires a 12% rate of return compounded annually. What is the maximum amount that the investor can pay and still earn the required rate of return?
|
|
Explain whether the ethical leaders at your current
: Explain whether the ethical leaders at your current or at a previous employer act/acted as positive or negative role models in their visible ethical actions? Give an example in your analysis. How are/were ethics communicated in this employment cultur..
|
|
Briefly explain the concept measurement in accounting
: "Measurement" is an important concept in accounting. Briefly explain the concept and explain the basis upon which accounting measurement has historically been undertaken. Discuss alternative measurement bases that have been proposed more recently
|
|
What is the best philosophical approach
: What is the best philosophical approach (capabilities, ethical, economic, corporate citizenship, or utilitarianism) underpinning corporate social responsibility and on what basis? Give an example in arguing your viewpoint.
|