Database Concepts (7th Edition)
Database Concepts (7th Edition)
7th Edition
ISBN: 9780133544626
Author: David M. Kroenke, David J. Auer
Publisher: PEARSON
Expert Solution & Answer
Book Icon
Chapter 2, Problem 2.12RQ

Explanation of Solution

Unique Composite key:

  • If a primary key consists of more than one attribute to uniquely identify a row or column in a relational database, then it is referred as unique composite key.
  • The other name of composite key is compound key or concatenated key.

Example of unique composite key:

The example for unique composite key of Employee relation is given below:

  • The combination of the “name” and “Address” attributes in Employee relation are composite keys...

Blurred answer
Students have asked these similar questions
Give two examples of a relation and their candidate key
Give an example of a relation with a unique composite key
Discuss the differences between the candidate keys and the primary key of a relation.
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning