Homework 1
Administrivia
Out: 28th January, 2006.
Due date: At the beginning of the lecture on 7th February, 2006. Please submit a hard
copy of your homework. Bring it down to the lecture table (the one with the PC that I use
to display the slides).
The hard copy should be as clearly readable as possible. You may be subtracted points
for unreadability and ugly presentation.
Off-campus students: You should e-mail your solutions to Yoonkyong Lee
<[email protected]> in the pdf format. Send the pdf file as attachment with your email by
2 PM UIUC time (CST). Off-campus students in other time zones should note that the
deadline is according to CST.
Please note: Late homework will not be accepted, barring exceptional
circumstances.
Goal of this homework: To get you to practice and learn important concepts in conceptual
design with ER model, and to get started on relational model.
ER Basics
Problem 1. (25 points) Consider the database of an online bookstore.
• Every book has a title, isbn, year and price. The store also keeps the author and
publisher for any book.
• For authors, the database keeps the name, address and the url of their homepage.
For publishers, the database keeps the name, address, phone number and the url of
their website.
• The store has several warehouses, each of which has a code, address and phone
number.
• The warehouse stocks several books. A book may be stocked at multiple
warehouses. (In previous sentence, we are not referring to a particular copy of the
book. Consider for example “the complete book” for our course. This book may
be stocked at multiple warehouses.)
• The database records the number of copies of a book stocked at various
warehouses.
• The bookstore keeps the name, address, email-id, and phone number of its
customers.
• A customer owns several shopping basket. A shopping basket is identified by a
basketID and contains several books.
