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