Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3 . 8 LAB - Create Student table with constraints Create a Student table with the following column names, data types, and constraints: ID -
LAB Create Student table with constraints
Create a Student table with the following column names, data types, and constraints:
ID integer with range to thousand, auto increment, primary key
FirstName variablelength string with max chars, not NULL
LastName variablelength string with max chars, not NULL
Street variablelength string with max chars, not NULL
City variablelength string with max chars, not NULL
State fixedlength string of chars, not NULL, default TX
Zip integer with range to million, not NULL
Phone fixedlength string of chars, not NULL
Email variablelength string with max chars, must be unique
Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started