Primary and foreign keys for the database
Not what you're looking for?
What are the appropriate primary keys and given the chosen primary keys, what are the appropriate foreign keys?
branch(branch name, branch city, assets)
customer (customer name, customer street, customer city)
loan (loan number, branch name, amount)
borrower (customer name, loan number)
account (account number, branch name, balance)
depositor (customer name, account number)
Purchase this Solution
Solution Summary
This posting answers the question on primary and foreign keys.
Solution Preview
What are the appropriate primary keys and given the chosen primary keys, what are the appropriate foreign keys?
branch(branch name, branch city, assets)
Primary Key: Branch Name
Appropriate Foreign keys:
• Loan. Branch name
This foreign key can be used to access the details of the Bank Branch from which the loan has been taken.
• Account.branch name
This foreign key can be used to access the details of the branch to which the account belongs from table "branch".
customer (customer ...
Purchase this Solution
Free BrainMass Quizzes
Javscript Basics
Quiz on basics of javascript programming language.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Basic Networking Questions
This quiz consists of some basic networking questions.