Tables

startdb.sh

mysql --user=cs4010 --password=cs4010 --database=cs4010

test0.sql 

CREATE TABLE student
(
student_id int NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
year varchar(20),
test int,
PRIMARY KEY (student_id)
)

test1.sql

insert into student  (name,year,test) values ("Joe Jones","Senior",85)

test2.sql

CREATE TABLE athlete
(
this_student int NOT NULL,
Foreign KEY(this_student) REFERENCES student(student_id),
sport varchar(255) NOT NULL
)