answersLogoWhite

0

You use foreign keys to relate the information on one table to another.

For example,

Table one has customer information, name, address, user-id, etc

and

Table two has the orders that the customers request.

Customer-id, item, number of items, cost per item, taxes, shipping address, etc..

You put in a foreign key on the orders table, so that the Customer-id is related to the User-id on the Customer table one.

OK ?

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

Explain the concept of foreign key How a foreign key differs from a primary key?

Foreign keys are used to link one database with another. A primary key is an attribute of a record that allows users to identify information.


How do you use foreign key in to oracle?

the foreign key referential between two tables.


How do you write a sentence for foreign?

It was a foreign concept, for me.


Why you need primary key and foreign key?

In sql you use primary key more than one column in a table


What is a key concept in math?

"key concept" is not a mathematical term . A key concept is an important idea. Two key concepts in math are derivatives and integrals of functions. ( "function" is also a key concept.)


The key foreign policymakers are?

The key foreign policy makers are?


What is the key concept of studying society?

what is the key concept of society


Could a table only have one primary key and only one foreign key?

Yes it could. It would have a primary key for its own use and it could then have a foreign linking it to another table. If it is only linked to one other table, then it would only need one foreign key. It is also possible to have the same foreign key linking to more than one table.


Can a foreign key be null?

yes .a foreign key can have null values


Key concept of nature organization?

key concept of nature organization


Why do you designate one of the candidate key of relation to be the primary key?

We designate one of the candidate key of a relation to be a primary key because that primary key is use for any foreign key references.


What are the two key methods the governments use to intervene in foreign trade?

war and sanctions.