Create a new table containing the four columns

Assignment Help Computer Engineering
Reference no: EM131843560

Assignment

1. 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.

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.

5. Delete the EndDate column from the EMPLOYEES table.

6. Rename the EMPLOYEES table as JL_EMPS.

7. 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.

8. Mark the Category column of the BOOK_PRICING table as unused. Verify that the column is no longer available.

9. Truncate the BOOK_PRICING table, and then verify that the table still exists but no longer contains any data.

10. 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

 

Reference no: EM131843560

Questions Cloud

Prepare the entries to record the disposal : Prepare the entries to record the disposal under each of the following separate assumptions.
Find the value of the f-test statistic : Given that s = 6.60 for women and s = 6.02 for men, find the value of the F-test statistic.
What is the payoff if the survey is conducted : Jerry Young is considering opening a bicycle shop in his hometown. Jerry can open a small shop, a large shop, or no shop at all.
How does enterprise resource planning affect feedback : All businesses confront specific and identifiable types of strategic challenges over time as they develop through stages.
Create a new table containing the four columns : Create a new table containing these four columns from the existing BOOKS table: ISBN, Cost, Retail, and Category.
How many combinations of survivors are there : Six workmen are on a sinking barge and there are only four life jackets. How many combinations of survivors are there?
What markup percentage must now be obtained : A buyer plans to purchase jackets at a 58% markup with a retail value of $18,500. If the buyer acquires 100 jackets at $54.75 each and retails them.
Mistake entering the data : What if you made a mistake entering the data, and in place of the final two entries, 48 and 63, you had accidentally entered the single number:
Determine the total amount that is used to reconcile : Determine the total amount that is used to reconcile the Bank balance ?What is the balance in the company's cash account after the reconciliation?

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd