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
Post a Comment