Question: Using the information below, create a database diagram 1 . PROVIDER a . ( ProviderID , ProviderName, ProfSuffix, ProviderAddress, ProviderEmail, ProviderPhone, DOB, SSN , NPI
Using the information below, create a database diagram
PROVIDER
aProviderID ProviderName, ProfSuffix, ProviderAddress, ProviderEmail, ProviderPhone, DOB, SSN NPI
EDUCATIONTRAINING
aSchoolID SchoolName, SchoolAddress, SchoolCountry
bProviderID SchoolID, EducationType, AreaofStudy, SchoolStartDate, DateofCompletion
EDUCATIONTYPE
aSchoolID ProviderID, UndergradTraining, Masters, Doctorate, Internship, Residency, Fellowship
FACILITY
aFacilityID FacilityName, FacilityAddress, FacilityPhone, FacilityType
bProviderID FacilityID
AFFILIATION
aFacilityID AffiliationStartDate, AffiliationEndDate, StaffType, AffiliationVerified
EMPLOYER
aFacilityID ProviderID, HireDate, TermDate, Position, HRContactName
CLIENT
aFacilityID ContactName, ContactEmail, ContractStartDate, ContractEndDate, ContractActive
LICENSE
aLicenseNumber LicenseState, LicenselssueDate, LicenseExpDate, LicenseSanctions
bProviderID LicenseNumber
DEASCS
aDEASCSNumber, DEASCSState, Schedule, DEASCSIssueDate, DEASCSExpDate
bProviderID DEASCSNumber
BOARDCERT
aCertNumber BoardName, Specialty, Subspecialty, BoardExpDate
bProviderID CertNumber
MALPRACTICEINS
aPolicyID PolicyNumber, InsuranceName, PolicyExpDate, ClaimActivity
bProviderID PolicyID
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
