eWebArchitecture :: Vermont's premiere Web design, eCommerce, Web database and application provider. eWebArchitecture :: Solutions for the information age.
Home About Us About eWebArchitecture Hip Tips Web News and Development Tips Portfolio Portfolio Pricing Web Development Pricing Contact Us Contact eWebArchitecture Staff
SERVICES
We offer royalty-free use of customizable interfaces for private and commercial Web sites and multimedia projects. Web Site Design
We develop elegant shopping cart applications for your Web site, and invite you to peruse our eCommerce demo application. eCommerce
Our programming expertise enables us to create and develop exciting and interactive Web sites for use over the Internet and over corporate intranets as well. Web Programming
We create client-server applications and database-integrated Web sites without our clients spending a fortune. Web Databases
HIP TIPS

Usability Tip:
RESET Button and Forms

No online form would be complete without a SUBMIT button. But what about that other button: the CLEAR or RESET button that erases the user's input? Does it help the user? Generally, the answer is no. Often a RESET button does more harm than good.

HTML Tip:
Renewed Importance Of META Tags

META tags are back — at least with some search engines. Depending on your site design and technology, good META tags may be one route to improved search engine rank.

CSS Tip:
You Are Here

One easy way to make your navigation menu more user-friendly is to disable the current page in the menu. We'll show you how to accomplish this using basic HTML and CSS: no JavaScript or PHP coding required!

Search Tips:
Search Tip Archive
Burlington Web Designers
Vermont Web Designers

Database Concepts
Main Topics:
Subtopics:

Relational Database Management Systems (RDBMS)

  • A database is a collection of data that is organized and stored according to some purpose.
  • A relational database organizes such data into tables.

It's easier to illustrate this concept than try to explain it. Below is an example of a table that might appear in a book database.

Table of Books
ISBN Title Author
0-67980527-3 Oh, The Places You'll Go! Dr. Seuss
0-553-21037-8 The Brothers Karamazov Fyodor Dostoevsky
0-451-17512-3 The Fountainhead Ayn Rand
0-452-28062-1 Beloved Toni Morrison
0-374-51199-3 Cancer Ward Aleksandr Solzhenitsyn
1-56592-434-7 MySQL & mSQL Randy Yarger, George Reese and Tim King

The table has a name, several columns, and rows containing data for each of the columns.

A relational database represents data in tables such as this and provides retrieval operations that generate new tables from existing ones. As a result, the programmer sees the database in the form of such tables.


Database Management Systems (DBMS) Database Management Systems (DBMS) SQL: Structured Query Language SQL: Structured Query Language

Web Design eCommerce Web Programming Web Databases Site Map Contact Us
© 2003-2008 eWebArchitecture, Ltd. All rights reserved.