Question: Draw an ERD diagram ( crows foot notation ) using MS Visio using the following information : Entities: Candidate ( CandidateID ( PK ) ,
Draw an ERD diagram crows foot notation using MS Visio using the following information : Entities:
Candidate CandidateID PK Name, Email, Phone
Qualification QualificationID PK QualificationName
Course CourseID PK CourseName
TrainingSession TrainingSessionID PK CourseID FK Date
Company CompanyID PK CompanyName
Opening OpeningID PK CompanyID FK QualificationID FK StartDate, EndDate, HourlyPay
PlacementRecord PlacementRecordID PK OpeningID FK
Relationships:
Candidate Has Earned Qualification ManytoMany
CandidateQualification Link table
CandidateID FK from Candidate
QualificationID FK from Qualification
Course Develops Qualification OnetoOne
Course Requires Qualification ManytoManyprerequisite
CoursePrerequisite Link table
CourseID FK from Course
QualificationID FK from Qualification
Qualification Can be Prerequisite For Course ManytoMany
Course Is Taught In TrainingSession OnetoMany
Candidate Attends TrainingSession ManytoMany
CandidateTrainingSession Link table
CandidateID FK from Candidate
TrainingSessionID FK from TrainingSession
Company Requests Opening OnetoMany
Opening Requires Qualification OnetoMany
Opening Recorded In PlacementRecord OnetoOne
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
