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 6.5

FEATURE

Introducing Databases

How to Design and Use SQL Databases in the REAL World

Issue: 6.5 (July/August 2008)
Author: Mike Titlebaum
Author Bio: Mike Titlebaum is the Director of Software Development at Sirota Survey Intelligence (http://www.sirota.com) in Purchase, NY where he oversees the development efforts of 15 web and database programmers. In his years of programming efforts, he has designed and implemented hundreds of relational SQL databases to solve complex business problems for a variety of small and large businesses including the Bank of America, Dell, United Health Group, Pfizer, TD Bank, Shell Oil, ConocoPhillips, and many others. He has enjoyed using REALbasic since 1999.
Article Description: This session will introduce aspiring programmers to the theory and methodology behind the effective design and usage of relational databases in an increasingly data-driven world. Key database concepts such as one-to-many and many-to-many relationships will be covered. Other important topics will include normalization, primary keys, foreign keys, and effective query design. The session will also show how easy it is to get started with databases using REALbasic together with SQLite, REALbasic's powerful built-in database engine.
Article Length (in bytes): 17,438
Starting Page Number: 16
Article Number: 6509
Resource File(s):

Download Icon 6509.zip Updated: 2008-07-01 11:42:38

Related Web Link(s):

http://www.sirota.com
http://www.saxmike.com/RW
http://www.sqlite.org
http://en.wikibooks.org/wiki/SQL
http://www.w3schools.com/sql/default.asp
http://www.sqliteman.com
http://sqlabs.net/

Excerpt of article text...

Databases (and programming in general) are used to solve business problems. In order to learn about how to use a relational database, let's try to solve a sample business problem we've been presented with. We will soon see why we need to use a relational database rather than a simple spreadsheet.

Let's say we work for a large company. Our company would like to build sports complexes at each of its locations. They would like to determine what kinds of athletic facilities need to be built and then to determine what sports equipment should be purchased for each location. In order to help them make these decisions, we have been asked to design a system that will allow them to keep track of the sports the employees play. The system should be built to the following specifications:

  • The company has several locations with thousands of employees at each, and wants to find out the most popular sports in each location.

    Employees often play multiple sports.

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