Tables are the structures that store related data. Data is organized into columns and rows. At the intersection of each column and row is a field (or cell). Each field contains one piece of data.

The column identifies the type of data in the fields within it (for example, user ID). A row identifies all the data related to a particular record that is stored in the table.

Every table in a database has a column for the primary key. The primary key uniquely identifies each record in the table. For instance:

User ID

Last Name

Age

01

Smith

34

02

Washington

42

03

Hanna

29

Banner enables you to quickly, easily, and most important graphically view and update the information stored in the tables used at your institution.

Would you like more information about how a database fits together with Oracle and Banner?

Do you want to know what a block is?

Want to learn about primary keys?