Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this is a introduction to database design question, i'm stuck. please help solve asap Subtle Emphasis D> N LZ Editing Dictate Editor Reuse Files Voice
this is a introduction to database design question, i'm stuck. please help solve asap
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To make updates to the table structure as described in the question follow the instructions provided ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started