Product vs logical keys8/23/2023 What attribute of the student do you think will uniquely identify each of them? You could refer to a student by using their name, department, year and section. Let us take a real-life example of the database of each student studying in an engineering college. ![]() Keys allow us to be free from this hassle. There should be a way to identify each record separately and uniquely, i.e. Now there can be thousands and thousands of such records, some of which may be duplicated.įeatured Program for you: Fullstack Development Bootcamp A table in a database represents a collection of records or events for a particular relation. Why are the Keys Required?Ī key is used in the definitions of various kinds of integrity constraints. You can also consider doing our Java Bootcamp course from upGrad. Keys are imperative for analyzing and identifying data types. These can also help find all the available details maintained on the server about the candidate, such as their address, passport number, or phone number are keys unique to each candidate. ![]() For example, every unique identification number is used to identify candidates in an educational institute.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |