• Create the SQL Script for the following entity:
  • Give the script the following name: DBMS110_M04Quiz_LastNameFirstName (where LastName is your last name and FirstName is your first name). Your instructor will grade this question.
  • sup_id will be the primary key.
  • Use the following tutorial to upload your script: How to download your script

    Actions

  • Save and run the script. (Note that you won't be able to run the script multiple times; once you have created a table, it already exists in the database. To create the table again or run the script again, the table must be dropped.)
  • Submit your quiz after completing the question and uploading your script.

Create the SQL Script for the following entity: o Give the script the following name: DBMS110_M04Quiz_LastNameFirstName (where LastName is your last name and FirstName is your first name). Your instructor will grade this question. SUPPLIERS TABLE Column sup_id sup_name contact_name Data Type Number(15) Varchar2(30) Varchar2(50) Description Supplier ID that does not hold NULL value Supplier Name that does not hold NULL value Agent Contact Name o sup_id will be the primary key. o Use the following tutorial to upload your script: How to download your script o Save and run the script. (Note that you won't be able to run the script multiple times; once you have created a table, it already exists in the database. To create the table again or run the script again, the table must be dropped.) o Submit your quiz after completing the question and uploading your script