I would like assistance with the attached "Normalization" problem using MS Access. The tutor must be skilled in both Relational Database Normalization methods (to 3NF) and MS Access 2010.

    

Based on the information given below in form of reports, design a fishing industry database: You must design and create all tables (remember, there is no one solution) Create a new database and build the tables Create the primary keys. Place foreign keys into child tables. Use the Relationship Builder tool and create the relationships. You do not have to enter the data! Though it may help you understand and validate your design. Do not worry about formats, inputs masks, etc. Just the data type is important. Fishermen Last Name First Name Date of Birth Gender Address Comments Jelly Bob 3/4/1954 M 32 Net Street License History Valid From Valid To Comments 2/1/2010 6/30/2010 7/1/2010 6/30/2011 Shark Mary 12/2/1963 F 43 Grotto Ave License History Valid From 5/1/2010 7/1/2010 Valid To Comments 6/30/2010 12/31/2010