Home /
Expert Answers /
Computer Science /
2-20-lab-create-student-table-with-constraints-create-a-student-table-with-the-following-column-n-pa862
(Solved): 2.20 LAB - Create Student table with constraints Create a Student table with the following column n ...
2.20 LAB - 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, defauit - TX' - Zip integer with range 0 to 16 million, not NULL - Phone - fixed-length string of 10 chars, not NUtL - 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