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 ...




student submitted image, transcription available below
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


We have an Answer from Expert

View Expert Answer

Expert Answer



We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe