You have designed and created tables for the City Jail database. These tables don€™t include any constraints. Review the information to determine what constraints you might need for the City Jail database. First, using the format in the following chart, create a list of constraints needed. Second, create and execute all the SQL statements needed to add these constraints. Follow these steps to create and alter the tables:
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.

Transcribed Image Text:

Column(s) Table Name Constraint Type Condition