DATABASE SYSTEM

PART I: REFERENTIAL INTREGITY (30 Pts.). Answer all questions by referring to the following tables: CUSTOMER Primary Key: C NO C NO C_NAME CITY 1 ci NEW YORK C2 NEW YORK C3 C4 MIAMI C5 BOSTON CHICAGO C7 HOUSTON 8 C8 PITTBURGH PRODUCT Primary Key:P NO P NOP NAME 1 P1 STOCK 2 P2 PRICE $1.00 $2.00 $4.00 $8.00 $3.00 $5.00 $2.00 P3 P4 P5 P6 P7 4 1000 4000 2000 500 200 1500 3000 S_ORDER Primary Key: C_NO+P_NO Foreing Key: C_NO References CUSTUMER table. RESTRICT on DELETE. Foreing Key: P_NO References PRODUCT table. RESTRICT on DELETE. C NO P NO QUANTITY 10 2 1 1 2 1 20 10 20 6 7 8 1 1 1 30 30 40 50 1. Can the following record be added to the S_ORDER table? Explain C NO P NO QUANTITY 26 20 2. Can the following record be removed from the CUSTOMER table? Explain C NOC NAME C8 CITY PITTSBURG 3. Can the following record be removed from the PRODUCT table? Explain P NO P NAME PRICE STOCK P5 $3.00 200