---
title: "What is a super key? How is it different from a candidate key ms-access?"  
description: "What is a super key? How is it different from a candidate key ms-access?"  
author: "Kalin"  
published: 2022-03-30  
canonical: https://answers.mindstick.com/qa/96615/what-is-a-super-key-how-is-it-different-from-a-candidate-key-ms-access  
category: "troubleshooting"  
tags: ["troubleshooting", "ms-access"]  
reading_time: 1 minute  

---

# What is a super key? How is it different from a candidate key ms-access?

What is a [super](https://yourviews.mindstick.com/view/83492/dassault-rafale-vs-boeing-f-a-18-super-hornet-the-best-fighter-jet-for-india) key? How is it different from a candidate key ms-access?

## Answers

### Answer by Hitesh Vohra

- Multiple attributes in a **Super Key** may not be able to independently identify tuples in a table, but when combined with particular keys, they can uniquely identify tuples.
- Super keys can have redundant properties that aren't necessary for tuple identification.
- A **candidate [key](https://answers.mindstick.com/qa/31281/how-to-fix-bad-sector-in-my-windows-10-lappy)** is a single or a collection of keys that uniquely identify rows in a database.
- A Candidate key is a subset of Super keys that is devoid of all non-essential properties for uniquely identifying tuples.
- Super keys are a subset of Candidate keys. They only have the attributes that are required to identify tuples uniquely.
- Super keys are used for all Candidate keys. However, the opposite is not true.

\

**Read More: [How to create a simple query in MS Access?](https://answers.mindstick.com/qa/96617/how-to-create-a-simple-query-in-ms-access)**


---

Original Source: https://answers.mindstick.com/qa/96615/what-is-a-super-key-how-is-it-different-from-a-candidate-key-ms-access

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.