how can i get the solutions for the Hands-On Assignments and Advanced Challenge for chapter 3
blem 1AC Show all steps. R D Bookmark ON The management of Justl.ee Books has approved implementing a new commission policy and benefits plan for the account managers. The following changes need to be made to the existing database 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 int Comm-id. The value of the Comm. column should be set to a value of 10 automatically it 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. egers up to a maximum value of 99 and be named .A new table, COMMRATE, must be created to-store the commission rate schedule and must contain the following columns: Comm id: A numeric column similar to the one added to the ACCTMANAGER table Comm rank: A character feld that can store a rank name allowing up to 15 . Rate: A numenc fied tat can store decimal digs (such as .01 or A new table, BENEFITS, must be created to store the avalable benefit plan characters options and must contain the following columns .Ben id: A numeric column simlar to the one added to the ACCTMANAGER table Bon plan A character feld that can store a single character value . Ben provider: A numeric field that can store a three dgit integer Actve: A character teld that can hold a value of Y or N Required: Create the SQL statements to address the changes needed to support the new commission and benelas data 8 HOA Bookmark Show all steps: ON Problem Create a new table containing the category code and description for the categories of books sold by Justlee Books. The table should be called CATEGORY, and the columns should be CatCode and CatDesc. The CatCode column should store a maximum of 2 characters, and the CatDesc column should store a maximum of 10 characters. Step-by-step solution There is no solution to this problem yet Get help from a Chegg subject expert Ask an expert 8 9 HOA Bookmark Show all steps: ON Problem 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 Step-by-step solution There is no solution to this problem yet Get help from a Chegg subject expert Ask an expert 9 5 [A Bookmark Show all steps: OCH Problem 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. Step-by-step solution There is no solution to this problem yet. Get help from a Chegg subject expert Ask an expert ip 4HOA Bookmark Show all steps: ON Problem Modify the Job_class column of the EMPLOYEES table so that it allows storing a maximum width of two characters. Step-by-step solution There is no solution to this problem yet. Get help from a Chegg subject expert. Ask an expert lem 5HOA Show all steps: 0 ON Dt Bookmark Problem Delete the EndDate column from the EMPLOYEES table. Step-by-step solution There is no solution to this problem yet. Get help from a Chegg subject expert Ask an expert ip DA Bookmark Show all steps: D ON Problem Create a new table containing these four columns from the existing BOOKS table: ISBN, Cost, Retail, and Category. The name of the ISBN column should be ID, and the other columns should keep their original names. Name the new table BOOK PRICING. Step-by-step solution There is no solution to this problem yet. Get help from a Chegg subject expert Ask an expert 8HOA Bookmark Show all steps: ON Problem Mark the Category column of the BOOK PRICING table as unused. Verify that the column is no longer available. Step-by-step solution There is no solution to this problem yet. Get help from a Chegg subject expert. Ask an expert ap em 9HOA Bookmark Show all steps: O Problem Truncate the BOOK PRICING table, and then venty that the table still exists but no longer contains any data. : Step-by-step solution There is no solution to this problem yet. Get help from a Chegg subject expert. Ask an expert 0HOA [] Bookmark Show all steps. Problem Delete the BOOK_ PRICING table permanently so that it isn't moved to the recycle bin. Delete the JL EMPS table so that it can be restored. Restore the JL_EMPS table and verify that it's available again. Step-by-step solution There is no solution to this problem yet. Get help from a Chegg subject expert. Ask an expert
