Question: If you are designing a relational database to keep track of the personal information and the grade of each student of each course they've taken
If you are designing a relational database to keep track of the personal information and the grade of each student of each course they've taken at the University of Windsor. You devised two tables to hold the data. In Table 1, you keep track of the gender, year of the entrance, family name, and given name, in Table 2, you keep track of the semester, course ID, and grade for each student. Which of the following statements make sense? Select 2 correct answer(s) The student ID serves as a good unique (primary) key for Table 1. Table 1 should include the course ID so that one can look up the grade a student has taken. The student ID serves as a good unique (primary) key for Table 2. Table 2 should include the student ID so that one can search for the names of the students who have taken certain courses in a certain semester. We should not use two tables but merge the two into one and use the student ID as the unique (primary) key
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
