Need Help With Sql Assignment

Need Help With Sql Assignment

I need help with College Assignment for SQL
I have been give two SQL files and told to answer questions based on the Table in the file

Questions that need to be answered (List of questions in Requirements)
Example Questions
List all of the Primary Key Columns defined for each Table
List all of the Foreign Keys for each table? And each of those Foreign Key which Parent
Maximum I can pay $20

---

Requirements

Instructions

Download and execute following files in your SQL Developer screen

Files : CityJail_Oracle.sql , Book_Order_Oracle.sql , Book_Order_ReportingNeeds.png and City_Jail_ReportingNeeds.png

The Files will be provided


When you open the file CityJail file , there must be CREATE TABLE section to create all tables and after that ALTER TABLE to add CONSTRAINTS.


Prep work: In this part of the project , students needs to understand how a Database physical structure is being build , Rather than just executing above script… Students must understand what they are running to build CityJail database system

Answer below questions only based on CityJail_Oracle.sql file
List all of the Primary Key Columns defined for each Table
List all of the Foreign Keys for each table? And each of those Foreign Key which Parent table they are referencing.
Is there any CHECK Constraint defined? If Yes on Which table
=============
Section B ( 50 pnts)

Prepare below reports for City Jail management Officer… Find solution for all 5 items below

Look for City City_Jail_RportingNeeds.png to answer questions
===================
Section C (20 pnts)
Choose 2 questions from below list and answer them based on BookOrder management database


Look for City Book_Order_Reports.png to answer questions

Provide the answers for the question on text file(SQL queries) so i can test the result

http://www35.zippyshare.com/v/YOqOJXak/file.html
http://www35.zippyshare.com/v/HhKMm51n/file.html
http://www35.zippyshare.com/v/hhAlmk8X/file.html
http://www35.zippyshare.com/v/38qZ5y0J/file.html

---

Skills Required

Database Sql Oracle