The choice of normal form is often relegated to the database designer and is mostly invisible to the end users. Five levels of standards exist for normalization. To achieve a consistent view of the information, the field will need to be normalized to one form or the other. For example in one data- base you might have “telephone” as XXX-XXX-XXXX while in another it might be XXXXXXXXX. As the name implies, normalized data has been converted from native format into a shared, agreed upon format. The con- sistency of the database and much of its value are achieved by “normalizing” the data. The primary key is often the first column in the table. These tables are defined by their columns, and the data is stored in the rows. Relational databases are built on one or more relations and are represented by tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |