What are the suitable foreign keys

Assignment Help Computer Engineering

Reference no: EM1335558

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)

Reference no: EM1335558

Questions Cloud

Application of second amendment : Did the Court of Appeals for the District of Columbia arrive at the right decision about the DC gun law and the Second Amendment?

Describe the use of queries in an ehr : define a query that you would use as a continuous tool in an EHR.

The scientific method of research : Explain the scientific method of research.

The corporate business and functional objectives : Find The corporate business and functional objectives.

What are the suitable foreign keys : What are the appropriate primary keys and given the selected primary keys, what are the appropriate foreign keys.

Reviewing the ev technique and calculations : After reviewing the EV technique and calculations, does the method have any use when monitoring a project?

Domestic and international strategic planning : Find the difference between domestic and international strategic planning.

The opposing negotiators : Using the case study from "A Power Play for Horward, in Many Acts", October 27, 1996, by Bill Brubaker and Mark Asher. The opposing negotiators

While is it important to denormalize a database : What is the meaning of denormalization, and why can it be desirable? Provide an example.

User Account

All Pages