Create entities (tables) to represent the following ternary relationship. Note that we are not storing all the required information in these entities to simplify it. The underlined attributes are the primary keys. Don’t forget to set the constraints for primary and foreign keys: •A student entity ( bannerId, first name, last name, date of birth)
•A course entity ( crnNumber, course name, # of credits)
•An examination entity ( examId, exam_type, exam_date). (exam types can be "Midterm", "Final", "Exam_1", "Exam_2", etc)