Database Tables
Tables are the basic data structure in any relational database. A table is nothing more than an organized collection of records, or rows, that all have the same attributes, or columns. Figure 5-2 illustrates a typical CUSTOMERS table in a relational database.
Each customer record in the example CUSTOMERS table has the same attributes, including an ID, a company name, a last name, a first name, and so on.
When you create tables, the two primary things that you must consider are the following:
The table's columns, which describe the table's structure
The table's integrity constraints, which describe the data that is acceptable within ...
Get Hands-On Oracle Database 10g Express Edition for Windows 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.
