0
Primary key is the unique attribute among all attributes of an object, which alone is sufficient to represent a sigle entity.
for example
a table has columns student id, stdent name, father name, class, department etc.
so here "student id" is primary key bcoz it cann't be same for two students, where other attributes like name and class can be same for more than one student.
hence primary key is the attribute which represent a unique entity and is sufficient to search the tuple (row) of table having that primary key value.
Firdous Anjum The Great :)
COMSATS Institute of Information Technology, Lahore.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
Have all tables primary key?
No, all tables do not have primary key. Primary must be explicitly defined and must not be null.
What key links tables together?
The Primary Key
The purpose of the primary key in building the relationship between tables?
primary keys are unique
What does primary key mean in ict?
it key that will enable you link the two tables together for relationship
What is a foreign key in Microsoft Access?
It is a field in one table that is a primary key in another table. It is used to create a relationship between two tables, normally a one to many relationship. The one side is where it is the primary key and where it is the foreign key, that is the many tables.
What key defines a relationship between two tables 1 Primary key 2 Secondary key 3 Foreign key?
Foreign key is used to define a relationship between two tables by referencing the primary key of another table. It ensures data integrity and enforces referential integrity between the related tables.
What ensures the value of the foreign key matches another tables primary key?
It is the DBMS that ensures the value of the foreign key matches another table's primary key when referential integrity constraints are enabled within the DBMS
True or false A foreign key is a field in one table that refers to the primary key field in another table and indicates how the the tables are related?
True.
In access to create a relationship between two tables the two connected fields must have the same what?
Primary key
What is added to a relational database to eliminate many to many relationships?
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
Is non key is same as those key that are not primary key?
A non-key field can be any field in the table that is not the primary key. During the process of normalisation identifying non-key fields is important, as they and other fields may be moved and new tables created. Foreign keys will be left in the table.
What is the difference between Primarey key and Forn Key?
establishing a relation between two tables called fornkey.......the colum name should be unique is called "primary key"...a table contain only one primary key...a table contain more then one fornkey....
