Assignment #4 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. It must be designed in order 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 . . 3 . Build queries to generate the following. Specify a logical sort order for each: A list of owners who are not from Kitchener A list of vehicles by owner Owner violation detail profile which is to include owner name, ticket details and vehicle details Owner violations summary - lists the owner and total amount of fines (sorted in descending order of fine amount). Have the sort column appear as the leftmost column . Create a Report: Make a report on each query