Logical Data Modeling -

Question 1: Normalize the logical data model step by step, i.e. 1st NF->2nd NF->3rd NF. (First Normal Form, Second Normal Form and Third Normal Form)

Question 2: Draw the ERD (Entity Relationship Data) after you normalize the system to the 3rd NF

The physician Master File from a DFD (Data Flow Diagram) contains the following data elements:

Social Security #

Physician ID

Last_Name

First_Name

Mid_Init

Hospital_Resident_ID

Hospital_Resident_Name

Hospital_Addr_Line1

Hospital_Addr_Line2

Hospital_State

Hospital_City

Hospital_ZIP

Specialty_Type

Specialty_Name

Specialty_College

Date_Graduated

Birth_Date

Year_First_Practiced

Years_Practiced

Annual_Earnings