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 standard information such as student ID, name, and address, and the other containing student ID and immunization dates for required immunizations, one record per student. 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 standard information such as student ID, name, and address, and the other containing student ID and immunization dates for required immunizations, one record per student. 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 standard information such as student ID, name, and address, and the other containing student ID and immunization dates for required immunizations, one record per student. What would be the proper relationship between the tables?

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