Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed 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 bin

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions