Practice Problem 1

Practice Problem 1

For the business rules given below, draw your dependencydiagram and then ERD in Visio.

Business Rules:

The public safety office at a large public university maintains a list of parking tickets issued to vehicles parked illegallyon the campus. Table 1 (see below) shows a portion of this list.Assume sample data presented in the table are representative.

1. Convert this table to a relation in first normal form.Draw a dependency diagram showing all functional dependencies. You can useVisioor any other drawing tool.
2. Draw a set of dependency diagrams that meet 2NF and 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary.
3. Draw the Crow's Foot ERD .

Note: Violation codes represent the following

1 - expired parking meter

2 - no parking permit

3 - handicap violation

\f