iF5qyeY6

1DROP DATABASE IF exists skillsoft;
2CREATE DATABASE skillsoft;
3
4USE skillsoft;
5
6     
7Drop TABLE if exists `Student`;
8create TABLE if NOT Exists `Student` (
9	`StudentNo` int(10) not null,
10    `Name` varchar(10),
11    `Surname` varchar(10),
12    primary key(`StudentNo`)
13	) ENGINE=InnoDB CHARSET=utf8; 
14    
15Drop TABLE if exists `Course`;
16create TABLE if NOT Exists `Course` (
17	`StudyArea` varchar(10),
18    `SeriesTitle` varchar(10),
19    `CourseNumber` int (10) not null,
20    `CourseTitle` varchar(100),
21    `CourseID` varchar (20),
22    primary key(`CourseNumber`)
23	) ENGINE=InnoDB CHARSET=utf8;
24
25
26Drop TABLE if exists `ACE`;
27create TABLE if NOT Exists `ACE` (
28	`Ace Reference No` varchar(10) not null,
29    `Credit hours` varchar (7),
30    `level of approval` varchar(10),
31    `Retirment Date` varchar(10),
32    primary key (`Ace Reference No`)
33    ) ENGINE=InnoDB CHARSET=utf8;
34    
35Drop TABLE if exists `Records`;
36create TABLE if NOT Exists `Records` (
37	`RecordsNo` int (5) not null,
38	`CourseNumber` int (10) not null,
39    `StudentNo` int(10) not null,
40    `year` int(4),
41    `grade` varchar(1),
42    primary key (`RecordsNo`),
43    FOREIGN KEY (`StudentNo`) REFERENCES Student.StudentNo,
44    FOREIGN KEY (`CourseNumber`) REFERENCES Course.CourseNumber
45    ) ENGINE=InnoDB CHARSET=utf8;