One-to-one
A one-to-one relationship allows the user to input one variable, which in turn will give one answer back.
One-to-many
A one-to-many relationship is the most common. This allows the user to input one variable and receive many in return, such as your basic search engines.
Many-to-many
This relationship is prevalent in advanced searches that allow you to input multiple variables and receive multiple answers in return.
Three-tier model
This model illustrates three separate processes being run in the database.
- User Interface: The the client software/web browser or what the user actually sees.
- Business Logic. The bridge between the client and database.
- Back-End: The database itself
Database Examples:
The NHL Hockey Database:
An extensive collection of information covering everything from scoring, standings, team jerseys and even trading cards for current and former NHL players/franchises.
d'ART.com: The Internet Art Database
A rather extensive list of various fine arts, artists, and marketplaces to purchase such works. Though vast in appearance, the attention to detail and specification of the segmented styles is quite a benefit to those affiliated with the art world.
Maverick9911@aol.com
