Introduction
This sample Database for an Currency Exchange Company whose main business is to exchange money for its registered customers. Its an ideal scenario for all you Database Programmers to urge your hands on this sort of Organizational Database for practicing SQL queries and strengthen you command on SQL.
Activities:
Customers:
Customers use this system for fill up registration information. Due to security restrictions, customers cannot modify or delete their information once it’s entered within the system.
Front Desk Staff:
Front desk staffs use the system to register or verify customer’s profile. They have a permission to modify customer’s information and most importantly they will enter the transactions in the system.
Supervisor:
Supervisors will have full access to data stored within the database to unravel business issues and assist front desk staff to beat them. Moreover, they use the system to generate report for the management and accountants.
Manager/ Administrator:
Management/ Administrator uses the system to feature or modify information for every employee and to grant their access level to the system. He also uses the system to solve any unanticipated issues and to perform data mining and creating backup of the system in regular basis.