Database Organization & Structure
What is a database?

How is a database structured?

What is a database?

Databases are large storehouses of data that contain small sets of related information called records. Each record can further be broken down into even smaller sets of specific information called fields. The diagram below illustrates these concepts.

An example of a simple database in print form is the telephone directory.
Like telephone directories which vary in content--the yellow pages, the white pages, and directories for particular geographic areas--bibliographic databases, or databases of information resources, like The CAT and Proquest Direct, also vary in content--records of books, periodicals, and government documents, just to name a few.

A Sample database record

This is a sample database record. Within each record, there are fields of information.

Each field is highlighted in red. This record has six fields-
Title
Author
Periodical
Publication Date
Subject Headings
Abstract

You can choose to search one or all of the fields in a record.

Title: "Responsible Consumerism"
Author: Doe, Jane
Periodical: Consumer Issues
Publication Date: March 25, 1997
Subject Headings: Sustainable Development; Responsible Consumerism; Social Responsibility; Ethical Consumerism.

Abstract: The underlying principle of sustainable development is that three areas - economic growth, environmental protection, and social equity - are linked. Some key issues in the study of sustainable development include controlling world population growth, agricultural production in an environmentally sound manner to meet increasing demand for food, limiting greenhouse gases to prevent climate change, preserving biodiversity, and responsible consumerism. Individuals often feel powerless to effect positive change towards sustainable development. But activities in support of responsible consumerism have had measurable impact on the growth of socially responsible companies. Awareness of "eco-efficiency" issues such sweatshops, child labor, and third-world working conditions in the production of consumer goods, and attention to energy consumption , packaging, waste and recycling policies of companies, have focused attention on global consumption and consumer ethics. Public opinion regarding the environment and consumer issues is changing business practices. College and university students especially have drawn significant attention to ethical consumer issues. Businesses have learned that socially responsible policies can make them attractive to consumers and more competitive in the marketplace.

© 2002-2008 University Libraries, The Pennsylvania State University

About This tutorial
Please direct questions to Library Learning Services
Last updated 07/24/02