Design student–course data models and SQL

A university records system is being modeled. The domain covers Students, Courses, Departments, Instructors and Enrollments, and you are asked to work through five deliverables. Transactional (OLTP) design. Give the normalized relations with their primary and foreign keys, along with the constraints the schema must enforce — for instance, a student must not be enrolled in two different sections of the same course within one term, and every grade value must be drawn from…