SQL statements

Student

PKStudent Number

Social Security Number

Name

DOB

Sex

Permanent Address

Permanent PhoneNumber

Current Address

Current PhoneNumber

Course

PKCourse ID

Name

Description

Hours

Level

Student_Course

PK,FK1Student Number

PK,FK2Course ID

Department

PKDept_ID

Name

Desciption

Phonenumber

Student_Dept

PK,FK1Student Number

PK,FK2Dept_ID

IsMajorDept

Section

PKSection_ID

PK,FK1Course ID

Instructor

Semester

Year

Grade_Report

PK,FK1Student Number

Letter_Grade

Numeric_Grade

FK2Section_ID

FK2Course ID

Previous_college

PK,FK1Course_ID

PK,FK2Student Number

PK,FK3Degree_ID

College_name

Start_date

End_date

Course_Taken

PKCourse_ID

Course_Hours

Grade_Earned

Course_Completed

Course_level

Degree

PKDegree_ID

Description

Duration

Table