3-5 Exercise 1: Identi fy the Unique Identif iers and add to t he ERD Overview In this practice, you will identify unique identifiers and add to an ERD.
Tasks 1. Use the Academic Database ERD to identify the following: a. Unique Identifiers b. Candidate Unique Identifiers
COURSE Course ID Course Name Session ID Department ID
STUDENT ATTENDANCE Student ID Session ID Number of Working Days Number of Days Off Eligibility for exam
FACULTY LOGIN Faculty ID Login Date Login time Details
FACULTY Faculty ID Faculty Name Faculty Email
FACULTY COURSE Faculty ID Course ID
ACADEMIC SESSION Session ID Session Name
STUDENT Student ID First Name Student Reg Year Student Email