Get 20% Off + $20 Signup Bonus ! Limited Time, Hurry !
Get 20% Off + $20 Signup Bonus ! Limited Time, Hurry !
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

5 Pages
WCOM1350 Introduction to Database Management

Create the following tables based on the specification tables given below. You need to decide the right order to create these tables. Note that the description of each table is for your understanding ...

Course

WCOM1350

Type

Programming

Subject

Database

University

Macquarie University

0 Page
Code of Conduct

...

Course

DATA4300

Subject

Database

University

Kaplan Business School

Season

Spring

0 Page
Vector Model

...

Course

SIT772

Subject

Database

University

Deakin University

Season

Spring

0 Page
The ROC Analysis

...

Course

COMP5318

Subject

Database

University

The University Of Sydney

Season

Spring

HS2021 Database Design and Use

Question

Answered

Assignment Description: In this assignment you will use your normalized “City Jail” database you have created in your assignment one. You will form a group (2-3 students) and implement your designed City Jail database using Oracle SQL developer 12c. You will also perform different types of SQL queries on it to sharpen your SQL skills to implement and manage the database. Please submit your assignment using the attached template.
Assignment Tasks need to be executed:
•    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.
o    Group member Two:
  List the following information for all crimes that have a period greater than 14 days between the date charged and the hearing date: crime ID, classification, date changed, hearing date, and number of days between the date charged and the hearing date.
 Produce a list showing each active police officer and his or her community assignment, indicated by the second letter of the precent code. Display the community description listed the following chart, based on the second letter of the precent code.
 Display the criminal name and probation start date for all criminals who have a probation period greater than two months. Also, display the date that’s two months from the beginning the probation period, which will serve as a review date.
o    Group member Three (Ignore this section if you are a group of 2): -
 List all criminals along with crime status and appeal status (if applicable). The report need to include the criminal ID, name, crime classification, date change, appeal filling date, and appeal status. Show all criminals, regardless of whether they have filled an appeal.
List all criminals along with crime information. The reports need to include the criminal ID, name, crime classification, date charged, crime code, and fine amount. Include only crimes classified as “Other”. Sort the list by criminal ID and date changed.
Create an alphabetic list of all criminals, including criminal ID, name, violent offender, status, parole status, and any known aliases.
•    Create SQL statements to drop all the tables you have created as a group.

HS2021 Database Design and Use

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

13 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com has gained the status of premier assignment help provider in USA. The combination of highly qualified experts, wide range of service and affordable price play a significant role behind our overwhelming popularity among the students in USA. Some of our popular writing services include Marketing assignment help, mechanical engineering assignment help, English assignment help, taxation assignment help, electrical engineering assignment help.

More HS2021 Database Design and Use: Questions & Answers

Q
icon

We aren't endorsed by this University

WCOM1350 Introduction to Database Management

Create the following tables based on the specification tables given below. You need to decide the right order to create these tables. Note that the description of each table is for your understanding and not to be used in SQL table creationWrite an SQL statement to display all the details of the Pat ...

View Answer
Q
icon

We aren't endorsed by this University

Code of Conduct

...

View Answer
Q
icon

We aren't endorsed by this University

Vector Model

...

View Answer
Q
icon

We aren't endorsed by this University

The ROC Analysis

...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?