Design: SEC 30-Day Yield Calculator Overview We will implement the SEC 30-Day Yield Calculation in a new application called the “SEC 30-Day Yield Calculator”. This application, when run, will automatically connect to the database and display an input form (see illustration) that will allow the user to enter a Fund ID and As Of Date. The input form will have a Calculate button that, when clicked, will calculate the SEC Yield and display the results in the Results label. Detailed Operation When the Calculate button is clicked, the system will validate that the Fund ID and As Of Date are valid. Valid is defined as: • A Fund ID is considered valid if the input value is a valid SQL Server smallint. • An As Of Date is considered valid if the input value is a valid SQL Server datetime. If either of the fields is invalid, a message will be displayed informing the user that the field’s input value is incorrect. If both of the fields are valid, the system will calculate the yield and, if the calculation is successfully completed, display it in the Results label rounded to 5 decimal places. If the calculation is not successful, the results label should read “Failure:” with the details of the failure concatenated onto the message. The application should gracefully handle calculation on any values that could be stored in the database (without modifying the schema). However, the calculation should only be considered successful if all of the following are true: • The calculation period contains 30 non-null SEC Gross Income values • The calculation period contains 30 non-null Net Expense values • The calculation period contains 30 non-null Shares Outstanding values • The offering price on the As Of Date is non-null, non-zero. If any of the conditions are not met, a failure message should be displayed.
