Question: HW 3 Table Creation & Management Queries (5 pts each) Instructions: Create the objects listed in the questions below. If you run into errors such

HW 3 Table Creation \& Management Queries (5 pts each) Instructions: Create the objects listed in the questions below. If you run into errors such as table already exists, elther drop the existing table and create a new one or Rename your table to something that makes sensel For example, If the name EMPLOYEES already exists in the DB, name you table something like: EMPLOYEE51. Be aware that you may need to drop several existing tables or rename them slightly to make them work. Please only write the syntax that will run the query. Do not indude output of any query. 1. Create a new Employees table. Include these fields: employee ID, first and last name, hire date, and salary. Be sure to use appropriate datatypes and field sizes when appilicable. 2. This time create a table called Students (or something like students) The table syntax needs to Include a unique ID field, first and last name fields and at least 2 other fields that describe the student. This could be attributes like enrollment date, major, current GPA. 3. Ater your students table to add a new column called date of birth. Be sure to use the approprlate datatype. 4. Write a query that will remove the column date of Birth from your students table. 6. Write a query that will show the data dictionary of the Students table you created. 7. Write a query that will change the name of your employees table to laborers. 8. Write a query that will temporarly remove the table laborers from the database. 9. Write a query that will make the table laborers avallable again. 10. Write a query that will permanently delete the table laborers
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
