Question

Create a Student table with the following column names, data types, and constraints: • ID - integer with range 0 to 65 thousand, auto increment, primary key • FirstName - variable-length string with max 20 chars, not NULL • LastName - variable-length string with max 30 chars, not NULL • Street - variable-length string with max 50 chars, not NULL • City - variable-length string with max 20 chars, not NULL • State - fixed-length string of 2 chars, not NULL, default "TX" • Zip - integer with range 0 to 16 million, not NULL • Phone - fixed-length string of 10 chars, not NULL • Email - variable-length string with max 30 chars, must be unique Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code. 539766 3055218 qx3zqy7 LAB ACTIVITY 3.8.1: LAB - Create Student table with constraints 1 -- Your SQL statements go here 2 Main.sql I 0/10 Load default template

          Create a Student table with the following column names, data types, and constraints:
• ID - integer with range 0 to 65 thousand, auto increment, primary key
• FirstName - variable-length string with max 20 chars, not NULL
• LastName - variable-length string with max 30 chars, not NULL
• Street - variable-length string with max 50 chars, not NULL
• City - variable-length string with max 20 chars, not NULL
• State - fixed-length string of 2 chars, not NULL, default "TX"
• Zip - integer with range 0 to 16 million, not NULL
• Phone - fixed-length string of 10 chars, not NULL
• Email - variable-length string with max 30 chars, must be unique
Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.
539766 3055218 qx3zqy7
LAB
ACTIVITY
3.8.1: LAB - Create Student table with constraints
1
-- Your SQL statements go here
2
Main.sql
I
0/10
Load default template

Create a Student table with the following column names, data types, and constraints:
• ID - integer with range 0 to 65 thousand, auto increment, primary key
• FirstName - variable-length string with max 20 chars, not NULL
• LastName - variable-length string with max 30 chars, not NULL
• Street - variable-length string with max 50 chars, not NULL
• City - variable-length string with max 20 chars, not NULL
• State - fixed-length string of 2 chars, not NULL, default "TX"
• Zip - integer with range 0 to 16 million, not NULL
• Phone - fixed-length string of 10 chars, not NULL
• Email - variable-length string with max 30 chars, must be unique
Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.
539766 3055218 qx3zqy7
LAB
ACTIVITY
3.8.1: LAB - Create Student table with constraints
1
– Your SQL statements go here
2
Main.sql
I
0/10
Load default template

Added by Lisa L.

Question

Please give Ace some feedback