Question 1 of 30
In a university database system, a conceptual data model is being designed to represent the relationships between students, courses, and instructors. Each student can enroll in multiple courses, and each course can have multiple students. Additionally, each course is taught by one instructor, but an instructor can teach multiple courses. Given this scenario, which of the following best describes the relationships and cardinalities that should be represented in the conceptual data model?
A many-to-many relationship between students and courses, and a one-to-many relationship between instructors and courses.
A one-to-one relationship between students and courses, and a one-to-many relationship between instructors and courses.
A one-to-many relationship between students and courses, and a one-to-one relationship between instructors and courses.
A many-to-one relationship between students and courses, and a one-to-many relationship between instructors and courses.

Preparing for Microsoft 98-364 Database Fundamentals? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free