... the Sales Department will be responsible for entering all details of new cleaning products salesman and new products. 2. An Accounts clerk will have special responsibility for the commission system. 3. The Accounts clerk will enter each month the sales of each product, giving quantity sold and gross sales value (i.e. quantity X cover price). 4. Every 6 months, the Accounts clerk will produce the Commission reports for each cleaning products salesman. This will show the commission that has been earned in the previous 6 months. A payment is then recorded and a cheque issued to each cleaning products salesman to whom commission is due, together with the Commission statement showing sales details, and the statement from the Accounts system the total amount due. Database specification Menu structure The many functions of the Commission System will be accessed by means of a front-end menu, which will have the following structure. The data model There ...

See this essay or coursework document in full right now