Additional Information for Chapter,
Chapter References that are Online, Web
Sites to Supplement this Chapter, Browse the
Index
Table 16-3 on page 267 is erroneous. Click here to see the correct table.
If you have suggestions for information that would be helpful in understanding this chapter in the book, please email a note to .
(The links in this section are off this site. Inclusion here is for your convenience in locating more information about a topic. Inclusion does not indicate endorsement.)
Ambler, S. (2002). Relational Databases 101: Looking at the Whole Picture.
For a good description read sections "Relational Database Technology,:
and the first paragraph of the next section. After that it gets very technical.
http://www.agiledata.org/essays/relationalDatabases.html#RelationalDatabaseTechnology
Ashenfelter, J. P. (1998). Web databases: How and why to implement them in
education. A 30 page pdf file that is excellent.
Provides a full description of databases, terminology etc. (Added
May 20, 2004)
http://www.cit.cornell.edu/atc/materials/old/dbdesign/dbdesign.pdf
A database dictionary. In the definition for each term, links to the definition
for other terms is provided. A valuable asset
http://www.geekgirls.com/database_dictionary.htm
Bostrup, T. (n.d.) Introduction to Relational Databases - Part 1: Theoretical
Foundation. This article provides Codd's 12 rules of database design, then
presents information about selecting key fields. If you scroll down to normalization
you will find an excellent description of each of the seven forms with examples
for the first three (the common ones). Excellent article and very easily understood.
(Added April 2, 2004)
http://www.15seconds.com/issue/020522.htm
Database Design. A 4 page simplifed primer on relational databases. A good
introduction to the subject. A pdf File
http://www.uis.edu/ctl/training/handouts/databasedesign.pdf
Excellent articles are listed on the right side of the menu at this site. An
excellent place to start learning about database design. At the end of the fifth
article is a link to download a database for use in querying.
http://www.geekgirls.com/menu_databases.htm
Overview of the Relational Model. Presents an informal introduction to relational
database design concepts. Includes information on data structures, relationships
and data integrity as well as others. (Added September
24, 2003)
http://www.utexas.edu/its/windows/database/datamodeling/rm/overview.html
Introduction to Data Modeling. A practical guide to using the Entity-Relatiohship
(ER) for data modeling. Best for someone who is familiar with relational databases,
but no experience in data modeling. Describes basic techniques. (Added
September 24, 2003)
http://www.utexas.edu/its/windows/database/datamodeling/
Lists characteristics of the various database models. Either view in Internet
Explorer or Netscape version 4.x. Text in Netscape 7 is about 6 point. Still
a good source of information. Under relational database there is a link to more
information about characteristics of a relational database that is also well
done.
http://www.frick-cpa.com/ss7/Theory_Models.asp
This article describes what a database model is, then describes a hierarchical,
network, relational database, and client-server databases.
http://www.databasejournal.com/sqletc/article.php/26861_1428721_3
Many of these sites have structured databases that can be downloaded and imported into either a spreadsheet or a database for querying. An Excel file is easily imported into an Access database. I have found, however, that the best results are obtained by first opening the file in Excel, selecting the part that is structured like a database, and copying that to a separate sheet.
Countries database in Access 97 or 2000. Has information such as population, area, and if a member of the UN.http://www.geekgirls.com/databasics_06.htm#sampledata
Federal Statistics - Government Statistics Database. This site has statistics
from more than 70 agencies in the United States Federal Government. The Federal
Interagency Council on Statistical Policy maintains this site to provide easy
access to the full range of statistics and information produced by these agencies
for public use.
http://www.fedstats.gov/
National Center for Health Statistics. This site provides information about
America’s health and compiles statistical information which can be accessed
from this site. (Added October 12, 2003)
http://www.cdc.gov/nchs/about/major/hdasd/nhds.htm
Statistics from the Center for Disease Control (CDC).
http://www.cdc.gov/scientific.htm
US Census Bureau Map Stats - Census Information Database. This site allows
you to find and download census information about a state or county. For use
in Access download either as an Excel file or comma delimited. Are zip files
which will require a tool to open.
http://quickfacts.census.gov/qfd/index.html
Vital Statistics Tables from California. These Excel tables can be imported
into Access if desired for querying.
http://www.dhs.ca.gov/hisp/chs/OHIR/tables/
Data Flow Diagrams. A textual description with instructions for creating. (Added
July 6, 2007)
http://www.compapp.dcu.ie/~renaat/ca2/ca214/ca214v.html
Kozar, K. (1997). The Technique of Data Flow Diagramming. A detailed
guide. of data flow diagramming techniques|
http://spot.colorado.edu/~kozar/DFDtechnique.html
Thearling, K. (2002). White papers on data mining. Articles are
surprisingly easy to comprehend. Also has a glossary of data mining terms. (Scroll
part way down the page or use your
Browser's find tool and search for glossary.)
http://www.thearling.com/
A precise definition of data mining and links to other sources.
http://webopedia.internet.com/TERM/d/data_mining.html
Reed, M. (2002)A Definition of Data Warehousing. An easily read
definition.
http://www.intranetjournal.com/features/datawarehousing.html
Shalvi, D. & DeClaris, N. ()An Unsupervised Neural Network
Approach to Medical Data Mining Techniques. Despite the foreboding title,
the first two parts of this are worth a visit. The first topic presents a helpful
description of data mining and section two looks at the difficulties in using
medical data.
http://www.ee.umd.edu/medlab/papers/dcsThShort/thpaper1.html
A series of excellent articles on planning a relational database, (http://www.databasedev.co.uk/planning_database.html), then more specifics in planning a Microsoft Access database(http://www.databasedev.co.uk/plan-an-access-application.html) that includes information about security.The latter provides a link to more information about security and one to creating a Microsoft Access database. Unfortunately, the first article does not link to the second one! There is a lot of ads on these pages, but the information is helpful for planning a database. (Added August 30, 2005)
Access Query Language Elements. Examples and explanations of many expressions
useful in queries. (Added January 6, 2004)
http://www.bris.ac.uk/is/selfhelp/documentation/acc-r4/acc-r4.htm
Access Tutorials for Access 2000 from Florida Gulf Coast University. Provides
step by step instructions in the computer skills along with images of the screen
at most steps.
http://www.fgcu.edu/support/office2000/access/
Building Custom features for Access. Four tutorials that include information
on creating custom functions, writing a VBA function, and building an Excel
add in.
http://www.fontstuff.com/vba/vbatut04.htm
A series of tutorials on designing and building databases. Uses step by step
procedures for both Lotus Approach (creating first database) and Microsoft Approach
(data entry, queries). Some excellent material. Should help in understanding
the concepts of databases.
http://www.geekgirls.com/menu_databases.htm
Normalizing a database. Much helpful information on this topic is available
from Microsoft suppor by searching for normalization.
http://support.microsoft.com/
Although not strictly a tutorial, this page lists the operators for many of
the expressions used in Access.. (Added January 6, 2004)
http://www.nova.edu/techtrain/apptrain/access/accessexpressions.html
A list of current tutorial documents maintained by the University of Bristol.
Scroll down (or use the Find option) to databases and make your seletion. (Added
January 6, 2004)
http://www.bris.ac.uk/is/selfhelp/documentation/docs-by-category.htm
(These references are from the chapter. This list only include the ones that are still available. Please report broken links to Linda Q. Thede)
Bourgoin, M, Smith, S. Stone, E. Thearling, K. &Yarmus, J.(1996). An introduction
to data mining. Retrieved May 5, 2002 from
http://www3.shore.net/~kht/text/dmwhite/dmwhite.shtml.
New URL is:
http://www.thearling.com/text/dmwhite/dmwhite.htm
(Changed June 8, 2004)
Kozar, K. F. (1997). Systems with data flow diagrams. Retrieved May 8, 2002
from
http://spot.colorado.edu/~kozar/DFD.html.
Which Client/Server Database Technology Fits? Experts and Practitioners Describe
Alternatives (2001). Retrieved May 5, 2002 from
http://www.pds-site.com/WhitePapers/wp_wdbfits.htm.
For questions or broken links please email the author .
Copyright 2003/2008 Linda Q. Thede
All rights reserved