What is Key, Describe different types of KEYS & INDEX

ICS Part 2 Chapter 2 Basic Concept of Database What is Key, Describe different types of KEYS & INDEX

In this lecture we discuss with Practicals & Animation at the end of lectures :

1)What is KEY , Describe Different types of keys used in Database? 

KEY

1. Primary Key
2. Composite Key/Concatenate key 
3. Candidate Key 
4. Alternate Key 
5. Foreign key 
6. Secondary Key 
7. Sort Key/Control Key 

2) What is the usage of INDEX in FMS & DBMS?

3) Now So Let's Start For Practical With Example

#ICSPart2 #Database #Chapter2 #Keys #typesOfKeys #Index

Computer Lecturer: Shahzaib Naz