中山大学-11级-数据库期中试题与答案.pdfVIP

Principles Of Database Systems - Midterm Exam 中山大学软件学院2011 级软件工程专业（2012 学年春季学期） 《SE-304 数据库系统原理》期中试题答案 （考试形式：闭 卷 考试时间：2 小时） Problem 1 ER Diagram (20 points) Suppose that you have set up a database company called “ArtBase” in order to build a product for art galleries. The core of this product is a database with a schema that captures all the information that galleries need to maintain.  Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art.  For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price must be stored. Note that each piece of artwork is painted by only one artist.  Pieces of artwork are also classified into groups of various kinds (e.g., portraits, still lifes, works by Picasso, or works of the 19th century); a given piece of artwork may belong to more than one group. Each group is identified by a name (like those just given) that describes the group.  Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique id, name, address, total amount of dollars spent in the gallery (very important!), and the artists and groups of art that the customer tends to like. Note that each customer come to the galler ies for the reason that they like at least one group of artworks. (1) Draw the ER diagram for the database. (10 points) (2) Translate the ER diagram into a relational schema. (10 points) Artist (name:string, birthplace:string, age:integer, style:string) Artwork (title:string, year:string, typ