Reference no: EM131652580
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