The Multnomah County Library provides a variety of services to citizens of the county. First, the...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Statistics Data Analysis and Decision Modeling
ISBN: 978-0132744287
5th edition
Authors: James R. Evans
Posted Date:
Students also viewed these databases questions
-
The Small Business Administration (SBA) provides a variety of services to small business owners. One service is the SBA's information on developing a Business Plan. A Business Plan is a key...
-
The Central Area Well-Baby Clinic provides a variety of health services to newborn babies and their parents. The clinic is organized into a number of departments, one of which is the Immunization...
-
The Excel file Cereal Data provides a variety of nutritional information about 67 cereals and their shelf location in a supermarket. Use regression analysis to find the best model that explains the...
-
Assume that Polaris manufactures and sells 60,000 units of a product at $ 11,000 per unit in domestic markets. It costs $ 6,000 per unit to manufacture ($ 4,000 variable cost per unit, $ 2,000 fixed...
-
Plot the hydrograph for the storm data given in Problem 1.22 (flow rate vs. time). Label the following: (a) Peak flow Qp, (b) Time to peak tP (distance from center of mass of rainfall to peak flow),...
-
This time, your mass is 87.0 kg and the sled s mass is 16.1 kg. You re on the sled, initially moving to the west at 9.61 cm/s. From the southern shore, your friend throws a baseball of mass 0.152 kg,...
-
Air flows steadily through a circular, constant-diameter duct. The air is perfectly inviscid, so the velocity profile is flat across each flow area. However, the air density decreases as the air...
-
Ganville Theater Production Companys partially completed worksheet as of December 31, 2016, follows. Requirements 1. Analyze the worksheet to determine the adjusting entries that account for the...
-
Two Riders players tackle the Argos quarterback in a football game. The first Riders player applies a force of 600 N [W] to the Argo player while the other Rider tackler impacts him with 750 N [S 15...
-
Toledo Clinic has two patient services departments: Adult Services and Pediatric Services The patient services departments are supported by General Administration, Facilities, and Financial Services....
-
What do the Law Code of Manu and the Quran show about the concepts of justice in the Hindu traditions and Muslim traditions? How are they similar or different?
-
How widely used is real option analysis?
-
Explain how growth options are like call options.
-
How did the bird-in-the-hand theory get its name?
-
What are the three ways in which a company can repurchase stock?
-
What is scenario analysis?
-
y = 10 Prove f(n) = 5n+n + ylogyn is O(nlogn) via definition of Big-0.
-
Transform the while loop from the previous exercise into an equivalent for loop (make sure it produces the same output).
-
A producer of computeraided design software for the aerospace industry receives numerous calls for technical support. Tracking software is used to monitor response and resolution times. In addition,...
-
Many manufacturing situations, such as the production of large and complex items as aircraft or machines, exhibit a learning effect in which the production time per unit decreases as more units are...
-
People arrive at a busy airport news kiosk at a rate that is uniformly distributed between five and ten seconds. Most people buy only one paper, which takes an average of six seconds, but may be as...
-
Recently Sparrow Ltd experienced temporary closure that affected a number of its operating plants. The group accountant of Sparrow Ltd indicated that it was not appropriate to report depreciation...
-
Parakeet Ltd has recently acquired a machine for an invoice price of \(\$ 70 \mathbf{0 0 0}\). Various other costs relating to the acquisition and installation of the machine include transportation,...
-
Seagull Ltd purchased land for use as its corporate headquarters. A small factory that was on the land when it was purchased was torn down before construction of the office building began....
Study smarter with the SolutionInn App