You work in the registrar's office of a large university. You are responsible for creating a student database that contains students' ID numbers, names, addresses, phone numbers, and some medical information.
Suppose the student database includes two tables, one containing information on courses and the other containing information on students. One student can take many courses and one course can be taken by many students. What would be the proper relationship between the tables?

Question

You work in the registrar's office of a large university. You are responsible for creating a student database that contains students' ID numbers, names, addresses, phone numbers, and some medical information. 
Suppose the student database includes two tables, one containing information on courses and the other containing information on students. One student can take many courses and one course can be taken by many students. What would be the proper relationship between the tables?

Quizplus · Accepted Answer

The Answer of You work in the registrar's office of a large university. You are responsible for creating a student database that contains students' ID numbers, names, addresses, phone numbers, and some medical information. 
Suppose the student database includes two tables, one containing information on courses and the other containing information on students. One student can take many courses and one course can be taken by many students. What would be the proper relationship between the tables?

You Work in the Registrar's Office of a Large University