It consists of data-server and client software that runs on a network. The client software is installed on the user's workstation and the database is housed on Microsoft SQL Server. The two parts of the system are the Server and the Client. The Server portion is maintained by network staff, which usually includes a Database Administrator. SQL Server makes efficient use of networks.
Network traffic is reduced because database queries are processed at a centralized server.
The workstation application consists of log-on validation, data entry screens, and reports. The database resides on the server.