1. Change the Salary column in the Employee table to reject nulls. 2. Change the length of the CITY column in the Employee table to 50 characters. 3. Change the department name in the Department table to Administration for the department name entitled Admin and Records. 4. Add a department in the Department table. You choose the data for the new department. 5. Delete the new department you added in #4. 6. Add foreign key constraints to Assignment table. 7. Change the column name “Date_of_Birth” to “DOB” in Dependent table. 8. Create a new table structure named “dept_Locations” with “dept_no” and “location” fields. You also have to put primary and foreign key constraints so that this table is connected to “department” table. 9. Drop the new table you created in #8. 10.Create a new table named “employee_dependent” table with a SELECT statement. The new table will contain the following data: employee SSN, employee first and last name, employee address, dependent name, the relationship to employee. Note: You have to use SELECT statement. 11.Create an index named LNAMEINDEX based on the field (attribute) LNAME in employee table. 12.Create a view which contains the following information: employee SSN, employee first and last name, and project name assigned to each employee. You have to use 3 tables to create this view. 13.Create a database named “CBT”.
1. Change the Salary column in the Employee table to reject nulls.
2. Change the length of the CITY column in the Employee table to 50 characters.
3. Change the department name in the Department table to Administration for the department name entitled Admin and Records.
4. Add a department in the Department table. You choose the data for the new department.
5. Delete the new department you added in #4.
6. Add foreign key constraints to Assignment table.
7. Change the column name “Date_of_Birth” to “DOB” in Dependent table.
8. Create a new table structure named “dept_Locations” with “dept_no” and “location” fields. You also have to put primary and foreign key constraints so that this table is connected to “department” table.
9. Drop the new table you created in #8.
10.Create a new table named “employee_dependent” table with a SELECT statement. The new table will contain the following data: employee SSN, employee first and last name, employee address, dependent name, the relationship to employee. Note: You have to use SELECT statement.
11.Create an index named LNAMEINDEX based on the field (attribute) LNAME in employee table.
12.Create a view which contains the following information: employee SSN, employee first and last name, and project name assigned to each employee. You have to use 3 tables to create this view.
13.Create a
Trending now
This is a popular solution!
Step by step
Solved in 2 steps