The database side

Image

Contrary to public opinion, relational databases aren’t called “relational” because the tables are related to one another. They’re called relational because the tables are the physical representation of a conceptual object called a RELATION. Or at least they should be. Unfortunately, just arranging some stuff in rows and columns like a spreadsheet doesn’t make it a relation. There are rules. Well, one rule, really, but it’s usually understood as a set of NORMAL FORMS: We’ll be exploring them in the next few pages, but here are the basic rules:

Words For the Wise

Here’s an easy way to remember the rules for normal forms: ...

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.