Discuss with in your group to find the best normalized “City Jail” database
design to implement in Oracle database.
Write down all the SQL statements require to construct the entire City Jail
database. Execute all SQL queries in Oracle SQL developer 12c to implement
the “City Jail” database in Oracle 12c. The CREATE TABLE statements
should be created as a group.
Execute the following queries individually and provide your answers in the
attached template:
o Group member One:
Insert 5 different entries in each table. You can create fictitious
data to create those entries.
Add a column named Mail_flag to the CRIMINALS table. The
column should be assigned a data type CHAR (1).
Set the Mail_flag column to ‘N’ for all criminals who don’t
have a street address recorded in the database.
Change the phone number for a criminal to 7225659032.
Remove a specific criminal from the database. Make sure you
remove all the associated information relevant to that criminal.