CREATE DATABASE NBA;

USE NBA;

CREATE TABLE equipos(

Nombre varchar(20)NOT NULL,
ciudad varchar(20)DEFAULT NULL,
Conferencia varchar(4)DEFAULT NULL,
Divicion varchar(9)DEFAULT NULL,
PRIMARY KEY(Nombre)
)engine=innodb;

INSERT INTO equipos VALUES('Nets','New Jersey','East','Atlantic');

INSERT INTO equipos VALUES('Knicks','New York','East','Atlantic');
INSERT INTO equipos VALUES('Pistons','Detroit','East','Central');
INSERT INTO equipos VALUES('Cavaliers','Cleveland','East','Central');
INSERT INTO equipos VALUES('Pacers','Indiana','East','Central');
INSERT INTO equipos VALUES('Bulls','Chicago','East','Central');
INSERT INTO equipos VALUES('Bucks','Milwaukee','East','Central');
INSERT INTO equipos VALUES('Magic','Orlando','East','SouthEast');
INSERT INTO equipos VALUES('Wizards','Washington','East','SouthEast');
INSERT INTO equipos VALUES('Hawks','Atlanta','East','SouthEast');
INSERT INTO equipos VALUES('Bobcasts','Charlotte','East','SouthEast');
INSERT INTO equipos VALUES('Heat','Miami','East','SouthEast');
INSERT INTO equipos VALUES('Jazz','Utah','West','NorthWest');
INSERT INTO equipos VALUES('Nuggets','Denver','West','NorthWest');
INSERT INTO equipos VALUES('Trail Blazers','Portland','West','NorthWest');
INSERT INTO equipos VALUES('Timberwolves','Minnesota','West','NorthWestLT');
INSERT INTO equipos VALUES('Celtics','Boston','East','Atlantic');
INSERT INTO equipos VALUES('Raptors','Toronto','East','Atlantic');
INSERT INTO equipos VALUES('76ers','Philadelphia','East','Atlantic');
INSERT INTO equipos VALUES('Supersonics','Seattle','West','NorthWest');
INSERT INTO equipos VALUES('Laker','Los Angeles','West','Pacific');

CREATE TABLE jugadores(

codigo int NOT NULL,
Nombre varchar(30)DEFAULT NULL,
Procedencia varchar(20)DEFAULT NULL,
Altura varchar(4)NULL,
Peso int DEFAULT NULL,
Posicion varchar(5)DEFAULT NULL,
Nombre_equpo varchar(20)DEFAULT NULL,
PRIMARY KEY(codigo),
FOREIGN KEY(Nombre_equipos)References(Nombre)
)engine=innodb;

INSERT INTO jugadores VALUES(1,'Corey Brever','Florida','6-9',185,'F-

G','Timberwolves');
INSERT INTO jugadores VALUES(2,'Greg Buckner','Clemson','6-4',210,'G-
F','Timberwolves');
INSERT INTO jugadores VALUES(3,'Michael Doleac','Utah','6-
11',262,'C','Timberwolves');
INSERT INTO jugadores VALUES(4,'Randy Foye','Villanova','6-
4',213,'G','Timberwolves');
INSERT INTO jugadores VALUES(5,'Randy Foye','Providence','6-
7',250,'F','Timberwolves');
INSERT INTO jugadores VALUES(6,'Marko Jaric','Serbia','6-
7',224,'G','Timberwolves');
INSERT INTO jugadores VALUES(7,'Al Jefferson','Prentiss Hs','6-10',265,'C-
F','Timberwolves');
INSERT INTO jugadores VALUES(8,'Mark Madsen','Stanford','6-9',250,'C-
F','Timberwolves');
INSERT INTO jugadores VALUES(9,'Rashard McCants','North Carolina','6-
4',21,'G','Timberwolves');
INSERT INTO jugadores VALUES(10,'Chris Richard','Florida','6-
9',270,'F','Timberwolves');
INSERT INTO jugadores VALUES(11,'Craig Smith','Boston College','6-8',250,'F-
C','Timberwolves');
INSERT INTO jugadores VALUES(12,'Kirk Snyder','Nevada-Reno','6-
6',225,'G','Timberwolves');
INSERT INTO jugadores VALUES(13,'Sebastian Telfair','Abraham Lincoln HS','6-
0',175,'G','Timberwolves');
INSERT INTO jugadores VALUES(14,'Antoine Walker','Kentucky','6-
9',245,'F','Timberwolves');

INSERT INTO jugadores VALUES(21,'Elton brand','duke','6-8',254,'F','Clippers');

INSERT INTO jugadores VALUES(22,'Paul Davis','Michigan','6-11',270,'C','Clippers');
INSERT INTO jugadores VALUES(23,'Dan Dickau','Gonzaga','6-0',180,'G','Clippers');
INSERT INTO jugadores VALUES(24,'Nick Fazekas','Nevada-Reno','6-
11',235,'F','Clippers');
INSERT INTO jugadores VALUES(25,'Chris Kaman','Central Michigan','7-
0',265,'C','Clippers');
INSERT INTO jugadores VALUES(26,'Brevin Knight','Stanford','5-
10',170,'G','Clippers');
INSERT INTO jugadores VALUES(27,'Shaun Livingston','Peoria Central','6-
7',182,'G','Clippers');
INSERT INTO jugadores VALUES(28,'Corey Maggette','duke','6-6',225,'F','Clippers');
INSERT INTO jugadores VALUES(29,'Cuttino Mobley','Rhode Island','6-
4',215,'G','Clippers');
INSERT INTO jugadores VALUES(30,'Smush Parker','Fordham','6-4',190,'G','Clippers');
INSERT INTO jugadores VALUES(31,'Josh Powell','North Carolina State','6-9',240,'C-
F','Clippers');
INSERT INTO jugadores VALUES(32,'Quinton Ross','Souther Methodist','6-6',193,'G-
F','Clippers');
INSERT INTO jugadores VALUES(33,'Timberwolves','Villanova','6-
10',240,'F','Clippers');
INSERT INTO jugadores VALUES(34,'al thornton','Florida State','6-
8',220,'F','Clippers');
INSERT INTO jugadores VALUES(35,'Marcus Willliams','Arizona','6-
7',207,'F','Clippers');

INSERT INTO jugadores VALUES(41,'Andre Brown','De Paul','6-9',245,'F','Grizzlies');

INSERT INTO jugadores VALUES(42,'Kwame Brown','Glynn Academy','6-
11',270,'C','Grizzlies');
INSERT INTO jugadores VALUES(43,'Brian Cardinal','Purdue','6-
8',245,'F','Grizzlies');
INSERT INTO jugadores VALUES(44,'Jason Collins','Stanford','7-0',255,'C-
F','Grizzlies');
INSERT INTO jugadores VALUES(45,'Mike Conley','Ohin State','6-
1',180,'G','Grizzlies');
INSERT INTO jugadores VALUES(46,'Javaris Crittenton','Georgia Tech','6-
5',200,'G','Grizzlies');
INSERT INTO jugadores VALUES(47,'Rudy Gay','Connecticut','6-
8',222,'F','Grizzlies');
INSERT INTO jugadores VALUES(48,'Casey Jacobsen','Stanford','6-
6',215,'g','Grizzlies');
INSERT INTO jugadores VALUES(49,'Kyle Lowry','Villanova','6-
0',175,'G','Grizzlies');
INSERT INTO jugadores VALUES(50,'Aaron Mckie','Temple','6-5',209,'G','Grizzlies');
INSERT INTO jugadores VALUES(51,'Darko Milicic','Serbia Montenegro','7-0',275,'C-
F','Grizzlies');
INSERT INTO jugadores VALUES(52,'Mike Miller','Florida','6-8',218,'G-
F','Grizzlies');
INSERT INTO jugadores VALUES(53,'Juan Carlos Navarro','Spain','6-
3',170,'G','Grizzlies');
INSERT INTO jugadores VALUES(54,'Hakim Warrick','Syracuse','6-
9',215,'F','Grizzlies');

INSERT INTO jugadores VALUES(61,'Trevor Ariza','UCLA','6-8',210,'F','Lakers');

INSERT INTO jugadores VALUES(62,'Kobe Bryant','Lower Merion HS(PA)','6-
6',205,'G','Lakers');
INSERT INTO jugadores VALUES(63,'Andrew Bynum','[Link] HS(NJ)','7-
0',285,'C','Lakers');
INSERT INTO jugadores VALUES(64,'Jordan Farmar','UCLA','6-2',180,'G','Lakers');
INSERT INTO jugadores VALUES(65,'Derek Fisher','[Link] Rock','6-
1',210,'G','Lakers');
INSERT INTO jugadores VALUES(66,'Pau Gasol','Spain','7-0',250,'F-C','Lakers');
INSERT INTO jugadores VALUES(67,'Didier llunga-Mbenga','Congo','7-
0',255,'C','Lakers');
INSERT INTO jugadores VALUES(68,'Coby Kal','Boise State','6-5',215,'G','Lakers');
INSERT INTO jugadores VALUES(69,'Chris Mihm','Texas','7-0',265,'C','Lakers');

CREATE TABLE estadisticas(

temporada varchar(5)NOT NULL,
jugador int NOT NULL,
Puntos_por_partido float DEFAULT NULL,
Asistencias_por_partido float DEFAULT NULL,
Tapones_por_partido float DEFAULT NULL,
Rebotes_por_partido float DEFAULT NULL,
PRIMARY KEY(temporada,jugador),
FOREIGN KEY(jugador)REFERENCES jugadores(codigo)
)engine=innodb;

INSERT INTO estadisticas VALUES('03/04',283,5.9,2.2,1.54,1.6);

INSERT INTO estadisticas VALUES('04/05',283,4.6,1.8,0.98,1.6);
INSERT INTO estadisticas VALUES('05/06',283,12,4.7,2.4,2.9);
INSERT INTO estadisticas VALUES('06/07',283,4.9,1.3,0.89,0.8);
INSERT INTO estadisticas VALUES('05/06',85,5.5,4.5,0.1,2.2);
INSERT INTO estadisticas VALUES('06/07',85,8.7,5,0.1,1.7);
INSERT INTO estadisticas VALUES('07/08',283,9.5,3,1.33,2.1);
INSERT INTO estadisticas VALUES('07/08',85,11.6,8.2,0.1,2.9);
INSERT INTO estadisticas VALUES('03/04',580,7.9,2.4,0.1,1,8);
INSERT INTO estadisticas VALUES('05/06',580,13.1,2.8,0.1,2.6);
INSERT INTO estadisticas VALUES('06/07',64,4.4,1.9,0.1,1.7);
INSERT INTO estadisticas VALUES('06/07',580,18.1,4,0.2,2.7);
INSERT INTO estadisticas VALUES('07/08',580,15.8,2.7,0.2,2.4);
INSERT INTO estadisticas VALUES('07/08',441,4.3,1.3,0,1.1);
INSERT INTO estadisticas VALUES('07/08',64,9.1,2.7,0.1,2.2);
INSERT INTO estadisticas VALUES('07/08',81,10.2,1.2,0.4,3.8);
INSERT INTO estadisticas VALUES('06/07',24,1,0,0,0.8);
INSERT INTO estadisticas VALUES('03/04',601,4.5,1.3,0.1,4);
INSERT INTO estadisticas VALUES('04/05',601,3.8,1.3,0.2,3.1);
INSERT INTO estadisticas VALUES('05/06',601,3,0.4,0.1,1.9);
INSERT INTO estadisticas VALUES('96/97',483,14.8,1.5,2.1,6.3);
INSERT INTO estadisticas VALUES('07/08',591,2.2,0.7,0.2,0.7);
INSERT INTO estadisticas VALUES('06/07',601,9.8,2.1,0.5,4.6);
INSERT INTO estadisticas VALUES('97/98',483,12.1,1.8,3.7,7.4);
INSERT INTO estadisticas VALUES('98/99',483,7.2,0.3,1.6,5.5);
INSERT INTO estadisticas VALUES('99/00',483,10.2,0.8,2,7.8);
INSERT INTO estadisticas VALUES('00/01',483,12,0.8,2.2,11.5);
INSERT INTO estadisticas VALUES('01/02',483,11.1,1.1,1.7,11.1);
INSERT INTO estadisticas VALUES('02/03',483,7.6,1.6,1.4,7.2);
INSERT INTO estadisticas VALUES('03/04',483,8.6,1.8,2,6,10.1);
INSERT INTO estadisticas VALUES('07/08',24,4.3,0.6,0.5,3.7);
INSERT INTO estadisticas VALUES('04/05',483,10.3,2.3,3,10);
INSERT INTO estadisticas VALUES('05/06',483,12.8,2.1,3.3,11.9);
INSERT INTO estadisticas VALUES('07/08',601,6.8,2,1.21,4.5);
INSERT INTO estadisticas VALUES('06/07',483,11.2,3.2,3.3,11.7);
INSERT INTO estadisticas VALUES('07/08',483,9.3,3.3,3.3,13.3);
INSERT INTO estadisticas VALUES('07/08',443,6.1,0.9,1.5,7.6);
INSERT INTO estadisticas VALUES('05/06',284,1.6,0,0,1.3);
INSERT INTO estadisticas VALUES('06/07',284,2.3,0.2,0.1,1.5);
INSERT INTO estadisticas VALUES('06/07',443,7.1,0.6,1.1,7.4);
INSERT INTO estadisticas VALUES('05/06',443,5.7,0.6,1.3,7.8);
INSERT INTO estadisticas VALUES('07/08',186,14.1,7.2,0.2,2,9);
INSERT INTO estadisticas VALUES('07/08',284,6.3,0.6,0.2,4.1);
INSERT INTO estadisticas VALUES('04/05',443,9.2,0.9,1.4,8.5);
INSERT INTO estadisticas VALUES('07/08',504,1.6,0.2,0.3,2.8);
INSERT INTO estadisticas VALUES('95/96',361,10.1,2.9,0.3,2.1);
INSERT INTO estadisticas VALUES('96/97',361,7.5,2.6,0.2,1.9);
INSERT INTO estadisticas VALUES('97/98',361,4.1,1,2,0.2,1.6);
INSERT INTO estadisticas VALUES('03/04',443,12.3,0.8,1,9,12);
INSERT INTO estadisticas VALUES('98/99',361,11.1,3.1,0.3,3.8);
INSERT INTO estadisticas VALUES('99/00',361,11.8,3.6,0.4,4.7);
INSERT INTO estadisticas VALUES('00/01',361,8.8,34,0.2,3.1);
INSERT INTO estadisticas VALUES('95/96',365,15,3.5,0.4,4.6);
INSERT INTO estadisticas VALUES('96/97',365,13,2.5,0.2,4.4);
INSERT INTO estadisticas VALUES('01/02',361,14.4,5.3,0.5,5.4);
INSERT INTO estadisticas VALUES('98/99',365,16,2.8,0.4,4.5);
INSERT INTO estadisticas VALUES('99/00',365,21.5,4.9,0.4,5.3);
INSERT INTO estadisticas VALUES('00/01',365,20.2,4.4,0.3,5.3);

CREATE TABLE partidos(

codigo int NOT NULL,
equipo_local varchar(20)DEFAULT NULL,
equpo_visitante varchar(20)DEFAULT NULL,
puntos_local int DEFAULT NULL,
puntos_visitante int DEFAULT NULL,
temporada varchar(5)DEFAULT NULL,
PRIMARY KEY(codigo),
FOREIGN KEY(equipo_local)REFERENCES equipos(nombre),
FOREIGN KEY(equipo_visitante)REFERENCES equipos(nombre)
)engine=innodb;

INSERT INTO partidos VALUES (1,'Raptors','Lakers',74,117,'98/99');

INSERT INTO partidos VALUES (2,'Raptors','Grizzlies',70,118,'98/99');
INSERT INTO partidos VALUES (3,'Raptors','Clippers',105,76,'98/99');
INSERT INTO partidos VALUES (4,'Raptors','Knicks',62,124,'98/99');
INSERT INTO partidos VALUES (5,'Raptors','Timberwolves',66,68,'98/99');
INSERT INTO partidos VALUES (6,'Raptors','Celtics',52,69,'98/99');
INSERT INTO partidos VALUES (7,'Raptors','76ers',74,103,'98/99');
INSERT INTO partidos VALUES (8,'Raptors','Nets',121,129,'98/99');
INSERT INTO partidos VALUES (9,'Raptors','Pistons',100,85,'98/99');
INSERT INTO partidos VALUES (10,'Raptors','Cavaliers',129,158,'98/99');
INSERT INTO partidos VALUES (11,'Raptors','Pacers',100,70,'98/99');
INSERT INTO partidos VALUES (12,'Raptors','Bulls',134,69,'98/99');
INSERT INTO partidos VALUES (13,'Raptors','Bucks',66,118,'98/99');
INSERT INTO partidos VALUES (14,'Raptors','Magic',74,140,'98/99');
INSERT INTO partidos VALUES (15,'Raptors','Wizards',101,61,'98/99');
INSERT INTO partidos VALUES (16,'Raptors','Hawks',128,139,'98/99');
INSERT INTO partidos VALUES (17,'Raptors','Bobcats',88,68,'98/99');
INSERT INTO partidos VALUES (18,'Raptors','Heat',125,119,'98/99');
INSERT INTO partidos VALUES (19,'Raptors','Jazz',147,138,'98/99');
INSERT INTO partidos VALUES (20,'Raptors','Nuggets',74,147,'98/99');
INSERT INTO partidos VALUES (21,'Raptors','Trail Blazers',140,64,'98/99');
INSERT INTO partidos VALUES (22,'Raptors','Supersonics',59,59,'98/99');
INSERT INTO partidos VALUES (23,'Raptors','Warriors',76,74,'98/99');
INSERT INTO partidos VALUES (24,'Raptors','Kings',57,115,'98/99');
INSERT INTO partidos VALUES (25,'Raptors','Hornets',104,82,'98/99');
INSERT INTO partidos VALUES (26,'Raptors','Spurs',116,51,'98/99');
INSERT INTO partidos VALUES (27,'Raptors','Rockets',99,59,'98/99');
INSERT INTO partidos VALUES (28,'Raptors','Mavericks',108,113,'98/99');
INSERT INTO partidos VALUES (29,'Raptors','Suns',149,102,'98/99');
INSERT INTO partidos VALUES (30,'Lakers','Raptors',76,158,'98/99');
INSERT INTO partidos VALUES (31,'Lakers','Grizzlies',86,99,'98/99');
INSERT INTO partidos VALUES (32,'Lakers','Clippers',151,98,'98/99');
INSERT INTO partidos VALUES (33,'Lakers','Knicks',133,63,'98/99');
INSERT INTO partidos VALUES (34,'Lakers','Timberwolves',75,137,'98/99');
INSERT INTO partidos VALUES (35,'Lakers','Celtics',58,74,'98/99');
INSERT INTO partidos VALUES (36,'Lakers','76ers',55,75,'98/99');
INSERT INTO partidos VALUES (37,'Lakers','Nets',92,127,'98/99');
INSERT INTO partidos VALUES (38,'Lakers','Pistons',114,147,'98/99');
INSERT INTO partidos VALUES (39,'Lakers','Cavaliers',136,118,'98/99');
INSERT INTO partidos VALUES (40,'Lakers','Pacers',130,156,'98/99');
INSERT INTO partidos VALUES (41,'Lakers','Bulls',79,83,'98/99');
INSERT INTO partidos VALUES (42,'Lakers','Bucks',114,153,'98/99');
INSERT INTO partidos VALUES (43,'Lakers','Magic',153,127,'98/99');
INSERT INTO partidos VALUES (44,'Lakers','Wizards',86,62,'98/99');
INSERT INTO partidos VALUES (45,'Lakers','Hawks',105,59,'98/99');
INSERT INTO partidos VALUES (46,'Lakers','Bobcats',80,87,'98/99');
INSERT INTO partidos VALUES (47,'Lakers','Heat',150,143,'98/99');
INSERT INTO partidos VALUES (48,'Lakers','Jazz',73,58,'98/99');