data

majorstudent (majorcode varchar2(2), gradcrs number(4))

student (studentcode number(4), majorcode varchar2(2), numcredits number(7)

creditsneed (studentcode number(4), needcr number(3))