Review - How Databases Store Information

1) Fields are generally organized as columns and so many users will refer to them as a column. For example, a table with fields for name, quantity, and price will often ask for the columns of name, quantity, and price.

2) Records are generally organized as rows. For example, a table with five records will generally be displayed as a set of headers (for each field) with five rows of data, each row consisting of a single record.

3) Of these, only the specific book option represents a singular specific data item. Each of the other items could be classified as either a database (the library), a table (the grocery list), or a field / table (list of book titles).

4) Database relationships serve to link diverse pieces of information together, such as an owner with his shirts and shoes or a transaction with a store. Fields group common elements of information together, and records store data. A database generally stands alone but tables within databases

Complete and Continue