|
A database model is a set of definitions describing how real-world data is conceptually represented as information in the computer
|
The relational model - database collects related information in a set of tables.
-
A table either contains the attributes of an entity or the relationships between entities
|
|
In the example problem, people and phone numbers are entities;
|
|
Title, uid etc. are attributes of the person entity; type is attribute of phone number entity
|
|
pid is used to set up relationships between entities
|
