go to UC Berkeley home page go to SIMS home page

SIMS 202 Assignment 8 

Assigned 11/28. Optional: NOT GRADED.

Readings:   Teorey & McFadden, Handouts

The goal of this assignment is to provide you with some basic experience in database design, and to introduce you to Entity Relationship diagrams as a modelling tool.

Access the Web site for a bookseller such as Amazon (www.amazon.com). Use the Web site to determine the three best (in your opinion) books on XML for someone who is just learning that subject. As you use the Web site, think about the structure of a possible database of books, authors, subjects and related topics.

Develop an ER diagram of a book database for this web site. Show your entities (there should be 5-7 of them) and relationships and at least two or three attributes per entity. Indicate minimum and maximum numbers of items for both sides of each relationship. Possible entities are TITLE, AUTHOR, PUBLISHER, COPY, and SUBJECT. Naturally there are many other possible entities and ways of segmenting the information used on the site. Model any multi-value attributes by transforming them into entities (normalizing). You may use sub-types if appropriate.

Transform your ER diagram into a set of relational tables. The tables should be normalized to a minimum of Boyce-Codd normal form.

To keep this assignment manageable, assume that ONLY the books and information about them are to be included in your database. Moreover, constrain the design to the needs of someone looking for books to purchase. Do not consider customer ordering, order fullfillment, purchase ordering, and other such business processes.

Turn in the following:

This exercise is based on one in Database Processing by David Kroenke