Create another table PART2. The fields and correspondent data types are: Field Data Type PID (primary key) CHAR(3), Not…

Create another table PART2. The fields and correspondent data types are: Field Data Type PID (primary key) CHAR(3), Not…

Question:

 

Transcribed Image Text:

Create another table PART2. The fields and correspondent data types are:
Field
Data Type
PID (primary key) CHAR(3), Not null
Pname
Color
Weight
Pcity
Quantity
DesignDate
VARCHAR(40)
VARCHAR(20)
NUMERIC(5,2)
VARCHAR(20)
INTEGER
DATE
ase name your own primary key constraint

Expert Answer:

Answer rating: 100% (QA)

It seems you re looking to create a SQL table based on the provided schema However you haven t asked
View the full answer