Relationships and entity relationship diagrams A table in a database holds the attributes for one entity only . Data can then be added in the form of records .

A fact table holds the data that needs to be analyzed, and a dimension table stores data dealing with how the data in the fact table can be analyzed. A dimension table, present in the star or ...