1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
bonufazy [111]
2 years ago
10

Consider the following schema for customer: (id, name, street, city, state, zip, phone), in which customers are uniquely determi

ned by their name and phone or by their id. How many super keys are there for this relation? Justify your answer.
Computers and Technology
1 answer:
Art [367]2 years ago
8 0

Answer:

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

You might be interested in
What programs provide email communication
Greeley [361]
One program would be Outlook. There is also Incredimail 
5 0
3 years ago
Read 2 more answers
Output values below an amount
valina [46]

Answer:

Explanation:

The following code is written in Python and it is a function called filter, which takes in the requested inputs. It then places the threshold in its own variable and pops it out of the array of inputs. Then it loops through the array comparing each element with the threshold and printing out all of the ones that are less than or equal to the threshold.

def filter():

   num_of_elements = input("Enter a number: ")

   count = 0

   arr_of_nums = []

   while count <= int(num_of_elements):

       arr_of_nums.append(input("Enter a number: "))

       count += 1

   threshold = arr_of_nums[-1]

   arr_of_nums.pop(-1)

   print(threshold)

   for element in arr_of_nums:

       if int(element) < int(threshold):

           print(element)

       else:

           continue

7 0
2 years ago
Who created internet ​
vlada-n [284]

Answer:

robert e kahn, vint cerf

Explanation:

8 0
3 years ago
Brainly keeps logging me out of my account when I'm on the sign in screen. I put in my email and password and click "log in" and
VLD [36.1K]
Reinstall the app....
3 0
3 years ago
If you have a floating layer in your project you will be unable to​
vlabodo [156]

Answer:

You will not be able to execute the file

Explanation:

A floating layer is a type on a layer or temporary layer which is similar in function to a normal layer. The floating layer is also known as the floating section. When working on a computer, this often appears as a warning with a diamond in yellow. This is followed by a command explaining why the program cannot be executed unless the layer is removed.

7 0
3 years ago
Other questions:
  • How can we set the color of a text that acts as a link in a web page​
    10·2 answers
  • Mary is proofreading an eBook. Sometimes she has to scroll several pages at a time. Which key on the numeric keypad will help he
    11·2 answers
  • You receive a phone call from a co-worker telling you that "the network is down." Just as you are about to look into the issue,
    11·1 answer
  • Which process refers to starting up a computer?
    9·2 answers
  • Computer software licensed under exclusive legal right of the copyright holder with the intent that the licensee is given the ri
    6·1 answer
  • Count positive and negative number and compute the average. The program will have the user input an unspecified number of intege
    6·1 answer
  • Which app or website teaches java and phyton
    15·1 answer
  • When looking at a program board at the end of program increment (PI) planning, what does it mean when a feature is placed in a t
    9·1 answer
  • 2) List three (3) negative impact of Technology on society
    14·1 answer
  • The term used to describe whereby old and new media are available via the integration of personal computers and high speed satel
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!