A school tracks students in its database as follows: Studentld FirstName LastName Last 4 of SSN 123456 Mary 123457…

A school tracks students in its database as follows: Studentld FirstName LastName Last 4 of SSN 123456 Mary 123457…

Question:

 

Transcribed Image Text:

A school tracks students in its database as follows: Studentld FirstName LastName Last 4 of SSN 123456 Mary 123457 Jamie 123458 John Smith 1111 Jameson 2222 Jones 3333 Email Degree Major smithm@school.edu BS jameson@school.ed BA u jones@school.edu BS Business Criminal Justice Business a. Some students wish to pursue a minor. What changes would the school need to make to its database to keep track of students who pursue a major and a minor? You can enter a descriptive explanation with conceptual diagrams to support your proposal : b. Some students wish to pursue double majors. What changes would the school need to make to the database to keep track of students who pursue double majors? You can enter a descriptive explanation with conceptual diagrams to support your proposal :

Expert Answer:

Answer rating: 100% (QA)

a School can create a new colum in the database which include the minors This will include those stu
View the full answer