Question

HH, a headhunter company, wants to maintain candidate records and is particularly interested in tracking candidate education. This company now asks you to design a database system to track candidate education.

1. For a candidate, the company needs to know candidateID, name, and address.
2. The tracked candidates must attend colleges. Each candidate can attend different colleges or the same college at different time. The system needs to track information on the college name and location.
3. For each attendance of a candidate at a college, the system needs to track the college name, the start and end date, the degree entries, and transcript entries (courses completed at that college, if any).
4. For each attendance of a candidate at a college, this candidate can obtain several degrees.

Each degree entry includes the degree name, the month and year the degree was awarded.

5. Each attendance of a candidate at a college has transcript entries. A transcript entry contains a course name, semester, year, and grade.

Please complete the following (don’t need to write relationship sentences):

1. Identify the main entity types for the system and highlight the identifiers.
2. Identify the main relationship types and specify the multiplicity for each relationship. State any assumptions you make about the data.
3. Using your answers for a)-b), draw a single ER diagram to represent the data requirements for the company. (you can draw it on a piece of paper, take a photo, and paste here)

Answer 1

IF YOU HAVE ANY DOUBTS I WILL EXPLAIN IT PLEASE COMMENT AND GIVE ME AN UPVOTE