A comprehensive introductory textbook for use in undergraduate and graduate information systems or computer science database courses, as well as for independent readers.
The authors have prepared materials for instructors using the book in their classes.
All of these resources are available from the publisher's website here.
The SQL code for every SQL statement in Chapter 5 is available for six popular RDBMS packages (IBM DB2, Microsoft SQL Server, MySQL, Oracle, PostgreSQL and Teradata) in these PDF files:
The PDF documents are organized in a fashion that allows for copying and pasting of single or multiple SQL statements into the RDBMS for execution.
This is an expanded version of the ZAGI Retail Company Sales Department Database whose schema is the same as the schema shown in Figure 5.1a on page 130 in Chapter 5 (and earlier in Figure 2.13 on page 21 in Chapter 2, and in Figure 3.32 on page 70 in Chapter 3). ZAGIMORE has all the same records as the ZAGI database plus additional records in each of the tables. This database can be used for exercises E5.1 on page 175, as well as for queries shown in Chapter 5. Readers, students and instructors can also use this database to create their own SQL exercises.
View the ZAGIMORE database records.
Text files containing the INSERT INTO statements for ZAGIMORE are available below. (CREATE TABLE statements for ZAGIMORE are the same as CREATE TABLE statements for ZAGI.)
This is an expanded version of the HAFH Realty Company Property Management Database whose schema is shown in Figure 5.39a on page 158 in Chapter 5 (and earlier in Figure 2.38 on page 35 in Chapter 2, and in Figure 3.59 on page 79 in Chapter 3). HAFHMORE has all the same records as the HAFH database plus additional records in each of the tables. This database can be used for exercises E5.2 on page 175, as well as for queries shown in Chapter 5. Readers, students and instructors can also use this database to create their own SQL exercises.
View the HAFHMORE database records.
Text files containing the INSERT INTO statements for HAFHMORE are available below. (CREATE TABLE statements for HAFHMORE are same as CREATE TABLE statements for HAFH.)
Teradata University Network (TUN) - www.teradatauniversitynetwork.com is a free, faculty-directed portal for faculty, undergraduate, graduate and executive students studying data warehousing, business intelligence/decision support systems, and database.
Instructors can create free accounts on this web site by following the Faculty Registration link. To enable students to create free accounts on TUN, instructors have to create their own free account first and then, once they log into their account, retrieve the student password (available under STUDENT PASSWORD link). This password will enable students to create free accounts at TUN as well.
Once instructors and students have TUN accounts, they should click on: SOFTWARE/Teradata Database, in order to access Teradata SQL Assistant / Web Edition.
In order to quickly learn how to use Teradata SQL Assistant / Web Editon in your classes you can use the following SQL Assistant Quick Warm-Up Exercise.
Instructors and students can use Teradata SQL Assistant / Web Edition to issue SQL queries against already created and populated ZAGI, HAFH, Zagimore and Hafhmore databases. The following are the names of these data sets in Teradata SQL Assistant / Web Edition on TUN that should be entered in the Default Database box when prompted:
Databases ZAGI, HAFH, Zagimore and Hafhmore can be used to write queries for exercises 5.1 and 5.2 on page 175, as well as for other queries.
In addition, instructors and students can create, populate and query their own databases using the Teradata SQL Assistant / Web Edition.
Teradata University Network (TUN) - www.teradatauniversitynetwork.com is a free, faculty-directed portal for faculty, undergraduate, graduate and executive students studying data warehousing, business intelligence/decision support systems, and database.
Instructors can create free accounts on this web site by following the Faculty Registration link. To enable students to create free accounts on TUN, instructors have to create their own free account first and then, once they log into their account, retrieve the student password (available under Quick Links). This password will enable students to create free accounts at TUN as well.
Once the students have their account, they can undertake the following simple exercise that illustrates basic functionalities of an OLAP/BI tool: