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.