S2gYiSuN

1CREATE TABLE IF NOT EXISTS competition 
2(competition_id INT NOT NULL AUTO_INCREMENT, 
3 competition_name VARCHAR(100), world_record INT,
4 set_date DATE, PRIMARY KEY(competition_id));
5 
6CREATE TABLE IF NOT EXISTS result
7(competition_id INT,
8sportsman_id INT NOT NULL AUTO_INCREMENT,
9result INT, city VARCHAR(100), hold_date DATE, PRIMARY KEY(sportsman_id));
10
11CREATE TABLE IF NOT EXISTS sportsman
12(sportsman_id INT NOT NULL AUTO_INCREMENT,
13sportsman_name VARCHAR(100), rank INT, year_of_birth YEAR,
14personal_record INT, country VARCHAR(100), PRIMARY KEY(sportsman_id));
15
16INSERT INTO competition (competition_name, world_record, set_date)
17VALUES ("name1", RAND()*1000, 20080103),
18("name2", RAND()*1000, 20070502),
19("name3", RAND()*1000, 20111010);
20
21INSERT INTO result (competition_id, result, city, hold_date)
22VALUES (1, RAND()*1000, "Moscow", 20090306), 
23(2, RAND()*1000, "Tokyo", 20110326), 
24(3, RAND()*1000, "Rome", 20070402);
25
26
27INSERT INTO sportsman (sportsman_name, rank, year_of_birth, personal_record, country)
28VALUES ("name1", RAND()*100, 1999, RAND()*1000, "Russia"), 
29("name2", RAND()*100, 1999, RAND()*1000, "Japan"), 
30("name3", RAND()*100, 1999, RAND()*1000, "Italy");