Do you know how to create relational data.,..
Quote:
A relational database management system (RDBMS) takes things one step further by creating relationships among the tables that make up a database. These relationships can then be used to combine data from multiple tables in various ways, allowing a user to view the same data from various perspectives and then use this enhanced vision to make better (read: more efficient and cost-effective) business decisions. By creating links among related pieces of information, an RDBMS thus not only makes it possible to store information more efficiently (by removing redundancies and repetition), but it also brings to the fore hitherto undiscovered relationships among disparate segments of data and permits efficient exploitation of those relationships.
source
|
To normailization...
Quote:
Database normalization can essentially be defined as the practice of optimizing table structures. Optimization is accomplished as a result of a thorough investigation of the various pieces of data that will be stored within the database, in particular concentrating upon how this data is interrelated. An analysis of this data and its corresponding relationships is advantageous because it can result both in a substantial improvement in the speed in which the tables are queried, and in decreasing the chance that the database integrity could be compromised due to tedious maintenance procedures.
source (part 1)
source (part 2)
|