Question
Consider the relation R (isbn, title, publisherId, publisherName, readerId, readername, dateTime, unitPrice, number) and the set of functional dependencies: isbn -> {title, publisherId} publisherId ->
Consider the relation R (isbn, title, publisherId, publisherName, readerId, readername, dateTime, unitPrice, number) and the set of functional dependencies: isbn -> {title, publisherId} publisherId -> {publisherName} readerId -> readername {isbn, readerId, dateTime} -> {unitPrice, number}
a. Decompose R into 2NF but not 3NF.
b. Further decompose result of (a) into 3NF.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Intelligent Databases Object Oriented Deductive Hypermedia Technologies
Authors: Kamran Parsaye, Mark Chignell, Setrag Khoshafian, Harry Wong
1st Edition
0471503452, 978-0471503453
