In Section A, students need to develop CREATE TABLE statements for each table listed. The listing indicates DEFAULT column values when applicable. The listing Coding key for selected columns is provided only to help students visualize what type of data will be entered in selected code columns. This information will be a valuable reference for performing queries in later chapters. In Section B, students need to use the ALTER TABLE command to make the requested table modifications.

7 City Jail 5 - Notepad File Edit Format View Help DROP TABLE criminals CASCADE CONSTRAINTS; DROP TABLE crimes CASCADE CONSTRAINTS; CREATE TABLE criminals (criminal_id NUMBER(6), last VARCHAR2(15), first VARCHAR2(10) street VARCHAR2(30), city VARCHAR2(20), state CHAR(2) zip CHAR(5), phone CHAR(18), v_status CHAR(1), DEFAULT 'N'), P status CHAR) DEFAULT NY); CREATE TABLE crimes (crime_id NUMBER criminal_id NUMBER(6) classification CHAR(1), date_charged DATE, Status CHAR(2), hearing, date DATE, appeal_cut date DATE); ALTER TABLE Crimes MODIFY (classification DEFAULT U'); ALTER TABLE crimes ADO (date_recorded DATE DEFAULT SYSDATE); ALTER TABLE criminals ADD CONSTRAINT criminals_1d_pk PRIMARY KEY (criminal_id); ALTER TABLE criminals ADO CONSTRAINT criminals_vstatus_ck CHECK (v_status IN('Y', N')); ALTER TABLE criminals ADD CONSTRAINT criminals_pstatus_ck CHECK (P_status IN('Y, 'N')); ALTER TABLE crises ADD CONSTEASUT crimes_id_pk PRIMARY KEY (crise_id); ALTER TABLE Crities ADO CONSTRAINT Ches_class_ck CHECK (classification INCF, 0,333 ALTER TABLE cines City Jail 5 - Notepad File Edit Format View Help state CHAR(2), zip CHAR(5), phone CHAR(10), v_status CHAR(1) DEFAULT 'N', P_status CHAR(1) DEFAULT 'N' ); CREATE TABLE crimes (crime_id NUMBER(9), criminal_id NUMBER(6), classification CHAR(1), date_charged DATE, status CHAR(2) hearing date DATE appeal cut_date DATE) ALTER TABLE trim MODIFY (classification DEFAULT 'U'); ALTER TABLE crimes ADO (date_recorded DATE DEFAULT SYSDATE); ALTER TABLE criminals ADD CONSTRAINT criminals id_pk PRIMARY KEY (criminal_id); ALTER TABLE criminals ADD CONSTRAINT criminals_vstatus_ck CHECK (_status IN('Y', 'N')); ALTER TABLE criminals ADD CONSTRAINT criminals_pstatus_ck CHECK (p_status IN('Y', 'N')); ALTER TABLE crimes ADO CONSTRAINT crimes_id_pk PRIMARY KEY (crime_id); ALTER TABLE crimes ADO CONSTRAINT crimes_class_ck CHECK (classification INCE, "M", '0', 'U')); ALTER TABLE crimes ADO CONSTRAINT crimes_status_ck CHECK (status INCL', 'CA', 'IA >>> ALTER TABLE Crimes ADD COUSTRAINT crimes criminalid_fk FOREIGN KEY (criminal id) REFERENCES criminals(criminal_id); ALTER TABLE des MODIFY (criminald NOT NULL); Type here to search o 3 c 7 City Jail 5 - Notepad File Edit Format View Help DROP TABLE criminals CASCADE CONSTRAINTS; DROP TABLE crimes CASCADE CONSTRAINTS; CREATE TABLE criminals (criminal_id NUMBER(6), last VARCHAR2(15), first VARCHAR2(10) street VARCHAR2(30), city VARCHAR2(20), state CHAR(2) zip CHAR(5), phone CHAR(18), v_status CHAR(1), DEFAULT 'N'), P status CHAR) DEFAULT NY); CREATE TABLE crimes (crime_id NUMBER criminal_id NUMBER(6) classification CHAR(1), date_charged DATE, Status CHAR(2), hearing, date DATE, appeal_cut date DATE); ALTER TABLE Crimes MODIFY (classification DEFAULT U'); ALTER TABLE crimes ADO (date_recorded DATE DEFAULT SYSDATE); ALTER TABLE criminals ADD CONSTRAINT criminals_1d_pk PRIMARY KEY (criminal_id); ALTER TABLE criminals ADO CONSTRAINT criminals_vstatus_ck CHECK (v_status IN('Y', N')); ALTER TABLE criminals ADD CONSTRAINT criminals_pstatus_ck CHECK (P_status IN('Y, 'N')); ALTER TABLE crises ADD CONSTEASUT crimes_id_pk PRIMARY KEY (crise_id); ALTER TABLE Crities ADO CONSTRAINT Ches_class_ck CHECK (classification INCF, 0,333 ALTER TABLE cines City Jail 5 - Notepad File Edit Format View Help state CHAR(2), zip CHAR(5), phone CHAR(10), v_status CHAR(1) DEFAULT 'N', P_status CHAR(1) DEFAULT 'N' ); CREATE TABLE crimes (crime_id NUMBER(9), criminal_id NUMBER(6), classification CHAR(1), date_charged DATE, status CHAR(2) hearing date DATE appeal cut_date DATE) ALTER TABLE trim MODIFY (classification DEFAULT 'U'); ALTER TABLE crimes ADO (date_recorded DATE DEFAULT SYSDATE); ALTER TABLE criminals ADD CONSTRAINT criminals id_pk PRIMARY KEY (criminal_id); ALTER TABLE criminals ADD CONSTRAINT criminals_vstatus_ck CHECK (_status IN('Y', 'N')); ALTER TABLE criminals ADD CONSTRAINT criminals_pstatus_ck CHECK (p_status IN('Y', 'N')); ALTER TABLE crimes ADO CONSTRAINT crimes_id_pk PRIMARY KEY (crime_id); ALTER TABLE crimes ADO CONSTRAINT crimes_class_ck CHECK (classification INCE, "M", '0', 'U')); ALTER TABLE crimes ADO CONSTRAINT crimes_status_ck CHECK (status INCL', 'CA', 'IA >>> ALTER TABLE Crimes ADD COUSTRAINT crimes criminalid_fk FOREIGN KEY (criminal id) REFERENCES criminals(criminal_id); ALTER TABLE des MODIFY (criminald NOT NULL); Type here to search o 3 c