· 6 years ago · Nov 18, 2019, 12:58 PM
1USE master;
2GO
3
4IF EXISTS (SELECT * FROM sysdatabases WHERE NAME = 'Poliklinika')
5 DROP DATABASE Poliklinika;
6GO
7
8CREATE DATABASE Poliklinika;
9GO
10
11USE Poliklinika;
12GO
13
14CREATE TABLE Pacienti
15(
16 idP INT NOT NULL PRIMARY KEY,
17 krstne VARCHAR(15),
18 mesPrijem INT
19);
20GO
21
22CREATE TABLE Lekari
23(
24 idL INT NOT NULL PRIMARY KEY,
25 krstne VARCHAR(15),
26 spec VARCHAR(20),
27 datNar DATETIME
28);
29GO
30
31CREATE TABLE Navstevy
32(
33 idN INT NOT NULL PRIMARY KEY,
34 idP INT NOT NULL FOREIGN KEY REFERENCES Pacienti(idP),
35 idL INT NOT NULL FOREIGN KEY REFERENCES Lekari(idL),
36 den DATETIME,
37 poplatok INT
38);
39GO
40
41INSERT Pacienti VALUES (1, 'Adam', 10000 );
42INSERT Pacienti VALUES (2, 'Stefan', 9500 );
43INSERT Pacienti VALUES (3, 'Slavo', 8500 );
44INSERT Pacienti VALUES (4, 'Klara', 9000 );
45INSERT Pacienti VALUES (5, 'Zuzana', 35000 );
46INSERT Pacienti VALUES (6, 'Tana', 20000 );
47INSERT Pacienti VALUES (7, 'Mato', 28000 );
48INSERT Pacienti VALUES (8, 'Zoli', 32000 );
49INSERT Pacienti VALUES (9, 'Misko', NULL );
50INSERT Pacienti VALUES (10,'Janka', NULL );
51
52INSERT Lekari VALUES (1, 'Oto', 'Ocny', '1960.5.5' );
53INSERT Lekari VALUES (2, 'Zoli', 'Zubny', '1961.11.14');
54INSERT Lekari VALUES (3, 'Klara','Kardiolog','1980.2.15' );
55INSERT Lekari VALUES (4, 'Zuzka','Zubny', '1970.4.2' );
56INSERT Lekari VALUES (5, 'Imro', 'Interny', '1956.11.9' );
57
58INSERT Navstevy VALUES (1, 1, 2, '2008.5.5', NULL );
59INSERT Navstevy VALUES (2, 2, 3, '2008.5.5', NULL );
60INSERT Navstevy VALUES (3, 6, 3, '2008.5.5', NULL);
61INSERT Navstevy VALUES (4, 4, 1, '2008.6.5', 200 );
62INSERT Navstevy VALUES (5, 5, 4, '2008.6.5', 500 );
63INSERT Navstevy VALUES (6, 7, 1, '2008.6.5', 200 );
64INSERT Navstevy VALUES (7, 6, 1, '2008.6.5', 500 );
65INSERT Navstevy VALUES (8, 8, 3, '2008.7.5', 900 );
66INSERT Navstevy VALUES (9, 2, 1, '2008.7.5', 200 );
67INSERT Navstevy VALUES (10,3, 3, '2008.7.5', 100 );
68INSERT Navstevy VALUES (11,6, 2, '2008.8.5', 700 );
69INSERT Navstevy VALUES (12,7, 2, '2008.8.5', 500 );
70INSERT Navstevy VALUES (13,6, 4, '2008.8.5', 800 );
71INSERT Navstevy VALUES (14,2, 1, '2008.9.5', NULL);
72INSERT Navstevy VALUES (15,3, 1, '2008.9.5', 200 );
73INSERT Navstevy VALUES (16,8, 1, '2008.9.5', 200 );
74INSERT Navstevy VALUES (17,9, 5, '2008.9.5', NULL);
75INSERT Navstevy VALUES (18,7, 1, '2008.10.5',300 );
76INSERT Navstevy VALUES (19,8, 4, '2008.10.5',800 );
77INSERT Navstevy VALUES (20,10,5, '2008.10.5',300 );
78INSERT Navstevy VALUES (21,1, 1, '2008.11.5',350 );
79INSERT Navstevy VALUES (22,6, 5, '2008.11.5',400 );