Details
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
Additional Information
| Special Price | $3.00 |
|---|
Check items to add to the cart or select all
-
DAT/380 Week 3 LAB 3.10 - Create Horse table with constraints
Add to WishlistRegular Price:
Special Price
-
DAT/380 Week 3 LAB 3.12 - Create LessonSchedule table with FK constraints
Add to WishlistRegular Price:
Special Price
-
-
-
-
DAT/380 Week 3 LAB 3.16 - Select horses with logical operators
Add to WishlistRegular Price:
Special Price
You have no items in your shopping cart.
