
 create database db1;
 use db1;
 create table Employees ( ssn CHAR(11) PRIMARY KEY, name varchar(45), age INT) engine=innodb;
 create table Departments (did INTEGER PRIMARY KEY, dname varchar(45), budget DOUBLE) engine=innodb;
 create table Locations (address CHAR(20) PRIMARY KEY, capacity BIGINT) engine=innodb;
 
 CREATE TABLE Works_In ( ssn     CHAR(11),
                          did     INTEGER,
                          address CHAR(20),
                          since   DATE,
                          PRIMARY KEY (ssn, did, address),
                          FOREIGN KEY (ssn) REFERENCES Employees,
                          FOREIGN KEY (address) REFERENCES Locations,
                          FOREIGN KEY (did) REFERENCES Departments ) engine=innodb;
 
 
 
 

