Create an ERD diagram Mini-Project #1 The Physician Master File from a DFD contains the following data

Create  an ERD diagram

 

Transcribed Image Text:

Mini-Project #1 The Physician Master File from a DFD contains the following data elements: Data Element Social Security # Physician ID Last_Name First Name Mid_Init Hospital Resident_ID Hospital_Resident_Name Hospital Addr_Linel Hospital Addr_Line2 Description Primary Key Alternate Key Last Name First Name Middle Initial Hospital Identification Name of Hospital Hospital Address Hospital Address Hospital Addr_Line3 Hospital Address Hospital_State Hospital City Hospital_Zip Specialty Type Specialty_Name Specialty College Specialty_Degree Date_Graduated DOB Hospital's State Hospital's City Hospital's Zip Code The Physician's specialty Description of specialty College where received degree Degree Name Graduation Date For Specialty Mini-Project #1 The Physician Master File from a DFD contains the following data elements: Data Element Social Security # Physician ID Last_Name First Name Mid_Init Hospital Resident_ID Hospital_Resident_Name Hospital Addr_Linel Hospital Addr_Line2 Description Primary Key Alternate Key Last Name First Name Middle Initial Hospital Identification Name of Hospital Hospital Address Hospital Address Hospital Addr_Line3 Hospital Address Hospital_State Hospital City Hospital_Zip Specialty Type Specialty_Name Specialty College Specialty_Degree Date_Graduated DOB Hospital's State Hospital's City Hospital's Zip Code The Physician's specialty Description of specialty College where received degree Degree Name Graduation Date For Specialty