this is a introduction to database design question, i'm stuck. please help solve asap Subtle Emphasis D>

this is a introduction to database design question, i'm stuck. please help solve asap

 

Transcribed Image Text:

Subtle Emphasis D> N LZ Editing Dictate Editor Reuse Files Voice Editor Reuse Files Q4 [Pts 25] Make updates to below table structure. Picture A Name CU ID CUS NAME CUS ZIP CUS Information T Null Type NUMBER(10) VARCHAR2(25) NUMBER(10) Picture B CUS Information _T Null Type Name CUS_ID CUS NAME CUS ZIP CUS PHONE NUMBER(10) VARCHAR2(255) VARCHAR2(10) VARCHAR2(10) 1- Create a table in picture A [Pts 3] 2- Modify the table to picture B 1. Change table name to Customer T[Pts 2] 2. Change CU_ID (column name) to CUS_ID [Pts 3] 3. Change CUS Name data type VARCHAR2 25 to 255 [Pts 2] 4. Change CUS ZIP data type from Number(10) to Varchar2(10) [Pts 2] 5. Query to show table structure [Pts 2] 6. Add CUS_PHONE data type Varchar(10) [Pts 2] 7. Add Constraint Primary Key to Cus ID (column) [Pts 3] 8. Disable Primary Key on Cus ID [Pts 2] 9. Delete/Drop Primary Key on Cus. JD [Pts 2] 10. Show table structure [Pts 2] + 50% Focus Subtle Emphasis D> N LZ Editing Dictate Editor Reuse Files Voice Editor Reuse Files Q4 [Pts 25] Make updates to below table structure. Picture A Name CU ID CUS NAME CUS ZIP CUS Information T Null Type NUMBER(10) VARCHAR2(25) NUMBER(10) Picture B CUS Information _T Null Type Name CUS_ID CUS NAME CUS ZIP CUS PHONE NUMBER(10) VARCHAR2(255) VARCHAR2(10) VARCHAR2(10) 1- Create a table in picture A [Pts 3] 2- Modify the table to picture B 1. Change table name to Customer T[Pts 2] 2. Change CU_ID (column name) to CUS_ID [Pts 3] 3. Change CUS Name data type VARCHAR2 25 to 255 [Pts 2] 4. Change CUS ZIP data type from Number(10) to Varchar2(10) [Pts 2] 5. Query to show table structure [Pts 2] 6. Add CUS_PHONE data type Varchar(10) [Pts 2] 7. Add Constraint Primary Key to Cus ID (column) [Pts 3] 8. Disable Primary Key on Cus ID [Pts 2] 9. Delete/Drop Primary Key on Cus. JD [Pts 2] 10. Show table structure [Pts 2] + 50% Focus