DatabaseProvide identification of foreign key of child table and target table. CSC4402 Homework 3 DatabaseFollowing is the relational schema for a database about a company and its employees, projects, trainingcourses offered, employee's participation in the projects, and course enrollments (the primary key attributesare underlined):CM (DIVISION DEPT BUDGET)describing departments in the companyEM (ID NAME CITY DEPT SALARY)describing employeesPR (P-ID DIRECTOR-ID CITY DEPT)describing projectsEP (P-ID ID HOUR)describing employee participation in projectsCR (C-ID TITLE DEPT TEACHER-ID)describing courses offeredER (C-ID ID GRADE)describing employce enrollments in coursesThe data type for BUDGET, GRADE, HOUR and SALARY is SMALLINT, all other attributes have datatype VARCHAR(20).Each department has one or more employees, offers zero or more courses, and con-ducts zero or more projects. Anemployee can take zero or more courses and work in zero or more projects(including the projects conducted by otherdepartment). Each project has one or more employees working on it, and each course has one or more employeesenrolled in it. The teacher of a course could come from a department different from the one offering the course. Theattributes ID, TEACHER-ID, and DIRECTOR-ID are employee IDs - so TEACHER-ID and DIRECTOR-ID areforeign keys in CR table and PR table respectively referencing ID attribute in EM table. You should be able toidentify foreign keys in several tables in this database. Note that a table could have more than one foreign keys.Here the question for you is to identify the foreign keys in the following table(s) and the target (referenced) table foreach foreign key:For table EM, the attributeis a foreign key referencing target tableNOW, if a table has MORE THAN one foreign keys, the first foreign key for that table should be about the foreign keyattribute appearing earlier in the table's left-to-right column names.For table EP, the attributeis a foreign key referencing target tableFor table EP, the attributeis a foreign key referencing target tableFor table ER the attributeis a foreign key referencing target tableFor table ER the attributeis a foreign key referencing target table

Question

Accepted Answer

Short Summary:
Provided the Identification of foreign keys of the child table and the target table…