Homework 3
CS3010301, Spring 2026

Due: Tuesday, May 26.

Please turn in an electronic copy of your solutions (in PDF, HTML, or MS DOC format) on Moodle. Everything has to be typed and submitted electronically.

---

0. Read Chapters 6 and 7 of the textbook.

1.(10pt) Consider the database shown in Figure 1.2, and write appropriate SQL DDL statements to create the database shown in Figure 1.2 in your DB account.

2.(15pt) Consider the database shown in Figure 5.6, whose schema is shown in Figure 5.7. Write appropriate SQL DDL statements to create the database shown in Figure 5.6 in your DB account.

3.(15pt) Exercise 6.10.

4.(15pt) Exercise 6.11 (specify the updates of Exercise 5.11 using the SQL update commands).

5.(15pt) Exercise 6.12.

6.(15pt) Exercise 6.13.

7.(15pt) Exercise 7.5.

For exercises 6.10, 6.12, and 7.5, put the SQL results into the corresponding tables in your DB account. For example, put the query result of exercise 6.12 (a) in a table named “6_12_a” in your DB account.