Please look through the fields and tables. List out all the functional dependenc
ID: 3695007 • Letter: P
Question
Please look through the fields and tables. List out all the functional dependencies.
If you find any transitive dependencies, please decompose your tables to eliminate it.
INSERT into Book(Genre, BookNumber,Title) VALUES 1 (fantasy 1111, Harry Potter and the Sorcers Stone) INSERT into Book(Genre, BookNumber, Title) VALUES ('action', 1112", 'The Hunger Games'); INSERT into Book (Genre, BookNumber, Title) VALUES (' horror", . 1113·,' Goosebumps' ); INSERT into Branch(Address,State, Town) VALUES 600 Edmore Ln N, 'NY", 'West Islip'); INSERT into Branch(Address,State, Town) VALUES ('1 Chief Path, NY', Brentwood) INSERT into Author (First_Name, Last_Name, Title) VALUES (J.K., Rowling, 'Harry Potter and the Sorcers Stone); INSERT into Author (First_Name, Last_Name,Title) VALUES ("R.L', Stine', Goosebumps); INSERT into Author (First_Name, Last_Name, Title) VALUES Suzanne, Collins, 'The Hunger Games); INSERT into Patron (E mailAddress,First Name, Last Name) VALUES ss,First_Name, Last_Name) VALUES (' mc cannmike123@yahoo.com. . Michael·,' McCann) ;l INSERT into Patron (EmailAddress,First_Name, Last_Name) VALUES ddlovato@gmail.com, 'Demi', Lovato) INSERT into Copy_of_Book (Title,Author,Due_Date) VALUES Goosebumps, Stine',to_date(7-5-2016', 'dd-mm-yyyy)); select from Book 1112, Author Stine where Book 1112-GoosebumpsExplanation / Answer
Answer for Question:
Book( Genre, BookNumber, Title)
Branch(Address, State, Town)
Author(First_Name, Last_Name, Title)
Patron(EmailAddress, First_Name, Last_Name)
Copy_of_Book(Title, Author, Due_Date)
Functional Depend ices :
Book and Copy_of_Book are have the Functional Dependency.
Author and Patron have the Functional Dependency
There is no Transitive Dependency