Convert the following ERD for Job Application Tracking System into tables (relat

Question

Convert the following ERD for Job Application Tracking System into tables (relations which can be implemented in a relational database. Use a standard form for the table description, which should include table name, all attributes and indicate primary key and foreign key. For example, a standard database can include tables as - Tablel(att 11(pk), att12, att13,..) 93 APPLICATION POSITION PPLICANT Responds to Applies Applicant ID Position_ID Date_Applied Position_Title Department Applicant_Name Interviews for INTERVIEW Interview ID Position_ID

Explanation / Answer

APPLICANT(Applicant_ID(PK),Applicant_Name,Applicant_Address)
APPLICATION(Application_ID(PK),Applicant_ID(FK),Position_ID(FK),Date_Applied)
POSITION(Position_ID(PK), Position_Title,Department,Date_Position_Opens)
INTERVIEW(Interview_ID(PK),Position_ID(FK),Date_Interviewed)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---