Consider the following narrative describing the operation of the Multnomah County Library.

The Multnomah County Library provides a variety of services to citizens of the county.

First, the library offers a number of traditional books and movies that may be checked out by patrons. Each patron may check out up to five books and two movies at one time. The library also offers several computers for patron use. The library tracks computer use sessions. Each patron may use the computer for up to 30 minutes per session.

The library also maintains a number of small meeting rooms that patrons may reserve for classes or events during normal operating hours. Although library services are offered to all county citizens, each patron must obtain a library card to check out books, use the computers, or reserve a room.

• Identify the classes described in the narrative.

• Identify the associations between classes.

• Define multiplicities for each association.

• Prepare the UML class diagram.

• Define tables and create at least three fields for each table, including the primary key.

• Assign foreign keys.

• Create an Access database using the UML class diagram and the corresponding tables and attributes. Create relationships among tables to implement the UML class diagram.