Sw6cT0zE

1DROP TABLE IF EXISTS telefonok;
2DROP TABLE IF EXISTS diakok;
3CREATE TABLE telefonok
4(
5	id INTEGER PRIMARY KEY,
6	gyarto VARCHAR(30) NOT NULL,
7	tipus VARCHAR(30) NOT NULL,
8	oprendszer VARCHAR(30) NOT NULL,
9	ar INTEGER NOT NULL
10);
11INSERT INTO telefonok VALUES('1000','SAMSUNG','GALAXY S9','ANDROID',190000);
12INSERT INTO telefonok VALUES('1001','SAMSUNG','GALAXY S8','ANDROID',120000);
13INSERT INTO telefonok VALUES('1002','SAMSUNG','GALAXY S7','ANDROID',90000);
14INSERT INTO telefonok VALUES('1003','SAMSUNG','GALAXY S6','ANDROID',50000);
15INSERT INTO telefonok VALUES('1004','SAMSUNG','GALAXY S3','ANDROID',20000);
16INSERT INTO telefonok VALUES('1005','APPLE','5','IOS',40000);
17INSERT INTO telefonok VALUES('1006','APPLE','7','IOS',120000);
18INSERT INTO telefonok VALUES('1007','APPLE','X','IOS',210000);
19INSERT INTO telefonok VALUES('1008','APPLE','5S','IOS',50000);
20INSERT INTO telefonok VALUES('1009','APPLE','6','IOS',90000);
21CREATE TABLE diakok
22(
23	id INTEGER PRIMARY KEY,
24	nev VARCHAR(30) NOT NULL,
25	szuletesi_hely VARCHAR(30) NOT NULL,
26	szuletesi_datum DATE NOT NULL,
27	osztaly CHAR(3) NOT NULL,
28	atlag FLOAT NOT NULL,
29	telefon INTEGER,
30	FOREIGN KEY(telefonok) REFERENCES telefonok(id)
31);
32INSERT INTO diakok VALUES(1,'NAGY CSILLA','NAGYKANIZSA','2001.10.15','9A',4.2,1000);
33INSERT INTO diakok VALUES(2,'JÁRNOKI FERENC','PÉCS','2001.02.05','10A',3.5,1001);
34INSERT INTO diakok VALUES(3,'NAGY ZOLTÁN','BUDAPEST','2000.07.23','10A',2.8,1002);
35INSERT INTO diakok VALUES(4,'HORVÁTH GERGŐ','NAGYKANIZSA','2000.09.10','10B',3.6,1004);
36INSERT INTO diakok VALUES(5,'NÉMETH PATRIK','ZALAEGERSZEG','2001.05.17','9C',4.6,1005);
37INSERT INTO diakok VALUES(6,'TÓTH ZALÁN','PÉCS','2001.11.15','9B',2.3,1006);
38INSERT INTO diakok VALUES(7,'PINTÉR BÁLINT','ZALAEGERSZEG','2001.11.15','10B',3.7,1007);
39INSERT INTO diakok VALUES(8,'LAKATOS ALEX','BUDAPEST','2001.11.15','10A',4.3,1008);
40INSERT INTO diakok VALUES(9,'BOGDÁN JÁNOS','PÉCS','2001.11.15','9A',3.1,1009);