The whole point of using a database is to turn data into information. Data are facts which have no inherent meaning; information is data put into context to convey meaning. Think of a customer database containing information such as customer names, addresses and phone...
This third article in the series delves into the database heartland by exploring relational database design. One of the best ways to understand the importance of good database design is to start with an all-in-one, flat-file table design and then toss in some sample...