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 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
Get step-by-step solutions from verified subject matter experts
