The Internet Encyclopedia (Volume 3)

P1: IML/FFX P2: IML/FFX QC: IML/FFX T1: IML

SQL ̇OLE WL040/Bidgolio-Vol I WL040-Sample.cls June 20, 2003 13:16 Char Count= 0

CROSSREFERENCES 363

TICKETPRICE

TICKETTYPE PRICE

KIDS 4.50

SENIORS 5.00

ADULT MAT 5.00

ADULTS 7.00

MOVIE

MOVIEID MOVIETITLE MOVIERATING PASSALLOWED

1 10001 THE BEST MAN IN GRASS CREEK PG Y

2 10002 A KNIGHT’S TALE PG-13 N

3 10003 BRIDGET JONES”S DIARY R Y

4 10004 ALONG CAME A SPIDER R Y

5 10005 CROCODILE DUNDEE IN L.A. PG Y

6 10006 BLOW R Y

7 10007 DRIVEN PG-13 Y

8 10008 EXIT WOUNDS R Y

9 10009 FREDDY GOT FINGERED R Y

10 10010 HEARTBREAKERS PG-13 Y

11 10011 JOE DIRT PG-13 Y

12 10012 FORSAKEN R Y

13 10013 MEMENTO R Y

14 10014 TOWN AND COUNTRY R Y

15 10015 THE MUMMY RETURNS PG-13 Y

16 10016 ONE NIGHT AT MCCOOL”S R Y

17 10017 SPY KIDS PG Y

18 10018 THE TAILOR OF PANAMA R Y

19 10019 ’CHOCOLAT’ PG-13 Y

20 10020 ’AMORES PERROS’ R Y

Figure 1:Relationship of tables used in this chapter.

GLOSSARY

Database Collection of relevant data organized using a

specific scheme.

Relational database Collection of data that conforms

to properties of the relational database model first

defined by E. F. Codd.

Relational database management system (RDBMS)

Software that manages a relational database.

SQL An industry-standard language for creating, updat-

ing, and querying a relational database.

Tuple Data object containing two or more components;

usually refers to a record in a relational database.

CROSS REFERENCES

SeeData Mining in E-Commerce; Data Warehousing and

Data Marts; Databases on the Web.