Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I only need 8-9-10-11 thanks using sql Question 1 (5 marks) 1. Create a new table called CATEGORIES. The columns should be CatCode and CatDesc.
I only need 8-9-10-11 thanks using sql
Question 1 (5 marks) 1. Create a new table called CATEGORIES. 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. 2. Create a new table called WOKERS containing four columns: Emp#, Lastname, Firstname, and Job_class. 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 WOKERS 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 WOKERS table so that it allows storing a maximum width of two characters. 5. Delete the EndDate column from the WOKERS table. 6. Rename the WOKERS table as EMPS. 7. Create a new table called NOVEL: It will have the following columns: ISBN, Cost, Retail, and Category 8. Rename the new table PRICING_OF_BOOK. 9. Mark the Category column of the PRICING_OF_BOOK table as unused. Verify that the column is no longer available. Add some data into PRICING_OF_BOOK table. 10. Truncate the PRICING_OF_BOOK table, and then verify that the table still exists but no longer contains any data. 11. Delete the PRICING_OF_BOOK table permanently so that it isn't moved to the recycle binStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started