Question

Draw the E-R diagram (5 pts) and petri-net (7 pts) for the following requirements in a college library:
There are two types of books: regular and reserved, and two types of users: students and faculty members. A student
can check out a regular book for 1 month, while a faculty member can borrow one for 2 months. A late return will
incur a fine measured by the number of days. A reserved book can be checked out by any user for three hours. The fine
for the later return is charged by the number of hours. Any user who returned books later than the deadline for more
than twice will be levied an extra amount of money. A regular book checked out for more than 100 times will be put on
sale. A reserved book checked out for more than 50 times will be put back as a regular book.

Answer 1

Sol:

Identifies the entities, their attributes, relation between entities, cardinality of relations and use the standard crow foot notation for ER Diagram..

Comment