Francisco Cruz

Generate statements (ddl) to create all objects

Three Create Statements

October 24, 2016 at 10:50 AM
Visible to public

Create Table Soccer_Players(

Player_ID Int(10),
Name VARCHAR(50),
Age Int(10),
Salary VARCHAR(100),
Net_Worth(100),
Team VARCHAR(100),
);

Create Table Stadiums(

Stadium_ID INT(10),
Name VARCHAR(100),
Capacity VARCHAR(100),
Location VARCHAR(100)
);

Create Table Leagues(

League_id Int(10),
Name VARCHAR(100),
Number_of_Teams INT(10),
YOB INT,
Location VARCHAR(100)
);