Designing a Sample Application
IN THIS CHAPTER
Discovering the client’s problem
Taking a first run at the problem
Deciding on the deliverables
Creating and transforming an Entity-Relationship model
Creating, changing, and deleting tables
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 ...