Based on the following memo, create a database design for the Metropolis Jail.TIP: Take into account that the memo is written from an end-user perspective – not by a databasedeveloper!MEMOTo: Database ConsultantFrom: Metropolis Jail Info DirectorSubject: Establishing a Crime-Monitoring Database SystemIt was a pleasure assembly with you final week. I stay up for working along with your firm tocreate a much-needed crime-tracking system. As you requested, our mission group has outlinedthe crime-tracking knowledge wants we anticipate. Our objective is to simplify the means of trackingcriminal exercise and supply a extra environment friendly mechanism for knowledge Assessment and reporting. Pleasereview the knowledge wants outlined under and speak to me with any questions.Criminals: title, tackle, cellphone quantity, violent offender standing (sure/no), probation standing(sure/no), and aliasesCrimes: classification (felony, misdemeanor, different), date charged, enchantment standing (closed, canappeal, in enchantment), listening to date, enchantment cutoff date, (at all times 60 days after the listening to date),arresting officers (might be a couple of officer), crime codes (corresponding to housebreaking, forgery, assault,and plenty of extra), quantity of fantastic, courtroom charge, quantity paid, fee due date, and cost standing(pending, responsible, not responsible)Sentencing: begin date, finish date, variety of violations (corresponding to not reporting to probationofficer, and plenty of extra) and kind of sentence (jail interval, home arrest, probation)Appeals: enchantment submitting date, enchantment listening to date, standing (pending, authorised, and disapproved).Every crime case might be appealed as much as thrice.Law enforcement officials: title, zone, badge quantity, cellphone contact, standing (energetic/inactive)Extra info:A single crime can contain a number of felony fees, corresponding to housebreaking and assault.Criminals might be assigned a number of sentences. For instance, a felony could be required toserve a jail sentence adopted by a interval of probation.Suppose you are employed to construct a database for Metropolis Jail. Your first activity is to design a database thatstores and organizes all info (crimes, criminals, sentencing, appeals, law enforcement officials, and so on.)about the group.A. Generate an inventory of Enterprise Guidelines for the database.B. Write the relational schema, draw its dependency diagram, and determine all dependencies,together with all partial and transitive dependencies for 2nd and third Regular Type.C. Given the above description, draw an ER diagram for the database. State any assumptions youmake to your ER-diagram to Help your design. Embody the following into your design:all the entity setsall the attributesall the relationship units utilizing the Crow’s Foot ModelMake positive that every one M:M relationships have been transformed utilizing associative tablesIdentify the whole main key for every entity.Determine all the overseas keys if wanted.D. Based on the ER diagram you created, implement the database in Oracle. Insert 5 recordsinto every desk. Create the vital relationships, main keys, and so on. Embody the script fileand spool file in your submission.

Published by

Essays

View all posts