Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Sex offender registry mn watchdog

12/11/2021 Client: muhammad11 Deadline: 2 Day

Final Exam Fall 2019 CSCI 3287 Database Systems Concepts

Work alone to complete your own paper. Use the terms, formal notation for diagramming, and model definitions that we learned in class to answer the questions. If you make any assumptions related to your answers write them on the page. You will get credit for correct answers based on your assumptions. You are the designer. Solve the problems any way you feel is correct according to the principals and formal models that we have studied. There is more than one correct answer for some of the questions depending on the assumptions you make. Cautions: • Failure to put your name on your test (I recommend putting it on each page) will result in a grade of 0.

(This has been a serious problem all semester and I may not have time to look into it by the grading deadline, so please get your name onto your final.)

• Any kind of collaboration or academic dishonesty will result in a grade of 0 for your final, an F for your course grade and a formal report to the college about your activities.

Due Date: This is a take home test due back by Friday 12/13/2019 at 6:30 PM. Delivery:

• The easiest way to take this test is to print it, complete it (in pencil or pen), scan and upload to Canvas.

• You may also type your answers in this document and upload it to Canvas as a pdf.

Good luck and good skill!

_______________________________________________________________________

Manthan Baboo
Manthan Baboo
Manthan Baboo
Manthan Baboo
Manthan Baboo
Manthan Baboo
Manthan Baboo
Name: ___________________________________________ SID: _____________________________________________ There is a database online at the Family Watchdog site that uses the National Sex Offender registry data to deliver information to the public. You can visit the database here to get a feel for it: http://www.familywatchdog.us The purpose of the database is to store information about sex offenders and their location so that parents can do these things to protect their kids.

1. Know who is in their neighborhood 2. Use Family Watchdog to locate sex offenders near their home and their kid's

school. 3. Empower their kids with information 4. Change the laws 5. Support the Child Safety Act of 2005

The database views include * maps with home and work locations identified * lists * recent address changes * free alerts * send maps to a friend screen * notify/add a missing school or public facility * count mappable and non-mappable (7%) offenders by area. * show parks, schools and other public places where caution should be used. * categorization of the criminals that are registered by crime. A badly designed ER diagram is attached as Exhibit A. In fact, it’s one table, unrelated to any others.

Name: ___________________________________________ SID: _____________________________________________

1. Joe Amateur has designed the OFFENDER table of the National Sex Offenders Registry without much care or concern for programming, redundancy or data integrity. You’ve been hired to straighten out the mess by implementing properly related tables. You’ve been able to come up with the ER diagram in Exhibit A. Now show functional dependency diagrams and the steps required to construct the schema constructs for tables in 3rd normal form. Assume that the following additional FD occurs in addition to what you can read from the ER diagram.

{ZipCode}¬ {City, State}

a. Show 1NF and tell what the rules are for first normal form. (10 pts)

Name: ___________________________________________ SID: _____________________________________________

b. Show 2NF and tell what the rules are for second normal form. (10 pts)

Name: ___________________________________________ SID: _____________________________________________

c. Show 3NF and tell what the rules are for third normal form. (10 pts)

Name: ___________________________________________ SID: _____________________________________________ 2. Assume that the National Sex Offenders Registry is a distributed database. RELY ON YOUR NORMALIZED TABLES TO ANSWER THE FOLLOWING QUESTIONS.

A: You may need to add tables or attributes to the ER diagram in Exhibit A. The government decided that: • OFFENDERs, ALIASES AND ADDRESSES records that have not been

changed in 20 years will be archived in New York while … • a complete set of the more current OFFENDERs, ALIASES AND

ADDRESSES records will be kept in Denver and in Washington, DC. • All MAP data is kept in both Los Angeles and New York. • CONVICTIONS data is kept in 5 regional locations as follows:

o CONVICTIONS records from WA, OR, CA, NV, ID, UT, AZ, MT, HI, AK are kept in Los Angeles.

o CONVICTIONS records from NM, CO, WY, ND, SD, NE, KS, OK and TX are kept in Wichita.

o CONVICTIONS records from MN, IA, MO, AR, LA, MS, TN, KY, IL, WI, and IN are kept in Des Moines.

o CONVICTIONS records from MI, OH, WV, VA, NC, SC, GA, AL, FL are kept in Miami.

o CONVICTIONS records from ME, VT, NH, NY, MA, CT, DE, MD, PA, RI, DC are kept in Boston.

Each of the 5 regions mentioned for CONVICTIONS data also houses its own LOCATION data for the states involved so as to display MAPs faster when queried. What tables and attributes (if any) need to be added to the ER diagram from Exhibit A to make the distribution work well. Tell why you added any that you add. Draw them on Exhibit A or on your 3NF diagram from the last questions and indicate where I should find your answer here. (5 points)

Name: ___________________________________________ SID: _____________________________________________

B: Write the vertical fragment that is the set of all of the OFFENDER Names and Aliases which will be stored at the corporate office in Denver regardless of where the OFFENDER is registered. (10 points) C: Write the horizontal fragment that is the set of OFFFENDERs who have committed crimes that are categorized as “Battery”. (10 points)

Name: ___________________________________________ SID: _____________________________________________

D: Write the mixed fragment that is the set of Names, current Addresses, ConvictionYears and Crimes for OFFENDERs in the 80202 ZipCode. (10 points) E: Given the description above, and the 3 fragments you just wrote, construct a fragmentation schema for the whole database. (10 points)

Name: ___________________________________________ SID: _____________________________________________

F: Given the descriptions above, construct an allocation schema for the whole database. (10 points) G: Given the descriptions above, draw a replication model and place an X on the model to represent the magnitude of replication in this database. Write a few sentences about why you placed the X where you did. (5 points)

Name: ___________________________________________ SID: _____________________________________________

3. Please complete these short answer questions. a. (2 pts) What is the Stonebraker’s classification of the database for the

National Sex Offender’s Registry? Justify your answer.

b. (2 pts) In a strictly Object Oriented database design, where is the only place where actual data values are found?

c. (2 pts) What SQL key word would use you before specifying Boolean conditions for SELECT, UPDATE or DELETE statements?

d. (2 pts) What is the definition of a database?

Name: ___________________________________________ SID: _____________________________________________ Exhibit A

OFFENDER

OffenderID

LastName FirstName

MiddleName

Name

Aliases

Convictions

Crime

CrimeCategory

ConvictionYear

RecordSource

Addresses

StreetAddress

StartDate

EndDate MovingStatus

Location

MapID

ZipCode

State

City

CrimeID

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Assignment Helper
Top Quality Assignments
Calculation Master
Peter O.
Helping Engineer
Financial Analyst
Writer Writer Name Offer Chat
Assignment Helper

ONLINE

Assignment Helper

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$26 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$16 Chat With Writer
Calculation Master

ONLINE

Calculation Master

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$50 Chat With Writer
Peter O.

ONLINE

Peter O.

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$23 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$50 Chat With Writer
Financial Analyst

ONLINE

Financial Analyst

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$28 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Variance of a three asset portfolio - American bully stud contract - Duvall family life cycle - Has the smartphone destroyed a generation - O keefe reinhard & paul glassdoor - Ford focus smart charge - Aldershot and district tennis league - What is the heritage assessment tool - What is the definition of the commutative property of addition - The magic bullet theory media - Pag 9.1 chemistry ocr answers - Table 1: substance vs. starch presence - Glencoe states of matter virtual lab - Secure attachments contribute to children's compliance because - This week A - The delicious miss dahl dvd - Amp super contribution form - The sonar of a navy cruiser detects - Professional Assignment 1 – CLO 2 - 632lastd1 - Felipe es antipático y feo - The following is the adjusted trial balance for stockton company - Negative Message - Hands-on information security lab manual - How to work out volt drop in a cable - Examples of symbolic restitution - Screwtape proposes a toast - Expected and augmented customer service - Accounting - As1851 2005 free download - Thermal rising inc makes paragliders for sale - Aphrodite strengths and weaknesses - Tesco case study questions and answers - Resume edit - Bromothymol blue indicator colour change - Which of the following would have been one of the closing entries at december 31 for booth company? - Assignment - Magnesium bullets for cattle - Radex model of criminal differentiation - Cherubim and seraphim theology - Aday something borrowed shirt review - Planning the Project-1 - Cases in financial management stretcher solutions - Multiple sclerosis nursing concept map - Toms shoes executives - Distance Learning Facilitator Training Response - When i heard the learn d astronomer paraphrase - Maroondah city council food safety - Skills to succeed academy - HLS685 A3 - Presentation Slides - HTML programming Exercise 14.1 and 14.2 - C++ program to convert pounds to kilograms - Corby borough council environmental health - Confucian harmony and aristotelian balance are comparable concepts - Mount gambier to bordertown - C11 Lesson 2 Exam SCORE 95 PERCENT - First Essay: First Essay Topic: the image below, present an argument based on your analysis of that material artifact or artifacts (in this case, what does it tell us, what does it not tell us, how does it tell us about the society in question). - White collar crime paper topics - Bundaberg rum 4.5 litre cradle - Discussions 3 - Role on the wall - Sci 207 week 5 lab report - The key theme in humanistic therapy is - Frimley park hospital postcode - University of essex hr organiser - Radians and degrees worksheet - You hear: ¿qué es la piña? you choose: fruta - Anne mcarthur notre dame - Strategy beyond the hockey stick mckinsey pdf - Casr part 21 pdf - Case Study, Journal Article and Discussion (APA Format) - Bank muscat azaiba branch contact number - Analysis of an ethical case is done by - How are bays formed - Ghost by jason reynolds prezi - Elements of a marketing plan paper mkt 421 - Eng final film critique paper - Acetylation of aniline mechanism - You have a network connected using a physical star topology - Jiminy's cricket farm issued a 30 year 7 percent - Facility condition assessment report template - How does distraction affect reaction time - Cna chapter 3 legal and ethical issues - Complementary strategic alliances - Edrms implementation project plan - Assignment: Decision Tree for Neurological and Musculoskeletal Disorders - Economic 6 - Zipcar is an example of what type of market orientation - Projects that spend much time ________ are sometimes said to be in analysis paralysis. - How to buy safe from lee on weed firm - A motorcycle catches a car mastering physics - Healthy People 2020 Initiatives in School Health Program d2 - What is compromised data integrity - Summarize the three most important things when it comes to emotional intelligence. - Mar 6336-Weekly Application Post - Week 1 - Core concepts 5.4 word wise - Resources and capabilities analysis - Magnetism and its uses - Cao dewang net worth