Home / Expert Answers / Computer Science / 3-8-lab-create-student-table-with-constraints-create-a-student-table-with-the-following-column-na-pa142

(Solved): 3.8 LAB - Create Student table with constraints Create a Student table with the following column na ...



3.8 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, 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. LAB 3.8.1: LAB - Create Student table with constraints Main.sql Load default template... 1 -- Your SQL statements go here



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