CONNECT /AS SYSDBA
ALTER USER SCOTT ACCOUNT UNLOCK; 
ALTER USER SCOTT IDENTIFIED BY TIGER; 
CONNECT SCOTT/TIGER;

CREATE TABLE clenove_rodiny
(
   kdo VARCHAR2(6) NOT NULL, PRIMARY KEY,
   jmeno VARCHAR2(30),
   vycerpal NUMBER(9,2)
);

CREATE TABLE rodinny_rozpocet
(
   datum  DATE,
   kdo VARCHAR2(6) NOT NULL,
   polozka VARCHAR2(20),
   prijem NUMBER(9,2),
   vydej NUMBER(9,2)
);

INSERT INTO clenove_rodiny VALUES ('otec', 'Jan Novak', 0 );
INSERT INTO clenove_rodiny VALUES ('mama', 'Marta Novakova', 0 );
INSERT INTO clenove_rodiny VALUES ('mirek', 'Mirko Novak', 0 );
INSERT INTO clenove_rodiny VALUES ('zuzina', 'Zuzka Novakova', 0 );

INSERT INTO rodinny_rozpocet VALUES (SYSDATE,'otec', 'Sako', 0, 5000);
INSERT INTO rodinny_rozpocet VALUES (SYSDATE,'mama', 'Kabelka', 0, 1700);
INSERT INTO rodinny_rozpocet VALUES (SYSDATE,'mirek', 'Auticko', 0, 320);
INSERT INTO rodinny_rozpocet VALUES (SYSDATE,'zuzina', 'Babika', 0, 550);


SELECT * FROM clenove_rodiny;
SELECT * FROM rodinny_rozpocet;

SELECT datum, jmeno, prijem, vydej FROM rodinny_rozpocet, clenove_rodiny
WHERE rodinny_rozpocet.kdo = clenove_rodiny.kdo;

COMMIT;

