An App (Application) is a computer program designed to support a specific task?

Define the terms candidate key and primary key. Explain the difference between a primary key and a candidate key.

Shkiper50 [21]

Explanation:

Both Primary Key and Candidate Key are the attributes that are used to access tuples from a table. These (Primary key and Candidate key) are also can be used to create a relationship between two tables.

A Candidate Key can be any column or a combination of columns that can qualify as a unique key in the database. Each Candidate Key can qualify as a Primary Key.
A Primary Key is a column or a combination of columns that uniquely identify a record. The primary key is a minimal super key, so there is one and only one primary key in any relationship.

The main difference between them is that a primary key is unique but there can be many candidate keys.

I hope you find this information useful and interesting! Good luck!

5 0

4 years ago

Write a program with the total change amount as an integer input, and output the change using the fewest coins, one coin type pe

riadik2000 [5.3K]

Answer:

In Python:

cents = int(input("Cents: "))

dollars = int(cents/100)

quarters = int((cents - 100*dollars)/25)

dimes = int((cents - 100*dollars- 25*quarters)/10)

nickels = int((cents - 100*dollars- 25*quarters-10*dimes)/5)

pennies = cents - 100*dollars- 25*quarters-10*dimes-5*nickels

if not(dollars == 0):

if dollars > 1:

print(str(dollars)+" dollars")

else:

print(str(dollars)+" dollar")

if not(quarters == 0):

if quarters > 1:

print(str(quarters)+" quarters")

else:

print(str(quarters)+" quarter")

if not(dimes == 0):

if dimes > 1:

print(str(dimes)+" dimes")

else:

print(str(dimes)+" dime")

if not(nickels == 0):

if nickels > 1:

print(str(nickels)+" nickels")

else:

print(str(nickels)+" nickel")

if not(pennies == 0):

if pennies > 1:

print(str(pennies)+" pennies")

else:

print(str(pennies)+" penny")

Explanation:

A prompt to input amount in cents

cents = int(input("Cents: "))

Convert cents to dollars

dollars = int(cents/100)

Convert the remaining cents to quarters

quarters = int((cents - 100*dollars)/25)

Convert the remaining cents to dimes

dimes = int((cents - 100*dollars- 25*quarters)/10)

Convert the remaining cents to nickels

nickels = int((cents - 100*dollars- 25*quarters-10*dimes)/5)

Convert the remaining cents to pennies

pennies = cents - 100*dollars- 25*quarters-10*dimes-5*nickels

This checks if dollars is not 0

if not(dollars == 0):

If greater than 1, it prints dollars (plural)

if dollars > 1:

print(str(dollars)+" dollars")

Otherwise, prints dollar (singular)

else:

print(str(dollars)+" dollar")

This checks if quarters is not 0

if not(quarters == 0):

If greater than 1, it prints quarters (plural)

if quarters > 1:

print(str(quarters)+" quarters")

Otherwise, prints quarter (singular)

else:

print(str(quarters)+" quarter")

This checks if dimes is not 0

if not(dimes == 0):

If greater than 1, it prints dimes (plural)

if dimes > 1:

print(str(dimes)+" dimes")

Otherwise, prints dime (singular)

else:

print(str(dimes)+" dime")

This checks if nickels is not 0

if not(nickels == 0):

If greater than 1, it prints nickels (plural)

if nickels > 1:

print(str(nickels)+" nickels")

Otherwise, prints nickel (singular)

else:

print(str(nickels)+" nickel")

This checks if pennies is not 0

if not(pennies == 0):

If greater than 1, it prints pennies (plural)

if pennies > 1:

print(str(pennies)+" pennies")

Otherwise, prints penny (singular)

else:

print(str(pennies)+" penny")

4 0

3 years ago

Alice has an item x and Bob has a set of five distinct items y1, y2, y3, y4 and y5. Design a protocol through which Alice (but n

lukranit [14]

I guess it will be 4 yards each hopes it will help u :)

4 0

2 years ago

The good example of pivoting is changing thedimensions along the axis.? True? False

ollegr [7]

Answer:

False

Explanation:

The good example of pivoting is NOT changing the dimensions along the axis.

5 0

3 years ago

My rank hasn't changed even though i've passed the point mark and i even tried to relogin but it still didn't change.

tatyana61 [14]

You need to wait, it isn't the website that ranks you, but actual people on the site. Just wait, have patience.

5 0

3 years ago

Read 2 more answers