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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Chemistry Questions!