CREATE TABLE Pasmo( nazwa NVARCHAR2 (5) NOT NULL, id_pasmo NUMBER (5) CONSTRAINT pk_pasmo PRIMARY KEY ); CREATE TABLE Gory( id_gory NUMBER (2) CONSTRAINT pk_id_gory PRIMARY KEY, nazwA NVARCHAR2 (25) NOT NULL, id_pasmo NUMBER (2) CONSTRAINT fk_pasmo REFERENCES Pasmo(id_pasmo), wysokosc INT ) CREATE TABLE Szlaki_Gorskie( id_szlaku NUMBER (2) CONSTRAINT pk_id_szlaku PRIMARY KEY, przebieg_szlaku NVARCHAR2 (40) NOT NULL, ktora_gora NUMBER (2) CONSTRAINT fk_id_pasma REFERENCES Gory(id_gory) ); CREATE TABLE Panstwa( id_panstwa NUMBER (2), nazwapanstwa NVARCHAR2 (25) NOT NULL, zawiera_gora NUMBER (2) CONSTRAINT fk_id_gora REFERENCES Gory(id_gora) ); CREATE TABLE Schronisko( id_schroniska NUMBER (2), nazwa NVARCHAR2 (100) NOT NULL, wysokosc INT, schronisko_gory NUMBER (2) CONSTRAINT fk_id_gora REFERENCES Gory(id_gora) ); INSERT INTO Gory VALUES (1, 'Mount Everest', 1, '8848'); INSERT INTO Gory VALUES (2, 'Mont Blanc', 2, '4810'); INSERT INTO Gory VALUES (3, 'Gerlach', 3, '2655'); INSERT INTO Gory VALUES (4, 'Eiger', 4, '3970'); INSERT INTO Gory VALUES (5, 'Annapurna', 5, '8091'); SELECT * FROM dual; INSERT INTO Panstwa VALUES (1, 'Nepal'); INSERT INTO Panstwa VALUES (2, 'Chiny'); INSERT INTO Panstwa Values (3, 'Wlochy'); INSERT INTO Panstwa Values (4, 'Polska'); INSERT INTO Panstwa VALUES (5, 'Slowacja'); INSERT INTO Panstwa VALUES (6, 'Francja'); INSERT INTO Panstwa VALUES (7, 'Szwajcaria'); SELECT * FROM dual; INSERT INTO Pasmo VALUES ('Himalaje', 1); insert INTO Pasmo VALUES ('Masyw Mont Blanc', 2); INSERT INTO Pasmo VALUES ('Tatry', 3); INSERT INTO Pasmo VALUES ('Karpaty', 4); INSERT INTO Pasmo VALUES ('Alpy Bernenskie', 5); SELECT * FROM dual; INSERT INTO Schronisko VALUES (1, 'Base Camp Polnoc', '5150'); INSERT INTO Schronisko VALUES (2, 'Base Camp Poludnie', '5364'); INSERT INTO Schronisko VALUES (3, 'Kengo Kuma Associates', '2500'); INSERT INTO Schronisko VALUES (4, 'Slaski Dom', '1670'); INSERT INTO Schronisko VALUES (5, 'Wengernalp', '1874'); INSERT INTO Schronisko VALUES (6, 'Annapurna base camp', '4130'); SELECT * FROM dual; DROP TABLE Schroniska CASCADE CONSTRAINTS; DROP TABLE Powierzchnia_Panstwa CASCADE CONSTRAINTS;