Chapter 4

Designing a Sample Application


Bullet Discovering the client’s problem

Bullet Taking a first run at the problem

Bullet Deciding on the deliverables

Bullet Creating and transforming an Entity-Relationship model

Bullet Creating, changing, and deleting tables

Bullet Building the user interface

The whole point of knowing SQL is being able to apply that knowledge to solve some problem. Individuals and organizations need information to conduct their businesses, whatever they may be. At any given time, the information they need is buried within a huge collection of data, the vast majority of which they don’t need right now. The key to being able to retrieve information that you do need is to make sure that it’s organized in a way that facilitates retrieval, regardless of your specific needs today.

In this chapter, I go through the steps of creating an application that gives one (fictitious) organization ...

Get SQL All-In-One For Dummies, 3rd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.