Question:
I’m looking for sample database in a form of
Create Table statement+Insert statements
and beginner-level assignments using this database. Do you know where I can find something like that?
Answer:
There are a couple of freebies you could avail yourself of. Try getting Introduction to Database Systems by Chris Date. Inside you will find an appendix for the SP database (Suppliers Parts database). It is the foundation for all his examples and having it set up will make doing the assignments easy.
Another good one is the Groff and Weinberg sample database, available off the CD in their new edition of SQL: The Complete Reference (Osborne/McGraw-Hill, 1999)?worth the money, BTW.