[ Thanks to Kevin
Reichard for this link. ]
“To test and compare three database management systems, I
doubtlessly needed a database to manage with them. After
having read SQL for Dummies, I had some basic knowledge of how
realistic databases are designed, so I picked a particularly
unimaginative real-world case (an Internet bookstore, what else?)
and wrote up a little database design exploiting a couple of SQLs
capabilities.”
“There are five tables in this database. BOOK stores the
available books with bookkeeping information; CUSTOMER contains the
registered customers. For every order, a row in BOOKORDER is
created, referencing the respective customer. For every item
ordered, a row in ORDER_POSITION references the respective order.
As a kind of bonus, I’ve added a RATING table for book
ratings.”
“The following is SQL code that can be fed into a DBMS’s SQL
monitor and should be accepted without any problem. All the tables
are dropped before creation so the script won’t bail out if some of
them already exist.”