5YdBXZXK

1Create Database if not exists Research;
2Use Research;
3
4Create table if not exists CompanyInfo
5(
6CID int primary key, Company varchar(45), 
7SIC int, InnovativeIndex int
8) 
9engine = innodb;
10
11Create table if not exists TimePeriod
12(
13Year int primary key, GDP int, GDPgrowth int, 
14inflation decimal(5,2), unemployment decimal(5,2)
15) 
16engine = innodb;
17
18Create Table If not exists CompanyRank 
19(
20CID int, Year int, IndexYN int, SPRank int, FortuneRank int, 
21primary key (CID, Year), index (CID), Index(year),
22foreign key (CID) references CompanyInfo.CID,
23foreign key (Year) references TimePeriod.Year
24) 
25engine = innodb; 
26     
27Create Table If not exists CompanyRank
28(
29CID int, Year int, IndexYN int, SPRank int, FortuneRank int,
30primary key (CID, Year), index (CID), Index(year),
31foreign key (CID) references CompanyInfo (CID),
32foreign key (Year) references TimePeriod (Year)
33) engine = innodb;