Could you also generate a list of Business Rules for the database?

 

Based on the following memo, create a database design for the City Jail.TIP:Keep in mind that the memo is wriTen from an end-user perspec±ve – not by a databasedeveloper!MEMO²o: Database ConsultantFrom: City Jail Informa±on DirectorSubject: Establishing a Crime-²racking Database SystemIt was a pleasure mee±ng with you last week. I look forward to working with your company tocreate a much-needed crime-tracking system. As you requested, our project group has outlinedthe crime-tracking data needs we an±cipate. Our goal is to simplify the process of trackingcriminal ac±vity and provide a more e³cient mechanism for data analysis and repor±ng. Pleasereview the data needs outlined below and contact me with any ques±ons.Criminals:name, address, phone number, violent o´ender status (yes/no), proba±on status(yes/no), and aliasesCrimes:classiµca±on (felony, misdemeanor, other), date charged, appeal status (closed, canappeal, in appeal), hearing date, appeal cuto´ date, (always 60 days a¶er the hearing date),arres±ng o³cers (can be more than one o³cer), crime codes (such as burglary, forgery, assault,and many more), amount of µne, court fee, amount paid, payment due date, and charge status(pending, guilty, not guilty)Sentencing:start date, end date, number of viola±ons (such as not repor±ng to proba±ono³cer, and many more) and type of sentence (jail period, house arrest, proba±on)Appeals:appeal µling date, appeal hearing date, status (pending, approved, and disapproved).Each crime case can be appealed up to three ±mes.Police ofcers:name, zone, badge number, phone contact, status (ac±ve/inac±ve)AddiTonal inFormaTon:A single crime can involve mul±ple criminal charges, such as burglary and assault.Criminals can be assigned mul±ple sentences. For example, a criminal might be required toserve a jail sentence followed by a period of proba±on.

• 1495700473-City_Jail 1.docx

ComputerScienceExpert

(11)

Status NEW Posted 25 May 2017 08:05 AM My Price 9.00

-----------

Attachments

file 1495700476-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer