This topic will help you learn more about the platform independent model used to describe the structure of data.
The Database schema describes the structure of data, regardless of its stored form. This Conceptual Data Model borrows from the Entity-Relationship Model with the basics concepts of entities, properties, keys and foreign keys relationships.
Item | Concept | Stored form |
---|---|---|
| A data source is a collection of data with a specific representation of its structure as entities and relationships. | Dbms databases, files, online services... |
| Entities are collections of objects constructed from properties with a unique entity key. | Database table, service entity, worksheet, file... |
| Properties define the shape and characteristics of data. | Table column, file field... |