What is a Foreign key?

0 votes
Hi!!

What is a foreign key?
Oct 26, 2018 in Database by darklord
• 6,140 points
28 views

1 answer to this question.

0 votes
  • Foreign key maintains referential integrity by enforcing a link between the data in two tables.
  • The foreign key in the child table references the primary key in the parent table.
  • The foreign key constraint prevents actions that would destroy links between the child and parent tables.
answered Oct 26, 2018 by darklord
• 6,140 points

Related Questions In Database

0 votes
1 answer

What is a covered Index?

A covering index is an index that contains all ...READ MORE

answered Oct 10, 2018 in Database by Frankie
• 9,810 points
32 views
0 votes
1 answer

What is a Relationship and what are they?

Relation or links are between entities that ...READ MORE

answered Oct 23, 2018 in Database by DataKing99
• 8,100 points
14 views
0 votes
1 answer

What is a Join in terms of database?

JOINS are used to combine rows from ...READ MORE

answered Nov 13, 2018 in Database by DataKing99
• 8,100 points
32 views
0 votes
1 answer

What is MSLAB and LZO?

MSLAB stands for Memstore-Local Allocation Buffer. Lempel-Ziv-Oberhumer (LZO) ...READ MORE

answered Jul 10, 2018 in Database by Data_Nerd
• 2,360 points
67 views
0 votes
1 answer

What is Functional dependency?

A relation is said to be in ...READ MORE

answered Aug 10, 2018 in Database by DataKing99
• 8,100 points
33 views
0 votes
1 answer

What is Proactive/Retroactive/Simultaneous Update

Proactive Update: The updates that are applied ...READ MORE

answered Aug 17, 2018 in Database by CodingByHeart77
• 3,680 points
126 views
0 votes
1 answer

What is schema?

The description of a database is called ...READ MORE

answered Aug 17, 2018 in Database by CodingByHeart77
• 3,680 points
36 views
0 votes
1 answer

What is Data partitioning?

This is the process of partitioning tables, ...READ MORE

answered Aug 22, 2018 in Database by DataKing99
• 8,100 points
103 views
0 votes
1 answer

What is Data Redundancy?

Duplication of data in the database is ...READ MORE

answered Aug 16, 2018 in Database by darklord
• 6,140 points
91 views
0 votes
1 answer

What is checkpoint in Database?

Checkpoint declares a point before which all ...READ MORE

answered Sep 4, 2018 in Database by darklord
• 6,140 points
96 views