Relational Databases

A relational database provides three main levels of data storage: field, record, and table. A field stores a single piece of data such as a last name or a salary.

A record stores a record of related fields. For example, a record might store fields giving a particular employee’s name, address, phone number, job title, and salary.

A table holds a collection of records that all contain the same kinds of fields. For instance, a table named Employees would hold records containing data for all the company’s employees. Each record would contain the same fields (FirstName, LastName, Street, and so forth), though the fields would have different values in different records.

A physical analogy to this structure is a filing room. ...

Get Visual Basic® .NET Database Programming 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.