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

  

Transcribed Image Text:

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. Issue library cards F Books and DVDS 1.1 (county citizen) 1.1 1.1 A B 1.1 1.1 Rooms 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 foreign key. Complete this question by entering your answers in the tabs below. Required 1 Required 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. (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 Foreign Keys Rooms a. b. Room Reservations C. Patrons d. Check Out Books/DVDS e. Computers f. Issue Library Cards g. Computer Use Sessions h. Books and DVDS Options Book/dvd catalog Room Computer Card Room Reservation Patron Checkout Transaction card issue Employee Library card category Library computer use session Country patron phone No Foreign Key Room, Patron Computer, Patron 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. Issue library cards F Books and DVDS 1.1 (county citizen) 1.1 1.1 A B 1.1 1.1 Rooms 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 foreign key. Complete this question by entering your answers in the tabs below. Required 1 Required 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. (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 Foreign Keys Rooms a. b. Room Reservations C. Patrons d. Check Out Books/DVDS e. Computers f. Issue Library Cards g. Computer Use Sessions h. Books and DVDS Options Book/dvd catalog Room Computer Card Room Reservation Patron Checkout Transaction card issue Employee Library card category Library computer use session Country patron phone No Foreign Key Room, Patron Computer, Patron

Answer rating: 100% (QA)

FOREIGN key is used to link two tables FOREIGN key of a one table is the primary key in another tabl... View the full answer