CREATE TABLE "course"
(
    course_id INTEGER
        constraint course_pk
            primary key,
    name      TEXT,
    credit    INTEGER,
    diff      INTEGER
);
course
CREATE TABLE prof
(
    prof_id         INTEGER
        constraint prof_pk
            primary key,
    gender          TEXT,
    first_name      TEXT,
    last_name       TEXT,
    email           TEXT,
    popularity      INTEGER,
    teachingability INTEGER,
    graduate_from   TEXT
);
prof
CREATE TABLE RA
(
    student_id INTEGER,
    capability INTEGER,
    prof_id    INTEGER,
    salary     TEXT,
    primary key (student_id, prof_id),
    foreign key (prof_id) references prof(prof_id),
    foreign key (student_id) references student(student_id)
);
RA
CREATE TABLE registration
(
    course_id  INTEGER,
    student_id INTEGER,
    grade      TEXT,
    sat        INTEGER,
    primary key (course_id, student_id),
    foreign key (course_id) references course(course_id),
    foreign key (student_id) references student(student_id)
);
registration
CREATE TABLE student
(
    student_id   INTEGER
            primary key,
    f_name       TEXT,
    l_name       TEXT,
    phone_number TEXT,
    email        TEXT,
    intelligence INTEGER,
    gpa          REAL,
    type         TEXT
);
student
original_column_name,column_name,column_description,data_format,value_description
student_id,student id,the id numbe representing each student,integer,
capability,,"the capability of student on research
(Evaluated by the professor)",integer,higher --> higher research ability / capability
prof_id,professor id,professor who advises this student,integer,"this value may be repetitive since one professor may advise many students in this semester
commonsense evidence:
if a professor advise > 2 students in this semester, it means this professor's research work is heavy
or: this professor's popularity on research is higher"
salary,,the salary of this student.,text,"med: average salary
high: higher salary than others
low: lower salary
free: unpaid RA"
RA
original_column_name,column_name,column_description,data_format,value_description
student_id,student id,the unique id to identify students,integer,
f_name,first name,the first name of the student,text,
l_name,last name,the last name of the student,text,"commonsense evidence:
full name: f_name, l_name"
phone_number,phone number ,phone number,text,
email,,email ,text,
intelligence,,intelligence of the student,integer,higher --> more intelligent
gpa,graduate point average,gpa ,real,
type,,type of the student,text," TPG: taught postgraduate student(master)
 RPG: research postgraduate student (master)
 UG: undergraduate student(bachelor)
commonsense evidence:
both TPG and RPG are students pursuing a masters degree; UG are students pursuing the bachelor degree"
student
original_column_name,column_name,column_description,data_format,value_description
course_id,course id,the id of courses,integer,
student_id,student id,the id of students,integer,
grade,,the grades that the students acquire in this course,text,"commonsense evidence:
 A: excellent -- 4
 B: good -- 3
 C: fair -- 2
 D: poorly pass -- 1
 null or empty: this student fails to pass this course
 gpa of students for this semester = sum (credits x grade) / sum (credits)"
sat,satisfying degree,student satisfaction with the course,integer,
registration
original_column_name,column_name,column_description,data_format,value_description
course_id,course id,unique id representing the course,integer,
name,,name of the course,text,
credit,,credit of the course,integer,"commonsense evidence:
higher means more important"
diff,difficulty,difficulty of the course,integer,"commonsense evidence:
higher --> more difficult
smaller --> less difficult"
course
original_column_name,column_name,column_description,data_format,value_description
prof_id,professor id,unique id for professors,integer,
gender,gender,gender of the professor,text,
first_name,first name,the first name of the professor,text,
last_name,last name,the last name of the professor ,text,"commonsense evidence:
full name: first name, last name"
email,,email of the professor,text,
popularity,,popularity of the professor,integer,"commonsense evidence:
higher --> more popular"
teachingability,teaching ability,the teaching ability of the professor,integer,"commonsense evidence:
higher --> more teaching ability, his / her lectures may have better quality"
graduate_from,graduate from,the school where the professor graduated from,text,
prof