Question: Please create the tables and add all the data to the tables so I can directly copy it to mysql developer because I already have
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 maximum of 99 and be named Ben_id 2. Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The table name should be EMPLOYEES. The Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldn't be padded if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five-digit number. Use column sizes you consider suitable for the Firstname and Lastname columns. 3. Add two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment for each employee, and its default value should be the system date The second column, named EndDate, contains employees' date of termination. 4. Modify the Job_class column of the EMPLOYEES table so that it allows storing a maximum width of two characters. This is a MYSOL QUESTION PLEASE CREATE THE TABLES AS ASKED
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
