O'Reilly logo

Fluent Entity Framework by Rebecca M. Riordan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Image 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required