borrowerNo B023 B141 B687 name Ted Brown Irina Petkevits Nancy Herman dateOfBirth address email 6/22/1997 250 Main St, 1B tbrown@gmail.com 9/14/1992 32-52 78th Av ipetkevits@yahoo.com 5/29/2001 36 Broad St, 3F nherman@bmcc.cuny.edu BookLoan ISBN copyNo dateOut dateDue borrowerNo 2220000002 2 9/12/2018 10/3/2018 B023 5550000005 1 9/2/2018 9/23/2018 B141 9990000009 2 8/27/2018 9/17/2018 B687 9990000009 3 9/7/2018 9/28/2018 B023
borrowerNo B023 B141 B687 name Ted Brown Irina Petkevits Nancy Herman dateOfBirth address email 6/22/1997 250 Main St, 1B tbrown@gmail.com 9/14/1992 32-52 78th Av ipetkevits@yahoo.com 5/29/2001 36 Broad St, 3F nherman@bmcc.cuny.edu BookLoan ISBN copyNo dateOut dateDue borrowerNo 2220000002 2 9/12/2018 10/3/2018 B023 5550000005 1 9/2/2018 9/23/2018 B141 9990000009 2 8/27/2018 9/17/2018 B687 9990000009 3 9/7/2018 9/28/2018 B023
Fundamentals of Information Systems
8th Edition
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter4: Telecommunications And Networks
Section: Chapter Questions
Problem 5SAT
Related questions
Question
Identify for each table, the followings:
Foreign keys
Candidate keys
Primary key
Alternate keys
![Borrower
borrowerNo
name
B023 Ted Brown
B141
B687
Irina Petkevits
Nancy Herman
dateOfBirth address
email
6/22/1997 250 Main St, 1B |tbrown@gmail.com
9/14/1992 32-52 78th Av ipetkevits@yahoo.com
5/29/2001 36 Broad St, 3Fnherman@bmcc.cuny.edu
BookLoan
ISBN copyNo dateOut dateDue borrowerNo
2220000002 2 9/12/2018 10/3/2018 B023
5550000005 1 9/2/2018 9/23/2018 B141
9990000009 2 8/27/2018 9/17/2018 B687
9990000009 3 9/7/2018 9/28/2018
B023](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F69f80107-36b9-4a5e-971d-23645d88a0f0%2F0411994b-c7c0-4076-995d-5ddbdc7df545%2Fc85m3r_processed.png&w=3840&q=75)
Transcribed Image Text:Borrower
borrowerNo
name
B023 Ted Brown
B141
B687
Irina Petkevits
Nancy Herman
dateOfBirth address
email
6/22/1997 250 Main St, 1B |tbrown@gmail.com
9/14/1992 32-52 78th Av ipetkevits@yahoo.com
5/29/2001 36 Broad St, 3Fnherman@bmcc.cuny.edu
BookLoan
ISBN copyNo dateOut dateDue borrowerNo
2220000002 2 9/12/2018 10/3/2018 B023
5550000005 1 9/2/2018 9/23/2018 B141
9990000009 2 8/27/2018 9/17/2018 B687
9990000009 3 9/7/2018 9/28/2018
B023
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Fundamentals of Information Systems](https://www.bartleby.com/isbn_cover_images/9781305082168/9781305082168_smallCoverImage.gif)
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
![Fundamentals of Information Systems](https://www.bartleby.com/isbn_cover_images/9781305082168/9781305082168_smallCoverImage.gif)
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning