The Physician Master File from a DFD contains the following data elements:

Assumptions 1. A physician can be associated with many hospitals, but must be associated with at least one.
2. A physician can have many specialties, or have no specialty.
Assignment Normalize to 3rd normal form

Transcribed Image Text:

Data Element Social Security # Physician ID Last Name First Name Mid_Init Hospital Resident ID Hospital Resident Name Hospital Addr_Line1 Description Primary Key Alternate Key Last Name First Name Middle Initial Hospital Identification Name of Hospital Hospital Addr_Line2 Hospital Addr_Line3 Hospital_State Hospital City Hospital Address Hospital Address Hospital Address Hospital's State Hospital Zip Specialty Type Specialty Name Specialty College Specialty Degree Date Graduated DOB Hospital's City Hospital's Zip Code The Physician's specialty Description of specialty College where received degree Degree Name Graduation Date For Specialty