whitepear
Starting Member
24 Posts |
Posted - 2014-04-13 : 11:40:07
|
Hello!Please, I am a very beginner and have to connect 6 entities.Please, does anyone see what is wrong in this code, cause I am getting NO RESULT (no output)!!!Many thanks!!!BEGIN TRANSACTION; DROP TABLE TOPIC;DROP TABLE LECTURE;DROP TABLE PRICE;DROP TABLE COURSE;DROP TABLE PUPIL;DROP TABLE LP;CREATE TABLE TOPIC(TNAME TEXT PRIMARY KEY,FK_CNAME);CREATE TABLE LECTURE(LNAME TEXT PRIMARY KEY,FK_TNAME TEXT,FK_PPRICE INTEGER);CREATE TABLE PRICE(PPRICE INTEGER PRIMARY KEY);CREATE TABLE COURSE(CNAME TEXT PRIMARY KEY);CREATE TABLE PUPIL(PNAME TEXT INTEGER PRIMARY KEY);CREATE TABLE LP(LPNAME TEXT PRIMARY KEY,FK_LNAME,FK_PNAME TEXT);INSERT INTO PUPIL VALUES('Ana');INSERT INTO PUPIL VALUES('Maja');COMMIT;INSERT INTO LP VALUES('LP1', 'L1', 'Ana');INSERT INTO LP VALUES('LP2', 'L2', 'Ana');INSERT INTO LP VALUES('LP3', 'L3', 'Ana');INSERT INTO LP VALUES('LP4', 'L4', 'Ana');INSERT INTO LP VALUES('LP5', 'L5', 'Ana');INSERT INTO LP VALUES('LP6', 'L6', 'Ana');INSERT INTO LP VALUES('LP7', 'L7', 'Ana');INSERT INTO LP VALUES('LP8', 'L8', 'Ana');INSERT INTO LP VALUES('LP9', 'L9', 'Ana');INSERT INTO LP VALUES('LP10','L10', 'Ana');INSERT INTO LP VALUES('LP11','L1', 'Maja');INSERT INTO LP VALUES('LP12','L2', 'Maja');COMMIT;INSERT INTO TOPIC VALUES('PIANNO','MUSIC');INSERT INTO TOPIC VALUES('VIOLA','MUSIC');INSERT INTO TOPIC VALUES('BMW','CARS');INSERT INTO TOPIC VALUES('AUDI','CARS');INSERT INTO TOPIC VALUES('DOGS','ANIMALS');INSERT INTO TOPIC VALUES('CATS','ANIMALS');COMMIT;INSERT INTO LECTURE VALUES('L1','PIANNO',10);INSERT INTO LECTURE VALUES('L2','VIOLA',20);INSERT INTO LECTURE VALUES('L3','BMW',30);INSERT INTO LECTURE VALUES('L4','AUDI',40);INSERT INTO LECTURE VALUES('L5','DOGS',10);INSERT INTO LECTURE VALUES('L6','CATS',20);INSERT INTO LECTURE VALUES('L7','PIANNO',30);INSERT INTO LECTURE VALUES('L8','VIOLA',40);INSERT INTO LECTURE VALUES('L9','BMW',10);INSERT INTO LECTURE VALUES('L10','AUDI',20);COMMIT;INSERT INTO PRICE VALUES(10);INSERT INTO PRICE VALUES(20);INSERT INTO PRICE VALUES(30);INSERT INTO PRICE VALUES(40);COMMIT;INSERT INTO COURSE VALUES('MUSIC');INSERT INTO COURSE VALUES('CARS');INSERT INTO COURSE VALUES('ANIMALS');COMMIT;SELECT * FROM COURSE,TOPIC,LECTURE,PRICE,LP,PUPIL WHERE COURSE.CNAME=TOPIC.FK_CNAME AND TOPIC.TNAME=LECTURE.FK_TNAME AND PRICE.PPRICE=LECTURE.FK_PPRICE AND PUPIL.PNAME=LP.FK_PNAME AND LP.FK_LNAME=LECTURE.LNAME; |
|