Page Not Found

Note: December 7, 2023

Student ClassEntities has moved to the following page Identify Many To Many - Relationships

Note: April 8, 2020

Pet Store tables have moved to Data Tables

Note: March 5, 2020

Basic Structured Query Language has moved to Basic SQL

Note: July 23, 2019

simple-varray-query

has moved to simple varray query

Note: January 11, 2017

The following directory has changed.
inserting Rows into nested Tables has moved to inserting Rows into nested Table
  1. The key word that you searched for has brought you to this page.
  2. This site is updated frequently, the page you are looking for still exists but now has a different extension.
  3. Go to the home page of this site by clicking the link below or the link in the upper left hand corner.
  4. The keyword will be listed in the table of contents of the home page.
  5. If you do not see what you are looking for on the home page, enter your query into the Search textbox.
RelationalDB Design - Go to Home Page
When designing a database, you have to make decisions regarding how best to take some system in the real world and model it in a database. This involves deciding which tables to create, what columns they will contain, as well as the relationships between the tables.
A well-designed database takes time and effort to conceive, build and refine.
The benefits of a database designed according to the relational model are as follows.
  1. Data entry, updates and deletions will be efficient.
  2. Since the database follows a well-formulated model, it behaves predictably.
  3. Since much of the information is stored in the database rather than in the application, the database is somewhat self-documenting.
  4. Changes to the database schema are easy to make.

Database Design

- Go to the home page by clicking on the link below
Link to Home Page.