LinuxPlanet: A Linux DBMS Comparison, Part IINov 18, 1999, 21:21 (8 Talkback[s])
(Other stories by Matthias Warkus)
[ 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."