Ask Question

Consider the following schema for customer: (id, name, street, city, state, zip, phone), in which customers are uniquely determined by their name and phone or by their id. How many super keys are there for this relation? Justify your answer.

+5
Answers (1)
  1. 11 November, 02:38
    0
    Super key is a set of attributes that uniquely identifies all attributes in a relation. Super keys are more than candidate key.

    Explanation:

    For example in the given schema where

    Customer: (id, name, street, city, state, zip, phone)

    We have a relation we check super keys by following dependencies

    Functional Dependencies Super Key

    id YES

    name YES

    id, name - > street, city, state, zip, phone YES

    id, street - >name, city, state, zip, phone YES

    id, city - >name, street, state, zip, phone YES

    id, state - >name, street, city, zip, phone YES

    id, phone - >name, street, state, zip, city YES

    id, name, street YES

    id, name, street, city YES

    id, name, street, city, state YES

    id, name, street, city, state, zip, phone YES

    All these are uniquely identified

    All these are super key but in reverse they are not super key such as

    street, city, state, zip, phone->id, name No
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Consider the following schema for customer: (id, name, street, city, state, zip, phone), in which customers are uniquely determined by ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers