Question: You have designed and created tables for the City Jail database. These tables dont include any constraints. Review the information to determine what constraints you
1. First, drop the APPEALS, CRIME_OFFICERS, and CRIME_CHARGES tables constructed. These three tables are to be built last, using a CREATE TABLE command that includes all the necessary constraints.
2. Second, use the ALTER TABLE command to add all constraints to the existing tables. Note that the sequence of constraint addition has an impact. Any tables referenced by FOREIGN KEYs must already have the PRIMARY KEY created.
3. Third, use the CREATE TABLE command, including all constraints, to build the three tables dropped in the first step.

Column(s) Table Name Constraint Type Condition
Step by Step Solution
3.32 Rating (158 Votes )
There are 3 Steps involved in it
Assumes the following Constraint naming All constraints except NOT NULL constraints should be assigned a name Foreign key columns No NULL values should be allowed in FK columns except the ProbID colum... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c12123829_716108.pdf
180 KBs PDF File
1803_60b8c12123829_716108.docx
120 KBs Word File
