Hi

I have two tables, User and Book, in Book is a foreign key to UserID
in the User table. (Think of it as an extremely simple library
system).

How would I integrate Integrity Constraints so that 1 user can only
loan/belong to 6 books? I was looking into Stored Procedures/
Functions but was not sure how to go about incorporating this into the
database...

I would be extremely grateful for any help :)


Thanks

Lawrence