At some point in our lives, all of us have come across this term called the primary key. So what’s the use of a primary key? Let us take an example to understand it in a better way. Suppose I have a firm, my own company, and I want to store the record of each person working in my organization. Then, when I have a few fields like DOB, date of joining, age, salary, and employment ID, there are certainly chances that any two records of two different persons can have almost everything similar. What I mean to say is two people, who have joined the company on the same date, have been offered the same salary package and coincidentally have their birthdays on the same date, and they may even have the same age also. Now, to make the situation worse, there may be one in a hundred cases where even the names of both persons become the same. ( I myself had five students named Ayush in my high school). So, it becomes a matter of confusion for the HR department to keep track of them, which may lead to serious misconceptions. So, in that case, We have to define a particular field, which we call the primary key, which will be unique for each employee. Each employee, here, in our example, can be assigned a unique employment id, which can serve as the primary key. It should be kept in mind that computers, as a device, originated as a military devices whose sole work was to coordinate with the military requirements. So, typically, the databases were created, creating a unique identification number, which would be similar to the unique military id assigned to each machine during the WW2 era. You can also think of it as the aadhar card number. There is a requirement to assign a field as a primary key. You cannot simply assign any field randomly to be the primary key. The main criterion is it should not contain similar data for 2 different entries. And then, no particular cell should be left vacant. If these two conditions are satisfied, then you are all ready to set that field as a primary key.
1000+ Courses for Free
Log in
If an account with this email id exists, you will receive instructions to reset your password.
MS Access
MS Access
What is MS Access? MS Access-RDBMS Understanding the Relational Database Concept Components of MS Access –Objects How to create a Database? MS Access –Data Types MS Access –Create Tables All About The Primary Key Query Data And Query Criterion RELATING DATA WILDCARDS Queries and filters Difference between Access and ExcelAll About The Primary Key
< MS Access –Create Tables
Query Data And Query Criterion >
< MS Access –Create Tables
Query Data And Query Criterion >
Explore 1000+ Free Courses
Sign up
Setting up your account...
Loading...
Welcome to GL Academy!
We see that you have already applied to .
Please note that GL Academy provides only a small part of the learning content of Great Learning. For the complete Program experience with career assistance of GL Excelerate and dedicated mentorship, our Program will be the best fit for you. Please feel free to reach out to your Learning Consultant in case of any questions. You can experience our program by visiting the program demo.
We see that you are already enrolled for our
Please note that GL Academy provides only a part of the learning content of your program. Since you are already enrolled into our program, we suggest you to start preparing for the program using the learning material shared as pre-work. With exclusive features like the career assistance of GL Excelerate and dedicated mentorship, our is definitely the best experience you can have.
We see that you are already enrolled for our
Please note that GL Academy provides only a part of the learning content of our programs. Since you are already enrolled into our program, please ensure that your learning journey there continues smoothly. We will add your Great Learning Academy courses to your dashboard, and you can switch between your enrolled program and Academy courses from the dashboard.
We will add your Great Learning Academy courses to your dashboard, and you can switch between your Digital Campus batches and GL Academy from the dashboard.
We see that you are interested in .
Please ensure that your learning journey continues smoothly as part of our pg programs.
GL Academy provides only a part of the learning content of our pg programs and CareerBoost is an initiative by GL Academy to help college students find entry level jobs.
1000+ Courses for Free
Log in
If an account with this email id exists, you will receive instructions to reset your password.