The management of JustLEe Books has approved implementing a new commission policy and the benefits plan for account managers. The following changes need to be made to the existing database:

1- Two new columns must be added to the ACCTMANAGER table: one to indicate the commission classification assigned to each employee and another to contain each employee's benefits code. The commission classification column should be able to store integers up to a maximum value of 99 and be named Comm_id. The value of the Comm_id column should be set to a value of 10 automatically if no value is provided when a row is added. The benefits code column should also accommodate integer values up to a max of 99 and be named Ben_id.

2- A new table COMMRATE must be created to store the commission rate schedule and must contain the columns:

Comm_id: A numeric column similar to the one added to the ACCTMANAGER table.

Comm_rank: A character field that can store a rank name allowing up to 15 characters.

Rate: A numeric field that can store two decimal digits (such as .01 or .03)

 

3. A new table benefits,must be created to store available benefit plan options and must contain the following columns: Ben_id: A numeric column similar to the one added to the ACCTMANAGER tableBen_plan: A character field that can store a single character valueBen_provider: A numeric field that can store a three-digit number

Active: A character field that can hold a value of y or n

SophiaPretty

(5)

Status NEW Posted 16 Oct 2017 01:10 PM My Price 6.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer