Appendix A. Glossary


A fact or piece of information about a real-world thing such as a car, person, or customer.


An ERD relationship property that describes the number of related instances an entity may have. For example, a student may take many courses. Many identifies the cardinality.

Cartesian join

A join procedure that matches each of the records in the first table to each of the records in the second table. This type of join is caused by the omission of the join condition(s) in the WHERE clause.


A method of storing tables that are related and that are often used together. It can increase performance.


One of the attributes that are stored in a table. Database tables are comprised of records ...

Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.