We're Open
+44 7340 9595 39
+44 20 3239 6980

DATABASE DESIGN AND USE

  100% Pass and No Plagiarism Guaranteed

DATABASE DESIGN AND USE

Assignment Description: In this assignment you will use the given case study (Case Study: City Jail) to design a database. You need to analyse the case study to identify database requirements and design a complete E-R diagram in 3NF form. You final outcome will be ready to be implemented in Oracle12c which will be used for your assignment two.

 

Case Study: City Jail

 

Your company receives the following memo.

 

MEMO

 

Subject: Establishing a Crime-Tracking Database System

It was a pleasure meeting with you last week. I look forward to working with your company create a much needed crime-tracking system. As you requested, our project group has outlined the crime-tracking data needs we anticipate. Our goal is to simplify the process of tracking criminal activity and provide a more efficient mechanism for data analysis and reporting. Please review the data needs outlined below and contact me with any questions.

 

Criminals: Name, address, phone number, violent offender status (yes/no), probation status (yes/no) and aliases.

Crimes: classification (felony, misdemeanour, other), date charged, appeal status (closed, can appeal, in appeal), hearing date, appeal cutoff date (always 60 days after the hearing date), arresting officers (can be more than one officer), crime codes ( such as burglary, forgery, assault; hundreds of codes exist), amount of file, court fee, amount paid, payment due date, and charge status( pending, guilty, not guilty)

Sentencing: start date, end date, number of violations (such as not reporting to probation officer), and type of sentences (jail period, house arrest, probation)

Appeals: appeal filling date, appeal hearing date, status (pending, approved and disapproved)

Note: Each crime case can be appealed up to three times.

Police officers: name, precinct, badge number, phone contact, status (active/inactive)

 

Additional Notes:

• A single crime can involve multiple crime charges, such as burglary and assault.
• Criminals can be assigned multiple sentences. For example, a criminal might be required to serve a jail sentence followed by a period of probation.

Assignment Requirements:

• First, based on the memo, create an initial database design (E-R model) for the city jail that indicates entities, attributes (columns), primary keys, and relationships between the entities. Use only the entities identified in the memo to develop the E-R model.
• Second, create a list of additional entries or attributes not identified in the memo that might be applicable to a crime-tracking database.
• Furthermore, normalize your database design to 3NF so that it is ready to be deployed to Oracle12c SQL developer.

Marks Allocation:

Assignment components

marks

First, based on the memo, create an initial database design (E-R model) for the city jail that indicates entities, attributes (columns), primary keys, and relationships between the entities. Use only the entities identified in the memo to develop the E-R model.

3%

Second, create a list of additional entries or attributes not identified in the memo that might be applicable to a crime-tracking database.

 

2%

Furthermore, normalize your database design to 3NF so that it is ready to be deployed to Oracle12c SQL developer.

5%


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: DATABASE DESIGN AND USE
  • Price: £ 109
  • Post Date: 2018-11-08T13:01:47+00:00
  • Category: Assignment
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

DATABASE DESIGN AND USE DATABASE DESIGN AND USE
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

My writer did a small error in my work but it was fixed by him shortly. The work is admirable and I have submitted it. Now hoping for the best results. I would inform you soon.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

My psychology assignment just came on time and the overall quality is good. It’s also free from errors. I simply loved it!