Crowdly

Add to Chrome

Adatbázis-kezelés (P-MB_B6)

Looking for Adatbázis-kezelés (P-MB_B6) test answers and solutions? Browse our comprehensive collection of verified answers for Adatbázis-kezelés (P-MB_B6) at moodle.ppke.hu.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

Jelölje be azokat a parancsokat, amelyek primary key constaint-et/elsődleges kulcs megszorítást sértenek! (A parancsokat külön tekintve, az eredeti adatbázison lefuttatva.)

INSERT INTO S1_GUEST (G_ID,NAME,SEX,AGE,RESERVATION_ID,APARTMENT_ID)

VALUES ('G07','Emma Smith','1','26','R01','WL1999');

INSERT INTO S1_GUEST (G_ID,NAME,SEX,AGE,RESERVATION_ID,APARTMENT_ID)

VALUES ('G01','John Mckenzie','0','31','R03','WL1997');

50%

INSERT INTO S1_APARTMENT (A_ID,CITY,RANKING,NUMBER_OF_ROOMS,HEATING,NUMBER_OF_PARKING_PLACE,PET_FRIENDLY,FAMILY_FRIENDLY,PRICE)

('WL1998','Paris','3','5','gas','3','1','0','150')

100%

INSERT INTO S1_GUEST (G_ID,NAME,SEX,AGE,RESERVATION_ID,APARTMENT_ID)

VALUES ('G05','Emma Smith','1','26','R01','WL1997');

50%

INSERT INTO S1_GUEST (G_ID,NAME,SEX,AGE,RESERVATION_ID,APARTMENT_ID)