/* If haven't already created the db: 
CREATE DATABASE StudentInformation;
USE Grades;
*/

/* Attempt to remove each of the tables in case this script 
   has already been run one. */

DROP TABLE Student;


/*********************************************************/

/* Create the Student table */
CREATE TABLE Student
(studentId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
fName CHAR(20),
lName CHAR(20),
score INT,
grade CHAR(2),
userName CHAR(15),
password CHAR(15));

/* Populate the Student table */
INSERT INTO Student 
	(fName, lName, score, grade, userName, password)
VALUES ('Celia','Schahczenski', 88, 'B', 'cschahc', 'secret');

INSERT INTO Student 
	(fName, lName, score, grade, userName, password)
VALUES ('Cal','Schmidt', 78, 'C', 'cschmidt', 'tallulah');

INSERT INTO Student 
	(fName, lName, score, grade, userName, password)
VALUES ('Celeste','Smith', 98, 'A', 'celeste', 'bosco');

INSERT INTO Student 
	(fName, lName, score, grade, userName, password)
VALUES ('Melody','Warner', 88, 'B', 'mwarener', 'gutenberg');

INSERT INTO Student 
	(fName, lName, score, grade, userName, password)
VALUES ('Maureen','Taft', 33, 'F', 'mtaft', 'wondering');

INSERT INTO Student 
	(fName, lName, score, grade, userName, password)
VALUES ('Janice','Toole', 68, 'D', 'jtoole', 'crunches');