Scribd
Upload
34 views1 page

Compound vs Composite Keys Explained

Keys in a database management system (DBMS) are attributes that uniquely identify rows in a table and allow relationships to be defined between tables. There are seven types of keys that serve different purposes, such as uniquely identifying rows, defining relationships between tables, or comprising a combination of attributes.

Uploaded by

Zubair Rizwan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
34 views1 page

Compound vs Composite Keys Explained

Keys in a database management system (DBMS) are attributes that uniquely identify rows in a table and allow relationships to be defined between tables. There are seven types of keys that serve different purposes, such as uniquely identifying rows, defining relationships between tables, or comprising a combination of attributes.

Uploaded by

Zubair Rizwan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

What are Keys?

A DBMS key is an attribute or set of an attribute which helps you to identify a


row(tuple) in a relation(table). They allow you to find the relation between two
tables. Keys help you uniquely identify a row in a table by a combination of
one or more columns in that table.

DBMS has folwing seven types of Keys each have their different functionality:

 Super Key
 Primary Key
 Candidate Key
 Alternate Key
 Foreign Key
 Compound Key
 Composite Key
 Surrogate Key

You might also like