$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

HS2021 Database Design And Use

tag 0 Download3 Pages / 532 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT


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.

Unique Document

Under Evaluation

Get Money
into Your Wallet

Total 3 pages, 1 USD Per Page

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 24 September 2021].

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 24 September 2021.

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

MyAssignmenthelp.com is one of the noted service providers that deliver essay help. We provide tailored essay assistance to make sure that student gets online essay help exactly in the way they want it to be written. We at MyAssigemnthelp.com have built teams of consultants, who readily attend every query related to help me writing my essay. We provide essay writing help in forms of tips and steps in order o assist students with tough essay assignments.

Latest Database Samples

ISY310 Data Mining And Business Intelligence

Download : 0 | Pages : 85

Answer: During the analysis, the set of data that are to be used has been collected from students of the university on the form of survey. In the survey the main roles played is by uncovering the modeling techniques and various analytics Data Mining. For the completion of this report, all the methods will be utilized as well as for the conventional questions to be answered, which are required to complete the analysis of this report. All these ...

Read More arrow

STAT 503 Design Of Experiments

Download : 0 | Pages : 2

Answer: Application of DOE in establishing Process Limits Design of experiments (DOE) is used as an approach in different industries for carrying out experiments for developing new products and initializing processes in a faster way, and for improving existing products and processes. Its proper application can decrease the time for marketing, decreasing development and production costs, and improving quality and reliability (Antony, 2014...

Read More arrow Tags: Australia Bloomington Management Educational Environment University of New South Wales MBA 

ITC516 Data Mining And Visualisation For Business Intelligence

Download : 0 | Pages : 4

Answer: The PCA analysis for the given data on US utilities data has been carried out with the aid of XLMiner and the relevant matrix consisting of the applicable Eigen values has been presented in the output below. Result Analysis and Component Analysis One of the key requirements to analyze the above output is to decide the extent of variation that the researcher aims to explain. This is imperative since the significant principal component...

Read More arrow Tags: Australia Hawthorn Engineering University of New South Wales 

ITECH1006 Database Management Systems

Download : 0 | Pages : 6

Answer: Australian Premier League (APL) is about to implement a new system for managing the league. The system will have to run on a very effective database to avoid cases of redundancy in data. This document shows they system can be modelled by showing the entity relationship diagram and a set of normalized relations derived from the ERD. The ERD diagram for the new Australian premier league is shown below. The diagram shows all the entities...

Read More arrow

301044 Data Science

Download : 0 | Pages : 15

Answer: Introduction Cancer is among the health conditions that have emerged in the last two to three decades ago. It has been established that there is no definite cure for this condition. This has led to the development of more scientific research aimed at how medication or control procedures to this conditions can be developed. In this paper, breast cancer data obtained from kaggle.com is explored, inferential and regression statistical te...

Read More arrow Tags: Australia Melbourne Management University of Melbourne 

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

callback request mobile
Have any Query?