513 views
0 votes
0 votes

I am not getting that how many attributes must be there in the Borrowed by table which actually represents a table since we have the constraint that one user can borrow only one book .

1 Answer

0 votes
0 votes
in above given e-r diagram one is to one relation is given since it hav both two arrows facing towards entity it means that one user can take only one user and also conversly says that one book is borrowed by one user so in both entity book and user one primary key that must be present in borrowed table i.e. accesetion no and  card no. and one attribute is DOI of borrowed relation so minimum attribute will be 3

Related questions

0 votes
0 votes
2 answers
3
radha gogia asked Mar 7, 2016
2,748 views
The hash function is randomly chosen from a universal class of hash functions , then what is the probability of any collision ?