8/17/2019 Θέατρο.docx_0

1/2

CREATE TABLE POLH (ID INTEGER IDENTITY,Onoma nvarchar(20),Xwra nvarchar(0)CON!TRAINT "#$Po%h PRI&ARY 'EY (ID))

THEATR* ('w+#o-, Onoma, Po%h$ID, &a.Th/a/-)CREATE TABLE THEATRO (ID INTEGER IDENTITY,Onoma nvarchar(20),Po%h$ID n/1/r,&a.Th/a/- n/1/rCON!TRAINT "#$Th/aro PRI&ARY 'EY (ID),CON!TRAINT #$Po%hID 3OREIGN 'EY (Po%h$ID) RE3ERENCE! 4POLH4(ID))

PARA!TA!H ('w+#o-, T%o-, Th/aro$ID, Th/a/-, E-ro)CREATE TABLE PARA!TA!H (ID INTEGER IDENTITY, T%o- nvarchar(50), Th/aro$ID n/1/r, Th/a/- n/1/r,

E-ro mon/6CON!TRAINT "#$Para-a-h PRI&ARY 'EY (ID),CON!TRAINT #$Th/aroID 3OREIGN 'EY (Th/aro$ID) RE3ERENCE! 4THEATRO4(ID))

E-a1w1h /11rawn -on "na#a 4POLH47 Onoma Xwra L6on 3ranc/ G/n/va !w8/r%an+ &onmarr/ 3ranc/ Ah/n- Gr//c/IN!ERT INTO POLH 9AL:E! (;L6on;,;3ranc/;)IN!ERT INTO POLH 9AL:E! (;G/n/va;,;!w8/r%an+;)IN!ERT INTO POLH 9AL:E! (;&onmarr/;,;3ranc/;)IN!ERT INTO POLH 9AL:E! (;Ah/n-;,;Gr//c/;)

E-a1w1h /11rawn -on "na#a 4THEATRO47 Onoma Po%h$ID &a.$Th/a/- T/.nh 2000 A%-o- 5

8/17/2019 Θέατρο.docx_0

2/2

) O F (FJFK) M FQS F FMKUF ?00 QFV S FJFK FM JU F KVW V (m/ra)Z!ELECT T%o-3RO& PARA!TA!H[HERE T%o- LI'E ;\m/ra\;AND Th/a/- ]^ ?00

5) _ `Q Ub M FQS F QVF UdFSFF

r/, peF F KF F M JU SFUdQJ F JS PARA!TA!H S ``bF F KFMJ dF SF -/%/cZ

Cr/a/ Proc/+>r/ Da1ahPara-a-h-(Para-a-h$ID INTEGER)A!D/%// 3RO& PARA!TA!H[h/r/ ID ^ Para-a-h$IDGO

EXEC Da1ahPara-a-h- ;