bKv2biXV

1create table address (address_id int not null primary key, city varchar(50), street varchar(50), zip varchar(6));
2
3insert into address (address_id, city, street, zip)
4values
5(1,'Lublin','Bursaki','20-201'),
6(2,'Warszawa','Warszawska','80-123'),
7(3,'Londyn','Angielska','12-111'),
8(4,'Poznan','Ogrodowa','99-999'),
9(5,'Lublin','Zwiazkowa','11-111'),
10(6,'Warszawa','Mickiewicza','45-167'),
11(7,'Wroclaw','Lesna','90-100'),
12(8,'Krakow','Ogrodowa','45-353'),
13(9,'Katowice','Slowackiego','33-333'),
14(10,'Lublin','Lipowa','21-123');
15
16create table Personal_data 
17(id int primary key auto_increment, 
18firstname varchar(20) not null, 
19lastname varchar(20) not null, 
20age int not null);
21
22insert into Personal_data ( firstname, lastname, age)
23values
24( 'Adam', 'Kowalski', '35'),
25( 'Anna', 'Nowak', '34'),
26( 'Stanislaw', 'Kowal', '77'),
27( 'Helena', 'Kowal', '75'),
28( 'Victoria', 'Nowak', '16'),
29( 'Janusz', 'Kowalski', '65'),
30( 'GraÅ…yna', 'Kowalska', '63'),
31( 'Jan', 'Nowak', '11'),
32( 'Asia', 'Nowak', '4'),
33( 'Grzegorz', 'Nowak', '36'),
34( 'Monika', 'Kowalska', '35'); 
35
36create table Phones(phone_id int not null primary key, number varchar(15));
37
38insert into phones(phone_id, number)
39values
40(1, '748573647'),
41(2, '827938744'),
42(3, '746289347'),
43(4, '823478324'),
44(5, '425435266'),
45(6, '154534532'),
46(7, '324325321'),
47(8, '325145543'),
48(9, '345435311'),
49(10, '123123144');
50
51create table Events(
52event_id int not null,
53name VARCHAR(45) not null,
54category VARCHAR(45),
55country VARCHAR(45),
56city VARCHAR(45)
57);
58
59insert into Events
60values
61(1, 'Music festival', 'music', 'Niemcy', 'Berlin'),
62(2, 'Fire', 'art', 'Poland', 'Warszawa'),
63(3, 'Jarmark jagielonski', 'food', 'Poland', 'Lublin'),
64(4, 'Sztukmistrzow', 'art', 'Poland', 'Lublin'),
65(5, 'Opener', 'music', 'Poland', 'Gdynia'),
66(6, 'Exotic cars', 'cars', 'Czechy', 'Praga'),
67(7, 'Poland rock', 'music', 'Poland', 'Kostrzyn'),
68(8, 'Festiwal smakow', 'food', 'Poland', 'Katowice'),
69(9, 'International motorshow', 'car', 'Szwajcaria', 'Geneva'),
70(10, 'Orange Warsaw', 'music', 'Poland', 'Warszawa');
71
72
73
74CREATE TABLE IF NOT EXISTS events (event_name VARCHAR(255), start_date date not null, end_date date not null, PRIMARY KEY (event_name));
75
76INSERT INTO events VALUES
77("Boze Narodzenie", "2018-12-25", "2018-12-26"),
78("Wielkanoc", "2019-04-21", "2019-04-22"),
79("Walentynki", "2019-02-14", "2019-02-14"),
80("Dzien studenta", "2018-11-17", "2018-11-17"),
81("Wakacje", "2019-06-21", "2019-09-30"),
82("Sesja zimowa", "2019-02-05", "2019-02-14"),
83("Sesja letnia", "2019-07-01", "2019-07-12"),
84("Sesja poprawkowa zimowa", "2019-02-20", "2019-03-01"),
85("Sesja poprawkowa letnia", "2019-07-16", "2019-07-26"),
86("Przerwa Noworoczna", "2018-12-30", "2019-01-01");
87
88create table Students (student_id int not null primary key, kierunek varchar(35) not null, tryb varchar(35) not null, data_rozpoczecia date not null);
89
90insert into Students
91values
92(1, 'Informatyka', 'st', '2016-10-01'),
93(2, 'Transport', 'nst', '2016-10-01'),
94(3, 'Administracja', 'st', '2016-10-01'),
95(4, 'Zarzadzanie', 'st', '2016-10-01'),
96(5, 'Informatyka', 'nst', '2016-10-01'),
97(6, 'Administracja', 'st', '2016-10-01'),
98(7, 'Transport', 'nst', '2016-10-01'),
99(8, 'Informatyka', 'st', '2017-10-01'),
100(9, 'Zarzadzanie', 'nst', '2017-10-01'),
101(10, 'Informatyka', 'st', '2017-10-01'),
102(11, 'Informatyka', 'st', '2016-10-01'),
103(12, 'Transport', 'nst', '2017-10-01'),
104(13, 'Administracja', 'st', '2017-10-01'),
105(14, 'Zarzadzanie', 'st', '2018-10-01'),
106(15, 'Informatyka', 'nst', '2018-10-01'),
107(16, 'Administracja', 'st', '2018-10-01'),
108(17, 'Transport', 'nst', '2018-10-01'),
109(18, 'Informatyka', 'st', '2018-10-01'),
110(19, 'Zarzadzanie', 'nst', '2018-10-01'),
111(20, 'Informatyka', 'st', '2018-10-01');
112
113
114create table note (
115note_id int not null primary key,
116note float not null
117);
118
119insert into note
120values
121(1, 0),
122(2, 2),
123(3, 3),
124(4, 3.5),
125(5, 4),
126(6, 4.5),
127(7, 5);
128
129
130create database bartlomiej_izko;
131use bartlomiej_izko;
132create table Lectures (
133Lectures_ID INT PRIMARY KEY,
134	Imie VARCHAR(45),
135	Nazwisko VARCHAR(45),
136	Miasto VARCHAR(45),
137	Pensja INT );
138insert into Lectures (Lectures_ID, Imie, Nazwisko, Miasto, Pensja)
139	values
140	(1,'ABC','CBA','Lublin','3');
141	(2,'Adam','Kowalski','Krasnik','2870'),
142	(3,'Norbert','Kaczynski','Sosnowiec','1550'),
143	(4,'Tomasz','Dragan','Radom','1950'),
144	(5,'Konrad','Polub','Bialystok','2120');
145
146
147
148
149create table Country
150(
151country_id varchar(5) not null primary key,
152Country varchar(50) null,
153Telephone varchar(5) null,
154Capital varchar(50) null,
155Language varchar(50) null,
156Area varchar(50) null,
157Currency varchar(50) null
158);
159
160 insert into dane 
161 values
162('PL','Poland','+48','Warsaw','Polish','312,696 km2','Polish złoty (PLN)'),
163('ES','Spain','+34','Madrid','Spanish','505,990 km2','Euro (EUR)'),
164('HR','Croatia','+385','Zagreb','Croatian','56,594 km2','Kuna (HRK)'),
165('DE','Germany','+49','Berlin','German','357,386 km2','Euro (EUR)'),
166('JP','Japan','+81','Tokyo','Japanese','377,973 km2','Yen(JPY)');
167
168create table Salary(salary_id int not null primary key auto_increment, pensja decimal(65,2));
169
170insert into salary (pensja) values (3000.22),(1000.21),(1500.01),(2321.32);
171
172create table Car (
173id int not null primary key,
174mark varchar(50),
175model varchar(50),
176year_of_production varchar(5),
177capacity varchar(10)
178);
179
180insert into car (id, mark, model, year_of_production, capacity) 
181values 
182(1, 'Audi', '80', '1993', '1998');
183(2, 'Doodge', 'Ramvan', '2000', '2499');