I have problem two question related to each other, And the part question 6 you may create the tables using excel

I have problem two question related to each other, And the part question 6 you may create the tables using excel.


5. Develop a UML class diagram with classes, associations, and multiplicities based on the following
narrative: LO 3-2, LO 3-3
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 5 books and 2 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.
6. Use the UML class diagram you created for Problem 5 to create an Access database for the library.
Make up at least three fields for each table, including one field that will be the primary key. LO 3-4

Purchase answer to see full
attachment