Foreign Key
Duration: 4 min
This video lesson is available to enrolled students.
Inside: a video lesson and guided study material.
Module outline
- Quantitative Aptitude: Number System, Percentage, Profit and Loss, Ratio and Proportion (Ratios), Average, Time and Work, Speed Time and Distance, Simple Interest and Compound Interest, Mixture and Alligation, Data Interpretation, Permutation and Combination, Probability, Logarithm, Powers and Exponents (Surds and Indices), Age Problems, Divisibility Rules, Partnership, HCF LCM, Algebra, Pipe and Cistern
- Logical Reasoning: Series (Number and Letter Series) (Numerical Relations and Reasoning), Analogy, Coding Decoding, Blood Relations, Directions (Direction Test), Syllogisms, Logical Sequence Of Words, Data Sufficiency, Seating Arrangements, Puzzle Solving (Puzzles), Calendar, Clock, Cubes & Dices, Deductive and Inductive Reasoning (Logical Deduction and Induction) (Prepositional Reasoning), Data Arrangement
- English Language: Comprehension / Reading Comprehension / Unseen Passages (Critical Reasoning) (Paragraph Questions), Sentence Correction (Error Correction), Sentence Completion (Fill in the blanks), Vocabulary, Sentence Re-arrangements (Para Jumbles) (Narrative Sequencing), Active Passive Voice (Voice), Direct and Indirect Speech, Cloze Test (Cloze Passage), Tenses, Subject Verb Agreement (Verb Noun Agreement), Preposition, Articles, Conjunction, Adverb
- Written English Test: English Writing Ability
- Coding: Coding Questions by Yash Sir, C Programming by Yash Sir, Programming in C++, Java, Python for Placements by Yash Sir
- Communication Round: Communication Assessment
- DBMS (Technical Interview): Basics of DBMS, ER Diagram, Relational Model & Functional Dependencies, Keys & Integrity Constraints, Normalization (1NF - BCNF), Decomposition Properties & 4NF, File Organization & Indexing, Relational Algebra, Relational Calculus, Transaction Management, Concurrency Control, Database Recovery, ORDBMS, Database Security & Authorization, Query Processing & Optimization, Enhanced Data Models, Big Data Systems, NoSQL, Data Warehousing & Mining
- SQL (Technical Interview): SQL
- Operating Systems (Technical Interview): Introduction to OS, Process Management, CPU Scheduling, Process Synchronization, Deadlock, Threads & Process Creation, Memory Management, Virtual Memory, Disc Scheduling, File Management, Windows OS, Linux OS, Security, Distributed Systems, Virtual Machines
- Computer Networks (Technical Interview): Introduction to CN, Data Communication, DLL: Access Control, DLL: Flow Control, DLL: Error Control, DLL: Framing, Data Link Layer - Ethernet, Net Layer: IPv4 & Proto, Net Layer: IP Addressing, Net Layer:Routing Protocol, Transport Layer Services, TL: Congestion & UDP, Application Layer, Hardware basics, Network Security, Cloud Computing and IoT, Cyber and Info Security
- OOPs (Technical Interview): Object Oriented Programming (OOPS)
- HR Interview: MR & HR Interview Preparation
AI summary & chapters
AI Summary
An AI-generated summary of this video lecture.
The lecture introduces the concept of Foreign Keys in relational database management systems. The instructor begins with a formal definition, explaining that a foreign key is a column or group of columns that refers to the primary key of the same or another table to establish a relationship. He highlights that the concept of referential integrity stems from foreign key theory. The lesson progresses to practical examples, starting with a student database table containing redundant information about branches. The instructor demonstrates normalization by splitting this into two tables: a student table and a branch table. He identifies `Br_code` as the primary key in the branch table and a foreign key in the student table, drawing a relationship arrow between them. He emphasizes that the foreign key values must exist in the referenced primary key column. Finally, he introduces a second example involving student IDs and marks IDs to further illustrate how foreign keys link tables and enforce data integrity constraints.
Chapters
0:00 – 2:00 00:00-02:00
The instructor defines a foreign key using on-screen text: "A foreign key is a column or group of columns in a relational database table that refers the primary key of the same table or some other table to represent relationship." He introduces the concept of referential integrity. He then presents a large table with columns `Roll no`, `name`, `Age`, `Br_code`, `Br_name`, and `Br_hod_name`. He explains that this table has redundancy. He decomposes it into two tables: a student table (`stu`) with `Roll no`, `name`, `Age`, `Br_code` and a branch table (`Br`) with `Br_code`, `Br_name`, `Br_hod_name`. He marks `Br_code` in the student table as a Foreign Key (FK) and `Br_code` in the branch table as a Primary Key (PK). He draws a red curved arrow from the FK to the PK to show the relationship. He circles the `Br_code` values (101, 101, 101, 102) in the student table to show they reference the branch table. He writes 'stu' and 'Br' next to the tables.
2:00 – 4:18 02:00-04:18
The instructor continues the explanation of the relationship between the tables. He writes "FK <= PK" above the red arrow, signifying that the set of foreign key values must be a subset of the primary key values. He circles the `Br_code` column in the top table and writes "FK <= PK" again to reinforce the constraint. He then transitions to a new example on a blank slide. He draws a table with columns `S_id` and `M_id`. He populates the table with values: `S_id` has 1, 2, 3, 4, 5, 6 and `M_id` has 1, 1, 1, 4, 4, 4. He explains that `M_id` acts as a foreign key referencing a marks table. He draws an arrow from `M_id` to the right to indicate the reference to another table. He emphasizes that the values in the foreign key column (`M_id`) must correspond to valid primary keys in the referenced table, ensuring referential integrity.
The video effectively bridges theoretical definitions with practical database design. By starting with a formal definition and immediately applying it to a normalization example, the instructor clarifies how foreign keys eliminate redundancy. The visual aids, such as the decomposition of the student-branch table and the "FK <= PK" notation, provide clear visual cues for understanding referential integrity constraints. The transition to a second example with `S_id` and `M_id` reinforces the concept that foreign keys are not limited to a single scenario but are a fundamental mechanism for linking related data across different tables in a relational database.

