00:01
In this question there are four subpart and we have to answer one by one each part.
00:05
So here i mentioned each part in a concise form.
00:09
So for a is non -trivial, functional dependency, isbn, here we have to mention isbn, in which included title, author, publisher name, publisher ad, total copies order, copies in stock, publication date, category, selling price and cost.
00:32
So these are all mentioned in isbn.
00:35
Now next mention is author, here we have to mention title, isbn, publisher name, publisher ad, total copies order, copies in stock, publication date, category, selling price, cost.
00:58
Now in publisher name, we have to add publisher and isbn here we have to add a publication date and again in isbn we have to add a selling price, cost.
01:16
Now coming to the b part, candidate keys and primary keys.
01:21
So here we have to identify which is the candidate key and which is the primary key in this question...