Question: Modify the EMPLOYEE table so that JobClass column can store data up to two characters only. Modify the EMPLOYEE table so that EndDate column is

  1. Modify the EMPLOYEE table so that JobClass column can store data up to two characters only.

  1. Modify the EMPLOYEE table so that EndDate column is deleted

  1. Create a new Table BOOK_PRICING containing 3 columns ISBN, Cost, CatCode by selecting these columns from the existing BOOK table.

  1. In the Book_Pricing Table, add the primary key constraint on the field ISBN. Make sure to give a name to the constraint.

  1. In the Book_Pricing Table, add the foreign key constraint on the field CatCode which reference CATEGORY table.

  1. In the Book_Pricing Table, drop the foreign key constraint that you created in above question.

Step by Step Solution

★★★★★

3.37 Rating (141 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 Modify the EMPLOYEE table to limit the JobClass column to two characters sql ALTER TABLE EMPLOYEE ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Q:

For your survey project, develop an introductory statement (ethics statement) that you would include on a letter of introduction or as part of a survey questionnaire. There should be a minimum of...

Q:

List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...

Q:

1. Charles asks you, What is an entity, a table, a field, and a record? He also wants to know the different between primary key, candidate keys, foreign keys, secondary keys, and combination keys. 2....

Q:

Modify the Job_class column of the EMPLOYEES table so that it allows storing a maximum width of two characters.

Q:

Using Microsoft Project, build a project schedule based on the following scenario. Print the Gantt chart. If required by your teacher, also print the Network Diagram (i.e., a PERT chart). In the...

Q:

Your finished work should be submitted in Microsoft word format, i.e., .doc file, and is named as required. For Example, if Betty Jones and John Smith finish project 2 individually, they should be...

Q:

The Poll table in Exercise 37.13 contains only one question. Suppose you have a Poll table that contains multiple questions. Write a JSP that reads all the questions from the table and display them...

Q:

After the annual dog show in which the Barkley Dog Training Academy awards points to each participant, the academy assigns a status to each dog based on the criteria in Table 6-1. The academy needs a...

Q:

In the last chapter you added and modified some queries for Kelly's Boutique. She would now like you to create some new forms. Make the following changes for Kelly using the chl l-03_student_name...

Q:

Use Excel to prepare the following budgets for March 2020: 1. Sales budget 2. Production budget 3. Direct materials purchases budget 4. Direct labor cost budget 5. Factory overhead cost budget 6....

Q:

1. Assume that the hydrocarbonlike interior cavity of the SDS micelle has a diameter of - 3 nm and that it contains three solubilized benzene molecules. Calculate the "local" concentration of benzene...

Q:

When the single subject program is working, extend it to calculate and output largest, highest, lowest, and average marks for a single student with six subjects studied by a student.

Q:

Part (a) of the figure below shows a symbolic representation of an electric circuit called an amplifier. The input to the amplifier is the voltage vi and the output is the voltage vo. The output of...

Q:

Exponents are normally stored in excess-N notation. Explain excess-N notation. If a number is stored in excess-31 notation and the actual exponent is 2 +12 , what value is stored in the computer for...

Q:

Repeat Programming Project 15.7 assuming a directed network. Programming Project 15.7 Create a limited airline scheduling system that will allow a user to enter city to-city connections and their...

Q:

The level of cholesterol in the blood for all men aged 20 to 34 follows a Normal distribution with mean M =188 milligrams per deciliter (mg/dl) and standard deviation M = 41 mg/dl. For 14-year-old...

Q:

Part 1: for a highly addictive substance such as cocaine, could the market demand for it ever be perfectly inelastic at all prices? Explain. Part 2: why do economists measure profit differently from...

Q:

Required:Compute the DuPont ratios (profit margin, diset turnovect and financal leverage ratiou) for Whalmay and Target given these numbers for 2012-2020. Oneck your numbers to maive sure that Frofit...

Q:

Briefly explain Chebyshevs theorem and its applications.

Q:

As mentioned in Exercise 7.33, among college students who hold part-time jobs during the school year, the distribution of the time spent working per week is approximately normally distributed with a...

Q:

Recent uncertain economic conditions have forced many people to change their spending habits. In a recent telephone poll of 1000 adults, 629 stated that they were cutting back on their daily...

Q:

Multiple Choice Questions 1. Which of the following is a criterion that must be met in order for an item to be recognized as an intangible asset? a. The item's fair value can be measured reliably. b....

Q:

Quantacc Company began operations on January 1, Year 1, and uses IFRS to prepare its financial statements. Quantacc reported net income of $100,000 in Year 5 and had stockholders' equity of $500,000...

Q:

This problem is comprised of three parts. Part A. Fields Company sells a building to Victory Finance Company. The selling price of the building is $500,000, which approximates its fair value, and the...