


--
-- Table of grades, containing, ID, course code and grade (A,B+,B,C+,C,D+,D,F)
--

--
-- Assume database already exists, e.g. created in mysql as
-- CREATE DATABASE dbname;
--

CREATE TABLE `coursegrades` (
`studentid` VARCHAR(20) NOT NULL,
`coursecode` VARCHAR(10) NOT NULL,
`grade` VARCHAR(3) NOT NULL,
PRIMARY KEY (`studentid`,`coursecode`)
);
INSERT INTO `coursegrades` VALUES 
('5012345678','its335','A'),
('5012345678','css322','B'),
('5012345678','its323','C'),
('5000000000','its335','B+'),
('5000000000','css322','D+'),
('s1234567','coit20262','HD'),
('s1234567','coit20263','D'),
('s1234567','coit20264','C'),
('s0000000','coit20263','C'),
('s0000000','coit20262','F');
