Create and use XML tags to represent the following data: PhotographyShowing Inventory by photographer

Burt Simpson burtSim@gmelt.com

Photograph 12301 Rocks on a beach Photograph 12302 T urtles on a beach 2019 Photograp12305 Turtle leaving a beach 2019

Billy Lawson blawsn@aono.com

2019

Photograph Photograph Photograph

13000 Boats on a lake 2020 13004 People on a boat 2019 13009 People on a boat on a lake

2018

Sally Forest sallyf@ms.com

Photograph 14099 Train leaving the station Photograph 15001 Train entering the station 2019

3. Consider a scenario where a university wants to track student membership in school clubs.

contain information on the students: student id, student name, major, phone number. It also needs to contain information about the clubs: club number, club name, web site, contact phone number. Also, for students, the university wants to maintain a list of that student's club memberships, and for the clubs, a list of the club members. The university also want to know the president of each club. The ER diagram below describes the scenario. Create the user defined types for the student and club entity types. User object references as appropriate. Create tables from the user define types as typed tables.

4. If the following transaction serializable? Explain why or why not.

read(T1, X), read(T2,, Y), write(T1, X), write(T2,Y), read(T3,X), read(T3,Y), write(T3,X), write(T3,Y), commit(T1), commit(T2), commit(T3)

2018