Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 1.3

COLUMN

Database Design

Entities, Attributes and Relationships

Issue: 1.3 (December/January 2002)
Author: Paul Lefebvre
Author Bio: Paul Lefebvre is a software architect in Portland, Maine.
Article Description: No description available.
Article Length (in bytes): 7,801
Starting Page Number: 27
Article Number: 1313
Related Link(s): None

Excerpt of article text...

In this month's column we will discuss some basic database design skills such as how to identify entities, attributes, and relationships. We will also learn what it means to normalize a database. Let's get started!

Database Analysis

Analysis is the first step when designing a relational database. In the analysis phase, we are looking to identify entities and attributes. When the database is eventually built, the entities generally become tables and their attributes become columns within the tables.

In our last column we quickly created tables to store the schedule for our local Softball League. In this column we will step back and consider the initial design of these tables. To refresh you memory, here is the original problem:

We want to store the schedule for our local Softball League that consists of 8 teams, each with a coach. Each team plays 10 games. The teams are the Ducks, Penguins, Bears, Tigers, Lions, Wolves, Dolphins, and Marlins.

...End of Excerpt. Please purchase the magazine to read the full article.