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

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Database Systems Concepts

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
• show parks, schools and other public places where caution should be
• categorization of the criminals that are registered by

A badly designed ER diagram is attached as Exhibit A. In fact, it’s one table, unrelated to any others.

 

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

{ZipCode}Ø {City, State}

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

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of