Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required: Develop a UML class diagram with classes, associations, and multiplicities based on the following narrative: The Multnomah County Library provides a variety of services

Required: Develop a UML class diagram with classes, associations, and multiplicities based on the following narrative: 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. Books and DVDs F O..* issue library cards C 1..1 O.. A B 1..1 Rooms D C H 1..1 1..1 (county citizen) E 1..1 Use the UML class diagram 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. Then, answer the following questions based on your Access tables. Required: 1. Match each of the tables with the corresponding primary key from the list of primary keys. 2. Match each of the tables with a primary key from the list of primary keys that would be posted in the table as a foreign key. Required 1 Required 2 Match each of the following tables with the corresponding primary key from th Tables a. Rooms b. Room Reservations Primary Keys Room Number Room Reservation Number C. Patrons d. Check Out Books/DVDs e. f. Computers Issue Library Cards g. Computer Use Sessions h. Books and DVDs Patron Number Book/DVD Catalog Number Computer Number Card Issue Number Computer Number Book/DVD Catalog Number Required 1 Required 2 Match each of the following tables with a primary key from the list of primary a foreign key. (If more than one foreign key can apply, select an option that keys apply, select "No Foreign Key".) Tables Foreign Keys a. Rooms b. Room Reservations C. Patrons d. Check Out Books/DVDs e. Computers f. Issue Library Cards g. Computer Use Sessions h. Books and DVDs No Foreign Key Room Reservation Patron Phone Book/DVD Catalog No Foreign Key Card Issue Computer No Foreign Key

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions