1. Create an EER diagram to keep track of information for an art museum given that the following criteria is met:   The museum has a collection of art objects. Each art object has a unique identification, an artist (if known), a year (when it was created, if known), a title, an epoch (Renaissance, Modern, Ancient, etc.), and a description. The arts objects are classified in the museum in several ways as discussed below:  Arts objects are categorized based on their type. The main types are: painting and sculpture, plus another type they called “other” to accommodate objects that do not fall into one of the two main types.   A painting has a paint type (oil, watercolor, etc.), material on which it is draw on (paper, canvas, wood, etc.), and style (modern, abstract, impressionism, etc.).   A sculpture has a material from which it was created (wood, stone, iron, etc.), height, weight, and style.   An art object in the other category has a type (print, photo, etc.) and a style.  Art objects…

Imagine two entities A and B, each of which has the property X (among other names not relevant to this topic) among other properties. Can the design improve without connecting the two Xs?

Q1 Draw the F-R diagram , a collaboration class diagram  and petri-net 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 for all users will incur a fine measured by the number of days, same for students and faculty. A reserved book can be checked out by any user for 4 hours. The fine for the later return is charged by number of hours. Any user who returned any 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 20 times will be put back as a regular book.