“The most popular data model in DBMS is the Relational Model. It is more scientific a model than others. This model is based on first-order predicate logic and defines a table as an n-ary relation. The main highlights of this model are:
- Data is stored in tables called relations.
- Relations can be normalized, [in which case] values saved are atomic values.
- Each row in a relation contains a unique value.
- Each column in a relation contains values from a same domain.”
Each
"Test Your Foundation Knowledge" post presents one or more misconceptions
about data fundamentals. To test your knowledge, first try to detect them, then
proceed to read our debunking, which is based on the current understanding of
the RDM, distinct from whatever has passed for it in the industry to date. If
there isn't a match, you can acquire the knowledge by checking out our POSTS, BOOKS, PAPERS, LINKS (or, better,
organize one of our on-site SEMINARS, which can be
customized to specific needs).