DAT/380 Week 3 LAB 3.11 – Create Student table with constraints

$ 5

DAT/380 Week 3 LAB 3.11 – Create Student table with constraints

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

994 in stock

SKU: DAT380WK3L3P11 Category:

Description

DAT/380 Week 3 LAB 3.11 – Create Student table with constraints

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

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

You may also like…