Answer the following questions using the course registration database system diagrammed earlier:

a. Imagine you also want to keep track of student majors. How would you do this? Would you modify an existing table? Would you add new tables? Why or why not?

b. Why do you suppose the system needs a “Course Title” table?

c. This database is simplified for our brief introduction. What additional data would you need to keep track of if this were a real course registration system? What changes would you make in the database above to account for these needs?

d. Why do you need a STUDENT_ID? Why don’t you just use a student’s last name?

e. Could you use Social Security number as a STUDENT_ID? Why or why not?