Part I

1) Create the following tables and insert the information in SQL.

2) Explain if the mentioned record can be added to the table S_Order. Why?

3) Explain if the mentioned record can be removed from the table Customer. Why?

4) Explain if the mentioned record can be removed from the table Product.

Part II (Question is in english)

1) Redesign tables to third normal form.

2) Redesign tables to third normal form.

(state clearty your s PARTE I: INTREGIDAD REFERENCIAL (S0 Pts.). tablas: 1. Conteste todas las preguntas haciendo referencia a las siguientes CUSTOMER Primary Key: C NO C NO C NAME CITY CI | NEW YORK C2 NEW YORK 3 C3 MIAMI 4 C4 MIAMI C5 SBOSTON C6 CHICAGO 7C7 HOUSTON 8 C8 PITTBURGH PRODUCT Primary Key: P NO P NO P NAME PRICI STOCK P1 P2 P3 P4 P5 P6 $1.00 $2.00 $4.00 $8.00 $3.00 $5.00 1000 4000 2000 500 200 1500 4