Home > Terms > English (EN) > foreign key
foreign key
In relational databases, an attribute in an entity that gives it access to rows in another entity. This attribute must be the primary key of the related entity. For example, an Employee entity can contain the foreign key deptID , which matches the primary key in the entity Department. You can then use deptID as the source attribute in Employee and as the destination attribute in Department to form a relationship between the entities. See also primary key, relationship.
Other Languages:
Member comments
Terms in the News
Billy Morgan
Sports; Snowboarding
The British snowboarder Billy Morgan has landed the sport’s first ever 1800 quadruple cork. The rider, who represented Great Britain in the 2014 Winter Olympics in Sochi, was in Livigno, Italy, when he achieved the man-oeuvre. It involves flipping four times, while body also spins with five complete rotations on a sideways or downward-facing axis. The trick ...
Marzieh Afkham
Broadcasting & receiving; News
Marzieh Afkham, who is the country’s first foreign ministry spokeswoman, will head a mission in east Asia, the state news agency reported. It is not clear to which country she will be posted as her appointment has yet to be announced officially. Afkham will only be the second female ambassador Iran has had. Under the last shah’s rule, Mehrangiz Dolatshahi, a ...
Weekly Packet
Language; Online services; Slang; Internet
Weekly Packet or "Paquete Semanal" as it is known in Cuba is a term used by Cubans to describe the information that is gathered from the internet outside of Cuba and saved onto hard drives to be transported into Cuba itself. Weekly Packets are then sold to Cuban's without internet access, allowing them to obtain information just days - and sometimes hours - after it ...
Asian Infrastructure Investment Bank (AIIB)
Banking; Investment banking
The Asian Infrastructure Investment Bank (AIIB) is an international financial institution established to address the need in Asia for infrastructure development. According to the Asian Development Bank, Asia needs $800 billion each year for roads, ports, power plants or other infrastructure projects before 2020. Originally proposed by China in 2013, a signing ...
Spartan
Online services; Internet
Spartan is the codename given to the new Microsoft Windows 10 browser that will replace Microsoft Windows Internet Explorer. The new browser will be built from the ground up and disregard any code from the IE platform. It has a new rendering engine that is built to be compatible with how the web is written today. The name Spartan is named after the ...
Featured Terms
Bloody Mary
There is a legend that on Halloween night, if a woman walks up a staircase backwards while holding a mirror and candle, she'll be able to see her ...
Contributor
Featured blossaries
Browers Terms By Category
- Film titles(41)
- Film studies(26)
- Filmmaking(17)
- Film types(13)
Cinema(97) Terms
- Industrial automation(1051)
Automation(1051) Terms
- Fuel cell(402)
- Capacitors(290)
- Motors(278)
- Generators(192)
- Circuit breakers(147)
- Power supplies(77)