You may discuss problems with other students in the class. However, each student must write up his or her own solution to each problem independently. That is, while you may formulate the solutions to problems in collaboration with classmates, you must be able to articulate the solutions on your own.
1.In Database Management Systems by Ramakrishnan and Gehrke, Chapter 9, exercise 9.2, pgs. 273-274, Parts 1 through 4.
2.In Database Management Systems by Ramakrishnan and Gehrke,
Chapter 9, pg. 276:
Part a Exercise 9.10, part 1.
Part b Exercise 9.10, part 3.
Part c Exercise 9.12, part 1.
Part d Exercise 9.12, part 3.
3.In Database Management Systems by Ramakrishnan and Gehrke, Chapter 10, Exercise 10.2, pgs. 294-295, Parts 4 through 7.
4.In Database Management Systems by Ramakrishnan and Gehrke, Chapter 14, Exercise 14.2, pgs. 404-405, Part 5.