Over the next few pages, we shall present some essential aspects of SQL Server development. We'll see how we can work with different data sources, structure them, and present them through the report engine. We'll see how we can display the data using the web user interface.
Let's analyze the following use case and see how we can use SQL Server to implement our solution.
Reliable Payroll Pro Inc. (RPP) is a payroll processor for a large number of small- to medium-sized companies. The core business workflow may be described in the following steps:
Collect the employee and payroll data from the client.
Process data to produce the following:
Tax forms and checks
Payroll checks and direct deposit requests
Client reports
Send tax forms and payments to the respective government agencies.
Send payroll checks to the employees and submit direct deposits.
Bill the client for the following:
Payments issued on the client's behalf
RPP services