Name CU_ID CUS NAME CUS_ZIP Make updates to below table structure. Custmer_T_StudentID Null Type NUMBER(10) VARCHAR2(25)...

 

Transcribed Image Text:

Name CU_ID CUS NAME CUS_ZIP Make updates to below table structure. Custmer_T_StudentID Null Type NUMBER(10) VARCHAR2(25) NUMBER(10) 1- Create table with above structure (Screen Prints Required) 2- Change table name to Customer_T_StudentID 3- Change CU_ID (column name) to CUS_ID 4- Change CUS_Name data_type VARCHAR2 25 to 255 5- Change CUS_ZIP data_type from Number(10) to Varchar2(10) 6- Add Constraint Primary Key to CUS_ID (column). 7- Add a Column CUS_STATES with Check constraint (MD, VA, DE, PA, NY) (Screen Prints Required) 8- Create a sequence / Insert record into the table 9- Modify CUS_Name in of recorded inserted in step 7. 10-Delete table data / Delete table structure Name CU_ID CUS NAME CUS_ZIP Make updates to below table structure. Custmer_T_StudentID Null Type NUMBER(10) VARCHAR2(25) NUMBER(10) 1- Create table with above structure (Screen Prints Required) 2- Change table name to Customer_T_StudentID 3- Change CU_ID (column name) to CUS_ID 4- Change CUS_Name data_type VARCHAR2 25 to 255 5- Change CUS_ZIP data_type from Number(10) to Varchar2(10) 6- Add Constraint Primary Key to CUS_ID (column). 7- Add a Column CUS_STATES with Check constraint (MD, VA, DE, PA, NY) (Screen Prints Required) 8- Create a sequence / Insert record into the table 9- Modify CUS_Name in of recorded inserted in step 7. 10-Delete table data / Delete table structure Name CU_ID CUS NAME CUS_ZIP Make updates to below table structure. Custmer_T_StudentID Null Type NUMBER(10) VARCHAR2(25) NUMBER(10) 1- Create table with above structure (Screen Prints Required) 2- Change table name to Customer_T_StudentID 3- Change CU_ID (column name) to CUS_ID 4- Change CUS_Name data_type VARCHAR2 25 to 255 5- Change CUS_ZIP data_type from Number(10) to Varchar2(10) 6- Add Constraint Primary Key to CUS_ID (column). 7- Add a Column CUS_STATES with Check constraint (MD, VA, DE, PA, NY) (Screen Prints Required) 8- Create a sequence / Insert record into the table 9- Modify CUS_Name in of recorded inserted in step 7. 10-Delete table data / Delete table structure Name CU_ID CUS NAME CUS_ZIP Make updates to below table structure. Custmer_T_StudentID Null Type NUMBER(10) VARCHAR2(25) NUMBER(10) 1- Create table with above structure (Screen Prints Required) 2- Change table name to Customer_T_StudentID 3- Change CU_ID (column name) to CUS_ID 4- Change CUS_Name data_type VARCHAR2 25 to 255 5- Change CUS_ZIP data_type from Number(10) to Varchar2(10) 6- Add Constraint Primary Key to CUS_ID (column). 7- Add a Column CUS_STATES with Check constraint (MD, VA, DE, PA, NY) (Screen Prints Required) 8- Create a sequence / Insert record into the table 9- Modify CUS_Name in of recorded inserted in step 7. 10-Delete table data / Delete table structure