Computer Science
Welcome Everyone Arora Educator
“Arora Educator” Official Platform
By : Sachin Arora Sir
Founder : AE (Arora Educator)
WhatsApp : 97 606 89 846
Arora Educator
Arora Educator : Stay Connected
YouTube Channel Link –
https://www.youtube.com/@AroraEducator/
Telegram Link –
https://t.me/AroraEducatorChannel
Instagram Link –
https://www.instagram.com/aroraeducator.official/
Arora Educator App Link –
https://play.google.com/store/apps/details?id=co.stan.xsjqp
Arora Educator
Database/DBMS/RDBMS
Arora Educator
Database Keys
Arora Educator
Database Keys
1. Super Key
2. Candidate Key
3. Primary key
4. Alternate key
5. Composite Key
6. Foreign Key
1. Super key Arora Educator
✓ A super key is a group of single
or multiple keys which identifies
rows in a table.
✓ The super key would be Roll No
+ Name + Mobile Number + Age
2. Candidate key Arora Educator
✓ Candidate key is a minimal Super key.
✓ It can uniquely identify a tuple
✓ Candidate key are distinct set of attributes from
which primary key can be selected
{Emp_Id}
{Aadhar_No}
{Email_Id}
3. Primary key Arora Educator
✓ One of the candidate key
✓ The Primary Key can't be a duplicate.
✓ A table cannot have more than one primary key.
✓ The primary key field cannot be null.
Candidate keys
{Emp_Id} = PK
{Aadhar_No}
{Email_Id}
4. Alternate keys Arora Educator
✓ Out of all candidate keys, only one gets
selected as Primary key, remaining keys are
known as Alternate keys
✓ In table, Emp_id is PK
✓ Asdhar_No & Email_Id are Alternative key
Candidate keys
{Emp_Id} = PK
{Aadhar_No} = AK
{Email_Id} = AK
5. Composite Key Arora Educator
✓ When there is no primary key = Join
attributes and create a primary key.
✓ Or.Collection of primary key.
✓ Also called Compound key
✓ ATM Card + PIN
✓ Username + OTP on mobile
Arora Educator
6. Foreign key
✓ Foreign keys are the column of
the table which is used to point to
the primary key of another table.
✓ in the EMPLOYEE table,
Department_Id is the foreign key,
and both the tables are related.
✓ Used to link 2 tables together.
Relational Database Management System Arora Educator
RDBMS
Rows = Tuples
Columns = Attributes
पंक्तिय ाँ = टुपल्स
कॉलम = एट्रिब्यूट्स
Arora Educator
Number of Tuples = Cardinality
Number of Attributes = Degree
टुपल्स की संख्य = क र्डिनैललटी
गणु ों की संख्य = र्डग्री
Relationship / Cardinality Arora Educator
✓ 3 Types
1) One to One
2) One to Many
3) Many to Many
One to One Arora Educator
One to Many
Many to Many
Arora Educator
Arora Educator : Stay Connected
YouTube Channel Link –
https://www.youtube.com/@AroraEducator/
Telegram Link –
https://t.me/AroraEducatorChannel
Instagram Link –
https://www.instagram.com/aroraeducator.official/
Arora Educator App Link –
https://play.google.com/store/apps/details?id=co.stan.xsjqp
Computer Science
Welcome Everyone Arora Educator
“Arora Educator” Official Platform
By : Sachin Arora Sir
Founder : AE (Arora Educator)
WhatsApp : 97 606 89 846
