4NF Decomposition of Nested Relation title author position Suppose for simplicity that title uniquely identifies a Compilers Smith 1 book Compilers Jones 2 Networks Jones 1 In real world ISBN is a Networks Frick 2 unique identifier authors Decompose books into 4NF using the schemas: title keyword (title,author,position Compilers parsing (title,keyword Compilers analysis (title,pub-name,pub- Networks Internet branch Networks Web 4NF design requires users keywords to include joins in their queries. title pub_name pub_branch Compilers McGraw-Hill New York Networks Oxford London books4 Database System Concepts-6th Edition 22.6 ©Silberschat乜，Korth and SudarshanDatabase System Concepts - 6 22.6 ©Silberschatz, Korth and Sudarshan th Edition 4NF Decomposition of Nested Relation Suppose for simplicity that title uniquely identifies a book In real world ISBN is a unique identifier Decompose books into 4NF using the schemas: (title, author, position ) (title, keyword ) (title, pub-name, pub￾branch ) 4NF design requires users to include joins in their queries