Question: (50 points) Given the following schema (missing key information and constraints), use the column names to identify any functional dependencies that hold between the attributes.

(50 points) Given the following schema (missing key information and constraints), use the column names to identify any functional dependencies that hold between the attributes. Book (ISBN, Title, PublishedDate, PublishedBy, Authorld, AuthorName, AuthorBirthday) For example, under the assumption that a book has only one author, we would expect ISBN to be a key, and so ISBN Title PublishedDate, PublishedBy, Author Id, AuthorName, AuthorBirthday is a functional dependency for the schema. You don't need to list any functional dependencies which can be derived from the splitting rule
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
