alter session set nls_date_format='DD.MM.YYYY';

INSERT INTO ALBUM ( NAZEV_A, ROK, CENA ) 
 VALUES ('Album1', 2003, 200.0);
INSERT INTO ALBUM ( NAZEV_A, ROK, CENA ) 
 VALUES ('Album2', 2000, 200.0);
INSERT INTO ALBUM ( NAZEV_A, ROK, CENA ) 
 VALUES ('Album3', 2001, 200.0);
INSERT INTO ALBUM ( NAZEV_A, ROK, CENA ) 
 VALUES ('Album4', 2001, 200.0);
INSERT INTO ALBUM ( NAZEV_A, ROK, CENA ) 
 VALUES ('Album5', 1998, 200.0);
INSERT INTO ALBUM ( NAZEV_A, ROK, CENA ) 
 VALUES ('Album6', 1999, 200.0);
INSERT INTO ALBUM ( NAZEV_A, ROK, CENA ) 
 VALUES ('Album7', 2000, 200.0);
INSERT INTO ALBUM ( NAZEV_A, ROK, CENA ) 
 VALUES ('Album8', 1990, 200.0);
INSERT INTO ALBUM ( NAZEV_A, ROK, CENA ) 
 VALUES ('Album9', 1995, 200.0);
INSERT INTO ALBUM ( NAZEV_A, ROK, CENA ) 
 VALUES ('Album10', 2003, 200.0);

INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 1,'Album1' );
INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 2,'Album1' );
INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 3,'Album2' );
INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 4,'Album3' );
INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 5,'Album1' );
INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 6,'Album4' );
INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 7,'Album1' );
INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 8,'Album6' );
INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 9,'Album1' );
INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 10,'Album8' );
INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 11,'Album9' );
INSERT INTO CD ( ID_CD, NAZEV_A ) 
 VALUES ( 12,'Album10' );


INSERT INTO ZAMESTNANEC (ID_ZAM, JMENO_ZAM ) 
 VALUES ( 1, 'Novak' );
INSERT INTO ZAMESTNANEC (ID_ZAM, JMENO_ZAM ) 
 VALUES ( 2, 'Hruska' );
INSERT INTO ZAMESTNANEC (ID_ZAM, JMENO_ZAM ) 
 VALUES ( 3, 'Novotny' );
INSERT INTO ZAMESTNANEC (ID_ZAM, JMENO_ZAM ) 
 VALUES ( 4, 'Svoboda' );
INSERT INTO ZAMESTNANEC (ID_ZAM, JMENO_ZAM ) 
 VALUES ( 5, 'Bartos' );
INSERT INTO ZAMESTNANEC (ID_ZAM, JMENO_ZAM ) 
 VALUES ( 6, 'Bohac' );
INSERT INTO ZAMESTNANEC (ID_ZAM, JMENO_ZAM ) 
 VALUES ( 7, 'Brychta' );
INSERT INTO ZAMESTNANEC (ID_ZAM, JMENO_ZAM ) 
 VALUES ( 8, 'Heger' );
INSERT INTO ZAMESTNANEC (ID_ZAM, JMENO_ZAM ) 
 VALUES ( 9, 'Merta' );
INSERT INTO ZAMESTNANEC (ID_ZAM, JMENO_ZAM ) 
 VALUES ( 10, 'Vapenik' );


INSERT INTO ZAKAZNIK (JMENO_ZAK, RC_ZAK, ADRESA,TELEFON ) 
 VALUES ( 'Novotny',0, 'Adresa1',5234254);
INSERT INTO ZAKAZNIK (JMENO_ZAK, RC_ZAK, ADRESA,TELEFON ) 
 VALUES ( 'Zakaznik1',1, 'Adresa1',5234254);
INSERT INTO ZAKAZNIK (JMENO_ZAK, RC_ZAK, ADRESA,TELEFON ) 
 VALUES ( 'Zakaznik2',2, 'Adresa1',5234254);
INSERT INTO ZAKAZNIK (JMENO_ZAK, RC_ZAK, ADRESA,TELEFON ) 
 VALUES ( 'Zakaznik3',3, 'Adresa1',5234254);
INSERT INTO ZAKAZNIK (JMENO_ZAK, RC_ZAK, ADRESA,TELEFON ) 
 VALUES ( 'Zakaznik4',4, 'Adresa1',5234254);
INSERT INTO ZAKAZNIK (JMENO_ZAK, RC_ZAK, ADRESA,TELEFON ) 
 VALUES ( 'Zakaznik5',5, 'Adresa1',5234254);
INSERT INTO ZAKAZNIK (JMENO_ZAK, RC_ZAK, ADRESA,TELEFON ) 
 VALUES ( 'Zakaznik6',6, 'Adresa1',5234254);
INSERT INTO ZAKAZNIK (JMENO_ZAK, RC_ZAK, ADRESA,TELEFON ) 
 VALUES ( 'Zakaznik7',7, 'Adresa1',5234254);
INSERT INTO ZAKAZNIK (JMENO_ZAK, RC_ZAK, ADRESA,TELEFON ) 
 VALUES ( 'Zakaznik8',8, 'Adresa1',5234254);
INSERT INTO ZAKAZNIK (JMENO_ZAK, RC_ZAK, ADRESA,TELEFON ) 
 VALUES ( 'Zakaznik9',9, 'Adresa1',5234254);

INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 1, 'Interpret1','Pozn1' );
INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 2, 'Interpret2', 'Pozn2' );
INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 3, 'Interpret3', 'Pozn3'  );
INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 4, 'Interpret4', 'Pozn4'  );
INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 5, 'Interpret5', 'Pozn5'  );
INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 6, 'Interpret6', 'Pozn6'  );
INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 7, 'Interpret7', 'Pozn7'  );
INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 8, 'Interpret8', 'Pozn8'  );
INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 9, 'Interpret9', 'Pozn9'  );
INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 10, 'Interpret10', 'Pozn10'  );
INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 11, 'Interpret11', 'Pozn11'  );
INSERT INTO INTERPRET ( ID_I, JMENO_I, Pozn ) 
 VALUES ( 12, 'Interpret12', 'Pozn12'  );


INSERT INTO PISEN ( NAZEV_P, ID_I, POZN, ROK ) 
 VALUES ( 'Pisen1', 1, 'Text', 2000 );
INSERT INTO PISEN ( NAZEV_P, ID_I, POZN, ROK ) 
 VALUES ( 'Pisen2', 1, 'Text', 2003 );
INSERT INTO PISEN ( NAZEV_P, ID_I, POZN, ROK ) 
 VALUES ( 'Pisen3', 2, 'Text', 2001 );
INSERT INTO PISEN ( NAZEV_P, ID_I, POZN, ROK ) 
 VALUES ( 'Pisen4', 2, 'Text', 2002 );
INSERT INTO PISEN ( NAZEV_P, ID_I, POZN, ROK ) 
 VALUES ( 'Pisen5', 3, 'Text', 2000 );
INSERT INTO PISEN ( NAZEV_P, ID_I, POZN, ROK ) 
 VALUES ( 'Pisen6', 6, 'Text', 2003 );
INSERT INTO PISEN ( NAZEV_P, ID_I, POZN, ROK ) 
 VALUES ( 'Pisen7', 5, 'Text', 1998 );
INSERT INTO PISEN ( NAZEV_P, ID_I, POZN, ROK ) 
 VALUES ( 'Pisen1', 7, 'Text', 1999 );
INSERT INTO PISEN ( NAZEV_P, ID_I, POZN, ROK ) 
 VALUES ( 'Pisen9', 6, 'Text', 1995 );



INSERT INTO OBJEDNAVKA (ID_OBJ, VYRIZENA, POCET,RC_ZAK, NAZEV_A ) 
 VALUES ( 1, 'A', 1, 1, 'Album1' );
INSERT INTO OBJEDNAVKA (ID_OBJ, VYRIZENA, POCET,RC_ZAK, NAZEV_A ) 
 VALUES ( 2, 'N', 5, 2, 'Album1' );
INSERT INTO OBJEDNAVKA (ID_OBJ, VYRIZENA, POCET,RC_ZAK, NAZEV_A ) 
 VALUES ( 3, 'N', 3, 1, 'Album3' );
INSERT INTO OBJEDNAVKA (ID_OBJ, VYRIZENA, POCET,RC_ZAK, NAZEV_A ) 
 VALUES ( 4, 'A', 2, 2, 'Album5' );
INSERT INTO OBJEDNAVKA (ID_OBJ, VYRIZENA, POCET,RC_ZAK, NAZEV_A ) 
 VALUES ( 5, 'A', 5, 3, 'Album2' );
INSERT INTO OBJEDNAVKA (ID_OBJ, VYRIZENA, POCET,RC_ZAK, NAZEV_A ) 
 VALUES ( 6, 'N', 8, 2, 'Album4' );
INSERT INTO OBJEDNAVKA (ID_OBJ, VYRIZENA, POCET,RC_ZAK, NAZEV_A ) 
 VALUES ( 7, 'A', 1, 5, 'Album10' );
INSERT INTO OBJEDNAVKA (ID_OBJ, VYRIZENA, POCET,RC_ZAK, NAZEV_A ) 
 VALUES ( 8, 'N', 5, 5, 'Album9' );
INSERT INTO OBJEDNAVKA (ID_OBJ, VYRIZENA, POCET,RC_ZAK, NAZEV_A ) 
 VALUES ( 9, 'A', 1, 6, 'Album8' );
INSERT INTO OBJEDNAVKA (ID_OBJ, VYRIZENA, POCET,RC_ZAK, NAZEV_A ) 
 VALUES ( 10, 'N', 1, 7, 'Album7' );

INSERT INTO FAKTURA ( CIS_F, ID_ZAM, DAT_VYSTAV, ZAPLACENO, DAT_SPLATNOSTI ) 
 VALUES ( 1, 1, '01.01.2003','A','15.01.2003' );
INSERT INTO FAKTURA ( CIS_F, ID_ZAM, DAT_VYSTAV, ZAPLACENO, DAT_SPLATNOSTI ) 
 VALUES ( 2, 2, '01.02.2003','N','15.02.2003' );
INSERT INTO FAKTURA ( CIS_F, ID_ZAM, DAT_VYSTAV, ZAPLACENO, DAT_SPLATNOSTI ) 
 VALUES ( 3, 1, '01.03.2003','A','15.03.2003' );
INSERT INTO FAKTURA ( CIS_F, ID_ZAM, DAT_VYSTAV, ZAPLACENO, DAT_SPLATNOSTI ) 
 VALUES ( 4, 5, '01.04.2003','A','15.04.2003' );
INSERT INTO FAKTURA ( CIS_F, ID_ZAM, DAT_VYSTAV, ZAPLACENO, DAT_SPLATNOSTI ) 
 VALUES ( 5, 2, '01.05.2003','N','15.05.2003' );
INSERT INTO FAKTURA ( CIS_F, ID_ZAM, DAT_VYSTAV, ZAPLACENO, DAT_SPLATNOSTI ) 
 VALUES ( 6, 7, '01.06.2003','A','15.06.2003' );
INSERT INTO FAKTURA ( CIS_F, ID_ZAM, DAT_VYSTAV, ZAPLACENO, DAT_SPLATNOSTI ) 
 VALUES ( 7, 3, '01.07.2003','N','15.07.2003' );
INSERT INTO FAKTURA ( CIS_F, ID_ZAM, DAT_VYSTAV, ZAPLACENO, DAT_SPLATNOSTI ) 
 VALUES ( 8, 2, '01.08.2003','A','15.08.2003' );
INSERT INTO FAKTURA ( CIS_F, ID_ZAM, DAT_VYSTAV, ZAPLACENO, DAT_SPLATNOSTI ) 
 VALUES ( 9, 1, '01.09.2003','N','15.09.2003' );
INSERT INTO FAKTURA ( CIS_F, ID_ZAM, DAT_VYSTAV, ZAPLACENO, DAT_SPLATNOSTI ) 
 VALUES ( 10, 1, '01.10.2003','N','15.10.2003' );
  

INSERT INTO NA (CIS_F, ID_CD ) 
 VALUES ( 1, 1 );
INSERT INTO NA (CIS_F, ID_CD ) 
 VALUES ( 1, 2 );
INSERT INTO NA (CIS_F, ID_CD ) 
 VALUES ( 2, 3 );
INSERT INTO NA (CIS_F, ID_CD ) 
 VALUES ( 3, 4 );
INSERT INTO NA (CIS_F, ID_CD ) 
 VALUES ( 4, 5 );
INSERT INTO NA (CIS_F, ID_CD ) 
 VALUES ( 5, 6 );
INSERT INTO NA (CIS_F, ID_CD ) 
 VALUES ( 6, 7 );
INSERT INTO NA (CIS_F, ID_CD ) 
 VALUES ( 7, 8 );
INSERT INTO NA (CIS_F, ID_CD ) 
 VALUES ( 8, 9 );
INSERT INTO NA (CIS_F, ID_CD ) 
 VALUES ( 9, 10 );
INSERT INTO NA (CIS_F, ID_CD ) 
 VALUES ( 10, 11 );
 
INSERT INTO OBSAZENA ( NAZEV_P, ID_I, NAZEV_A ) 
 VALUES ( 'Pisen1', 1, 'Album1' );
INSERT INTO OBSAZENA ( NAZEV_P, ID_I, NAZEV_A ) 
 VALUES ( 'Pisen2', 1, 'Album1' );
INSERT INTO OBSAZENA ( NAZEV_P, ID_I, NAZEV_A ) 
 VALUES ( 'Pisen3', 2, 'Album1' );
INSERT INTO OBSAZENA ( NAZEV_P, ID_I, NAZEV_A ) 
 VALUES ( 'Pisen4', 2, 'Album2' );
INSERT INTO OBSAZENA ( NAZEV_P, ID_I, NAZEV_A ) 
 VALUES ( 'Pisen5', 3, 'Album2' );
INSERT INTO OBSAZENA ( NAZEV_P, ID_I, NAZEV_A ) 
 VALUES ( 'Pisen6', 6, 'Album3' );
INSERT INTO OBSAZENA ( NAZEV_P, ID_I, NAZEV_A ) 
 VALUES ( 'Pisen7', 5, 'Album3' );
INSERT INTO OBSAZENA ( NAZEV_P, ID_I, NAZEV_A ) 
 VALUES ( 'Pisen1', 7, 'Album4' );
INSERT INTO OBSAZENA ( NAZEV_P, ID_I, NAZEV_A ) 
 VALUES ( 'Pisen9', 6, 'Album5' );


 
INSERT INTO ZA ( ID_OBJ, CIS_F ) 
 VALUES ( 1, 1 );
INSERT INTO ZA ( ID_OBJ, CIS_F ) 
 VALUES ( 2, 2 );
INSERT INTO ZA ( ID_OBJ, CIS_F ) 
 VALUES ( 3, 3 );
INSERT INTO ZA ( ID_OBJ, CIS_F ) 
 VALUES ( 4, 4 );
INSERT INTO ZA ( ID_OBJ, CIS_F ) 
 VALUES ( 5, 5 );
INSERT INTO ZA ( ID_OBJ, CIS_F ) 
 VALUES ( 6, 6 );
INSERT INTO ZA ( ID_OBJ, CIS_F ) 
 VALUES ( 7, 7 );
INSERT INTO ZA ( ID_OBJ, CIS_F ) 
 VALUES ( 8, 8 );
INSERT INTO ZA ( ID_OBJ, CIS_F ) 
 VALUES ( 9, 9 );
INSERT INTO ZA ( ID_OBJ, CIS_F ) 
 VALUES ( 10, 10 );