Write an alter statement to make phone an alternate key

Assignment Help Basic Computer Science

Reference no: EM131219874

a. Write an ALTER statement to add the column Area Code to EMPLOYEE. Assume that Area Code is not required.

b. Write an ALTER statement to remove the column Area Code from EMPLOYEE.

c. Write an ALTER statement to make Phone an alternate key in EMPLOYEE.

d. Write an ALTER statement to drop the constraint that Phone is an alternate key in EMPLOYEE.

Reference no: EM131219874

Questions Cloud

Ethics-sustainability and social responsibility : UBS, a venerable Swiss banking institution with global business activities, experienced the significant implications that political factors can have on the bottom line. The U.S. government alleged that by advertising its "tax savings" advantages t..

Write insert statements to add the data : Write INSERT statements to add the data shown in Figure 1-30 to the DEPARTMENT table. Run these statements to populate the DEPARTMENT table. (Hint: Write and test an SQL script, and then run the script. Save the script as DBP-e12-WPC-InsertDEPARTM..

Considering early retirement : You have reached age 60 with a modest fortune of $3 million and are considering early retirement. How much can you spend each year for the next 30 years? Assume that spending is stable in real terms. The nominal interest rate is 10 percent and the in..

Explain the development of health insurance : In a two to three page paper, explain the development of health insurance in the United States. Include a brief discussion as to the current state of both traditional health insurance and managed care. Is traditional health insurance still a viabl..

Write an alter statement to make phone an alternate key : Write an ALTER statement to add the column Area Code to EMPLOYEE. Assume that Area Code is not required.

Customer shops at a local grocery store : Assume that a customer shops at a local grocery store spending an average of $350 a week, resulting in a retailer profit of $25 each week from this customer. Assuming the shopper visits the store all 52 weeks of the year, calculate the customer li..

Calculate the total number of units accounted : The Assembly Department of? Intuitive, Inc., manufacturer of? computers, had? 4,500 units of beginning inventory in? September, and? 3,000 units were transferred to it by the Production Department. The Assembly Department completed? 1,500 units durin..

Write a create table statement for the employee table : Write a CREATE TABLE statement for the EMPLOYEE table. Email is required and is an alternate key, and the default value of Department is Human Resources. Cascade updates but not deletions from DEPARTMENT to EMPLOYEE.

Determining the disaster recovery business : A disaster recovery business responds to calls from [potential] clients who have had a "disaster" damage their home - for example, a pipe burst and caused a flood, or the cat knocked over a halogen lamp causing fire damage in the living room, or a..

User Account

All Pages