Homework Assignment: ALTER TABLE Statements for the Homework Assignment: Enterprise Contracting Company Database

  • Due Apr 8, 2021 by 11:59pm
  • Points 100
  • Submitting a text entry box or a file upload
  • File Types txt and sql
  • Available Mar 29, 2021 at 12am - Apr 9, 2021 at 11:59pm
This assignment was locked Apr 9, 2021 at 11:59pm.

 

 

Submit a Text File with a SQL Extension.  The file should contain at least 5 ALTER Table Statements for the Homework Database.  The Collection of ALTER TABLE Statements should include at least one of the following

 

  1. ADD Clause
  2. Modify Clause
  3. CHANGE COLUMN Clause
  4. RENAME TO Clause. 

 

The file should contain the create table statements and insert into statements for your version of the Homework Database

 

 

Submit an SQL Text File for the SQL portion of this assignment.  An SQL Text File is a text file with a ".SQL" extension on the file name. 

  • The script should be well documented with comments

  • All the script should be placed in one file

  • The script should run continuously without errors

 

 

 

 

 

1617940799 04/08/2021 11:59pm