Fixing a schema
There are lots of principles and heuristics involved in designing a relational database schema—in fact, it can get quite complicated—but in practice you can usually come up with a pretty reasonable schema if you just keep breaking up a problematic table or field until you have a set of related tables that comply with the rules. The process is called DECOMPOSITION.
Eliminate Non-Scalar Values
In this sense, SCALAR means single—as opposed to compound—values, like separating the given names into separate fields. Sometimes these values should be separate fields in the table, and sometimes you’ll just need to find a way to keep people ...
Get Fluent Entity Framework now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
