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

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

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 General Management Questions!