Question: The database will be named WPC and will contain the following four tables: DEPARTMENT (DepartmentName. BudgetCode. OfficeNumber. Phone) 1. Write a CREATE TABLE statement for

 The database will be named WPC and will contain the following

The database will be named WPC and will contain the following four tables: DEPARTMENT (DepartmentName. BudgetCode. OfficeNumber. Phone) 1. Write a CREATE TABLE statement for the DEPARTMENT table. 2. Write an AL TER statement to add the column AreaCode to EMPLOYEE Assume that AreaCode is not required. 3. Write an AL TER statement to make Phone an alternate key in EMPLOYEE. 4. Write an UPDATE statement to change the phone number of employee with EmployeeNumber 11 to 360-287-8810. 5. Write an UPDATE statement to change the department of employee with EmployeeNumber 5 to Finance. 6. Write an SQL statement to create a view named EmployeePhoneView that shows the values of EMPLOYEE.LastName as EmployeeLastName, EMPLOYEE.FirstName as EmployeeFirstName, and EMPLOYEE. Phone as EmployeePhone. Write one DELETE statement that will delete alt data for project "2013 Q3 Product Plan" and all of its rows in ASSIGNMENT

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!