CREATE TABLE tatli
(
    tatli_id INT,
    tatli_adi VARCHAR2(50 CHAR) NOT NULL,
    adet_fiyat NUMBER(8,2) NOT NULL,
    kilo_fiyat NUMBER(8,2) NOT NULL,
    CONSTRAINT pk_tatli_id PRIMARY KEY (tatli_id)
);

CREATE TABLE FIS
(
   fis_no INT,
   tatli_id INT,
   adet INT,
   CONSTRAINT fk_tatli_id FOREIGN KEY (tatli_id) REFERENCES tatli(tatli_id)
);


INSERT INTO tatli VALUES (1,  'Özel Kare Baklava', 10, 150);
INSERT INTO tatli VALUES (2,  'Baklava', 6, 125);
INSERT INTO tatli VALUES (3,  'Kuru Baklava', 6, 125);
INSERT INTO tatli VALUES (4,  'Özel Söbiyet', 12, 170);
INSERT INTO tatli VALUES (5,  'Havuç Dilimi', 18, 140);
INSERT INTO tatli VALUES (6,  'Midye Baklava', 9, 180);
INSERT INTO tatli VALUES (7,  'Cevizli Baklava', 4, 100);
INSERT INTO tatli VALUES (8,  'Dolama', 8, 190);
INSERT INTO tatli VALUES (9,  'Yaprak Söbyet', 14, 190);
INSERT INTO tatli VALUES (10, 'Söbiyet', 10, 150);
COMMIT;



INSERT INTO fis VALUES (1,  1,  2);
INSERT INTO fis VALUES (1,  9,  1);
INSERT INTO fis VALUES (2,  4,  3);
INSERT INTO fis VALUES (2,  1,  1);
INSERT INTO fis VALUES (3,  8,  1);
INSERT INTO fis VALUES (3,  9,  2);
INSERT INTO fis VALUES (3,  3,  1);
INSERT INTO fis VALUES (4,  2,  2);
INSERT INTO fis VALUES (4,  1,  1);
INSERT INTO fis VALUES (4,  4,  2);
INSERT INTO fis VALUES (5,  6,  1);
INSERT INTO fis VALUES (5,  1,  1);
INSERT INTO fis VALUES (5,  4,  2);
INSERT INTO fis VALUES (6,  4,  2);
INSERT INTO fis VALUES (7,  9,  3);
INSERT INTO fis VALUES (7,  1,  1);
INSERT INTO fis VALUES (8,  8,  1);
INSERT INTO fis VALUES (8,  6,  3);
INSERT INTO fis VALUES (8,  5,  1);
INSERT INTO fis VALUES (9,  4,  2);
INSERT INTO fis VALUES (9,  1,  2);
INSERT INTO fis VALUES (9,  8,  1);
INSERT INTO fis VALUES (10, 9,  1);
INSERT INTO fis VALUES (10, 1,  1);
INSERT INTO fis VALUES (11, 9,  1);
INSERT INTO fis VALUES (11, 4,  2);
INSERT INTO fis VALUES (11, 6,  2);
INSERT INTO fis VALUES (12, 8,  3);
INSERT INTO fis VALUES (12, 1,  1);
INSERT INTO fis VALUES (13, 4,  1);
INSERT INTO fis VALUES (13, 9,  1);
INSERT INTO fis VALUES (13, 1,  2);
INSERT INTO fis VALUES (13, 7,  1);
INSERT INTO fis VALUES (14, 4,  2);
INSERT INTO fis VALUES (14, 1,  2);
INSERT INTO fis VALUES (14, 8,  1);
INSERT INTO fis VALUES (15, 4,  3);
INSERT INTO fis VALUES (15, 10, 1);
INSERT INTO fis VALUES (16, 2,  1);
INSERT INTO fis VALUES (16, 8,  2);
INSERT INTO fis VALUES (17, 3,  1);
INSERT INTO fis VALUES (17, 1,  2);
INSERT INTO fis VALUES (17, 5,  1);
INSERT INTO fis VALUES (17, 8,  1);
INSERT INTO fis VALUES (18, 4,  2);
INSERT INTO fis VALUES (18, 9,  2);
INSERT INTO fis VALUES (19, 7,  3);
INSERT INTO fis VALUES (20, 1,  1);
INSERT INTO fis VALUES (20, 4,  1);
INSERT INTO fis VALUES (20, 8,  3);
INSERT INTO fis VALUES (21, 8,  1);
INSERT INTO fis VALUES (21, 9,  2);
INSERT INTO fis VALUES (21, 6,  2);
INSERT INTO fis VALUES (22, 10, 1);
INSERT INTO fis VALUES (22, 1,  1);
INSERT INTO fis VALUES (22, 4,  1);
INSERT INTO fis VALUES (22, 7,  1);
INSERT INTO fis VALUES (23, 8,  2);
INSERT INTO fis VALUES (23, 6,  2);
INSERT INTO fis VALUES (24, 5,  3);
INSERT INTO fis VALUES (24, 1,  1);
INSERT INTO fis VALUES (24, 4,  1);
INSERT INTO fis VALUES (24, 3,  1);
INSERT INTO fis VALUES (25, 8,  2);
INSERT INTO fis VALUES (25, 2,  1);
INSERT INTO fis VALUES (25, 4,  2);
COMMIT;