Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please complete Foreign Keys Section. Thank you..... The Multnomah County Library provides a variety of ervices to citizens of the county. First, the library offers

image text in transcribed

Please complete Foreign Keys Section. Thank you.....

The Multnomah County Library provides a variety of ervices 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 brary services are offered to all county citizens, each patron must obtain library card to check out books. The library also offers a number of computers for patron use. Thc 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 m y check out. The library als maintains a number of small meeting rooms that patrons may reserve for meetings. Issue library cards Books andF DVDs 1.1 (county citizen) 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 Required1 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 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 Options Book/dvd catalog Computer Checkout Transaction Country Card Room Reservation card issue patron phone Patron Room Library Employee Library card category Room, Patron computer use session No Foreign Key Computer Patron

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Database Management Systems Designing And Building Business Applications

Authors: Gerald V. Post

1st Edition

0072898933, 978-0072898934

More Books

Students also viewed these Databases questions

Question

How We Listen?

Answered: 1 week ago