PLEASE TYPE EACH ANSWER AS AN SQL answer. Thanks.

1. The Henry Books: Problem 1 (p. 88). When creating tables, include FKs.

2. The Henry Books: Problem 2 (p. 88). Add any two records to the BRANCH table. After inserting data, use the SELECT* command to show the content of the table.

3. The Henry Books: Problem 3 (p. 88). Add any two records to the PUBLISHER table. After inserting data, use the SELECT* command to show the content of the table.

4. The Henry Books: Problem 4 (p. 88). Add any two records to the AUTHOR table. After inserting data, use the SELECT* command to show the content of the table.

5. The Henry Books: Problem 5 (p. 88). Add any two records to the BOOK table. Make sure the records you chose do not violate referential integrity rules (in other words, foreign key values in the BOOK table are consistent with the primary key values in the PUBLISHER table). After inserting data, use the SELECT* command to show the content of the table.

6. The Henry Books: Problem 6 (p. 88). Add any two records to the WROTE table. Make sure records you chose do not violate referential integrity rules (in other words, foreign key values in the WROTE table are consistent with the primary key values in the BOOK table and the AUTHOR table). After inserting data, use the SELECT* command to show the content of the table.

7. The Henry Books: Problem 7 (p. 88). Add any two records to the INVENTORY table. Make sure records you chose do not violate referential integrity rules (in other words, foreign key values in the INVENTORY table are consistent with the primary key values in the BOOK table and the BRANCH table). After inserting data, use the SELECT* command to show the content of the table.

Using the tables below

BRANCH Description Nulls allowed? Length Decimal places Column Type Branch number (primary key) Branch name Branch location Number of employees BRANCIH NUM DECIMAL 2 No BRANCH NAME BRANCH-LOCATION | CHAR NUM EMPLOYEES DECIMAL2 PUBLISHER CHAR 50 50 Length Decimal places Column Type Nulls allowed? Description PUBLISHER CODE CHAR 3 No Publisher code (primary key) Publisher name Publisher eity PUBLISHER NAME CHAR 25 CITY CHAR 20 FIGURE 3-28 Table layouts for the Henry Books database hapter 3