After successfully completing this assignment, you will be able to:

Create a database in 3rd normal form using MS Access

Create relationships between tables

Define fields and their properties within a table

Establish data validation for fields

Build Select Queries with criteria operating on single and multiple tables

We need to create a database to be used in tracking traffic violations at a local community college.

The database must contain at least 6 tables and be designed to satisfy the following requirements:

Contains owner information suitable for mailing traffic tickets

Owners may have multiple vehicles

The college has a list of violations and the associated fine.

Ensure that you have at least 3 fields with data validation.

Ensure that you utilize at least 2 different input masks.

Add realistic data to your database

Add just 3 owners

Add 5 vehicles (1 owner must own multiple vehicles)

Add all violations

Add 10 tickets ensuring that 1 owner has at least 3 tickets