business is ( Drew Johnson has been buying and selling furniture )
A detailed description of your business rules. include
-Constraints
-operation
-derivation
Picture for Example.
Section 2: Business Rules 1. 1.5. Constraints: 1.1. Relevant personnel will be trained to operate the database 1.2. Personnel must have approval from a manager before gaining access to the database. 1.3. Only managers with responsibilities tied closely to database management will have total access to the database. 1.4. Approval of the highest user rights must be granted directly from both the CEO and CIO. Sales Representatives and other associates will have limited access to the system database depending upon their roles and responsibilities. Two factor authentication is required for database access. 1.7. Sales Representatives and other approved associates require VPN in order to access the database remotely. 1.8. Purchase order number must be logged for all sales agreements and vendor purchases. 1.9. Inventory must be updated real-time to ensure customer satisfaction and help expedite shipping/receiving from suppliers when necessary. 1.10. The database is a valuable tool that must be protected. Only the database manager will have deletion privileges. Every change made to the database must be logged for audit purposes. 1.6. 2. Operations: 2.1. Uniform items are priced by design tier, which is set by upper management. 2.2. Employee salaries are determined by upper management. 2.3. Customers who play more televised games may receive a flat rate subtotal line discount upon contract renewal. 2.4. A quote must be created before a purchase agreement can be processed 3. 3.1. Derivations: Employees work in specific departments. 3.2. Some employees are hourly, some salary (both exempt and non exempt). 3.3. Number of contract renewals with a particular customer. 3.4. Number of uniform combinations per customer. Section 2: Business Rules 1. 1.5. Constraints: 1.1. Relevant personnel will be trained to operate the database 1.2. Personnel must have approval from a manager before gaining access to the database. 1.3. Only managers with responsibilities tied closely to database management will have total access to the database. 1.4. Approval of the highest user rights must be granted directly from both the CEO and CIO. Sales Representatives and other associates will have limited access to the system database depending upon their roles and responsibilities. Two factor authentication is required for database access. 1.7. Sales Representatives and other approved associates require VPN in order to access the database remotely. 1.8. Purchase order number must be logged for all sales agreements and vendor purchases. 1.9. Inventory must be updated real-time to ensure customer satisfaction and help expedite shipping/receiving from suppliers when necessary. 1.10. The database is a valuable tool that must be protected. Only the database manager will have deletion privileges. Every change made to the database must be logged for audit purposes. 1.6. 2. Operations: 2.1. Uniform items are priced by design tier, which is set by upper management. 2.2. Employee salaries are determined by upper management. 2.3. Customers who play more televised games may receive a flat rate subtotal line discount upon contract renewal. 2.4. A quote must be created before a purchase agreement can be processed 3. 3.1. Derivations: Employees work in specific departments. 3.2. Some employees are hourly, some salary (both exempt and non exempt). 3.3. Number of contract renewals with a particular customer. 3.4. Number of uniform combinations per customer
