Question: What are the primary keys?? please fill out for question one! Required information Required: Use the following narrative to complete the UML class diagram with

 What are the primary keys?? please fill out for question one!Required information Required: Use the following narrative to complete the UML classdiagram with classes, associations, and multiplicities outlined below and then answer questions:The Multnomah County Library provides a variety of services to citizens of

What are the primary keys?? please fill out for question one!

Required information Required: Use the following narrative to complete the UML class diagram with classes, associations, and multiplicities outlined below and then answer questions: The Multnomah County Library provides a variety of services to citizens of the county. First, the library offers a number of traditional books to be checked out by patrons. Each patron may check out up to 5 books at one time. Although library services are offered to all county citizens, each patron must obtain a library card to check out books. The library also offers a number of computers for patron use. The library tracks computer use sessions. Each patron uses his/her library card number to logon and is then allowed to use the computer for up to 30 minutes per session. The library also offers movies on DVD that patrons may check out. The library also maintains a number of small meeting rooms that patrons may reserve for meetings. ICELY IUUIIS LIUL PULUIS layieselve IUI Celily. 0..* Issue library cards Books and DVDs 1.1 (county citizer Rooms Use the UML class diagram you completed 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. Then, answer the following questions based on your Access tables. Required: 1. Match each of the following tables with the corresponding primary key from the list of primary keys below. 2. Match each of the following tables with a primary key from the list of primary keys below that would be posted in the table as a foreign key. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Match each of the following tables with the corresponding primary key from the list of primary keys below. (If more than one foreign key can apply, select an option that represents both applicable keys. If no foreign keys apply, select "No Foreign Key") Tables Primary keys a. Rooms Room Reservations Patrons Check Out Books/DVDs Computers Issue Library Cards g. Computer Use Sessions Books and DVDs e. h. Required information Required: Use the following narrative to complete the UML class diagram with classes, associations, and multiplicities outlined below and then answer questions: The Multnomah County Library provides a variety of services to citizens of the county. First, the library offers a number of traditional books to be checked out by patrons. Each patron may check out up to 5 books at one time. Although library services are offered to all county citizens, each patron must obtain a library card to check out books. The library also offers a number of computers for patron use. The library tracks computer use sessions. Each patron uses his/her library card number to logon and is then allowed to use the computer for up to 30 minutes per session. The library also offers movies on DVD that patrons may check out. The library also maintains a number of small meeting rooms that patrons may reserve for meetings. ICELY IUUIIS LIUL PULUIS layieselve IUI Celily. 0..* Issue library cards Books and DVDs 1.1 (county citizer Rooms Use the UML class diagram you completed 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. Then, answer the following questions based on your Access tables. Required: 1. Match each of the following tables with the corresponding primary key from the list of primary keys below. 2. Match each of the following tables with a primary key from the list of primary keys below that would be posted in the table as a foreign key. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Match each of the following tables with the corresponding primary key from the list of primary keys below. (If more than one foreign key can apply, select an option that represents both applicable keys. If no foreign keys apply, select "No Foreign Key") Tables Primary keys a. Rooms Room Reservations Patrons Check Out Books/DVDs Computers Issue Library Cards g. Computer Use Sessions Books and DVDs e. h

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q: