1. Create a normalized data design using standard notation format. Normalize your designs for all tables to ensure they are 3NF, and verify that all primary, secondary, and foreign keys are identified properly. Show your work from 0 Normal Formal to 3^rd Normal Form. Example tables include: Insurance Company, Provider, CPT Code & Fee, Patient, Household, Payment, Claim, Appointment Service, Charge. Note: there will be additional tables once you get rid of any M:N relationships

2. Create an initial ERD based on your standard notation for the new system that contains at least eight entities. Be sure to identify if the relationship is 1:1, 1:M, or M:N. All M:N relationships should be removed.