
CREATE DATABASE LLC;

USE LLC;

CREATE TABLE  Team
(
tid 				VARCHAR(4),
dues				DOUBLE,
field				VARCHAR(25),
rank 				INT,
name				VARCHAR(30),

CONSTRAINT Team_PK  PRIMARY KEY (tid)  

);

CREATE TABLE Coach
(
cid					VARCHAR(4),
role				VARCHAR(15),
name 				VARCHAR(50),
tid_FK				VARCHAR(4),

CONSTRAINT Coach_PK PRIMARY KEY (cid), 
CONSTRAINT Coach_FK1 Foreign KEY (tid_FK)
REFERENCES TEAM(tid)
);

