SQL Tables

Students
StudentId	Int	Primary Key
StudentName	VarChar
StudentGPA	Numeric(5,2)
StudentMajor	VarChar
StudentPhone	VarChar

Courses
CourseId	Int	PrimaryKey
CourseName	VarChar
CourseNumber	Int
Semester	Char
Year	Int
Credit_Hours	Int

Professor
ProfId	Int	PrimaryKey
ProfName	Varchar
Department	VarChar

Takes
StudentId	Int	Foreign Key Students
CourseId	Int	ForeignKey Courses
Grade	Char	A,B,C,D, or F

Teaches
ProfId	Int	Foreign Key Professors
CourseId	Int	Foriegn Key Courses
Room	VarChar

Advises
StudentId	Int	Foreign Key Students
ProfId	Int	ForeignKey Professor