Use SQL Developer to write a single script that accomplishes both tasks. Then write a second script that performs the tasks outlined in Chapter 3, Section B on page 98.

ASSIGNMENT

Oracle 12c:sql chapter 3, end of chapter, case study: city jail exercise 01

This week’s lab is to complete the City Jail tasks described at the end of chapters 3 and 4.

The ERD (CityJailERD.pdf) for Lab 1 is provided in the Learning Activities of Module 4. You can use this ERD to create tables in the database. But before you start, compare the ERD with yours in Lab 1, and make sure you understand what entities are included and relationships among the entities. Then use CityJail_4Data.sql provided to insert data into the database.

Note that Chapter 3 has two parts: Section A and Section B.

Chapter 3, Section A asks you to create the tables for the database and Chapter 4 instructs you to add the constraints. You do not need to do this as a 2-step process. Use SQL Developer to write a single script that accomplishes both tasks. Then write a second script that performs the tasks outlined in Chapter 3, Section B on page 98.