sql - How to identify the highest normal form of a relation schema? -


let's have relation schema. how can state highest normal of relation?


for example:

  • art_object (art_id, title, description, country, artist, epoch, year)

"i wanna know normal form art_object in? test school."

normal form of given design depends on which functional dependencies hold.

without being given set of functional dependencies, question unanswerable.

if fd holds art_id -> {all attributes}, design in 5nf.

if on contrary there additional fd artist -> country, design isn't 3nf.


Comments

Popular posts from this blog

objective c - Change font of selected text in UITextView -

php - Accessing POST data in Facebook cavas app -

c# - Getting control value when switching a view as part of a multiview -