How can this problem be solved?:

For the business rules given below, draw your dependency diagram an ERD in MS Visio or Lucidchart.

Business Rules:

The public safety office at a large public university maintains a list of parking tickets issued to vehicles parked illegally on the campus. Table $1($see below$)$ shows a portion of this

list. Assume sample data presented in the table are representative.

Convert this table to a relation in the first normal form. Draw a dependency diagram showing all functional dependencies. You can use Visio or any other drawing tool.

Create 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.

Draw the Crow's Foot ERD in Visio.

Note: Violation codes represent the following:

$1-$ expired parking meter

$2-$ no parking permit

$3-$ handicap violation