Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

HS2021 Database Design And Use

tag 0 Download 3 Pages / 532 Words tag 19-07-2021
  • Course Code: HS2021
  • University: Holmes Institute
    icon

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Australia

Question:

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.
  1. Content of your report
    1. Prepare a report which will detail an E-R diagram (I need softcopy of it) and justification your choice of entities and attributes.
    2. Detail the normalization process of the ER diagram in details.
    3. Describe each additional entries or attributes you have created and why.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 3 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Database Design And Use. Retrieved from https://myassignmenthelp.com/free-samples/hs2021-database-design-and-use/crime-classifications.html.

My Assignment Help (2021) Database Design And Use [Online]. Available from: https://myassignmenthelp.com/free-samples/hs2021-database-design-and-use/crime-classifications.html
[Accessed 03 December 2022].

My Assignment Help. 'Database Design And Use' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/hs2021-database-design-and-use/crime-classifications.html> accessed 03 December 2022.

My Assignment Help. Database Design And Use [Internet]. My Assignment Help. 2021 [cited 03 December 2022]. Available from: https://myassignmenthelp.com/free-samples/hs2021-database-design-and-use/crime-classifications.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

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.

icon

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?