Page 1 of 1

Is this properly normalized?

Posted: Wed Aug 23, 2006 12:17 pm
by tdnxxx444

Code: Select all

newspaper
-----------------
newspaper_id
title
city
state
editor

book
-----------------
book_id
title
author

comic
-----------------
comic_id
title
artist
Turned into:

Code: Select all

entity
------
entity_id
title

book
-----------------
book_id
entity_id
author

newspaper
----------
newspaper_id
entity_id
city
state
editor

comic
------
comic_id
entity_id
artist
Or is this unncessary? Also, what NF is this in?

Posted: Wed Aug 23, 2006 12:21 pm
by feyd
Either can work just fine, however the latter is easier to search all titles or display all titles from.

As for what form it is, I've never dug too deeply into caring what form I was using as long as it was as abstracted as I needed it to be for the purposes of now and projected future.

Posted: Wed Aug 23, 2006 12:52 pm
by sweatje
book.author newspaper.editor and comic.artist are not normalized. Any of those could be repeated (author of multiple books, etc.) also, an author of one book could be the editor of another newspaper, etc.