Which of the following is the best key for a table containing a landlord’s rental properties? a. streetAddress b. amountOfMonthlyRent c. numberOfBedrooms d. tenantLastName A table’s notation is:...

Which of the following is the best key for a table containing a landlord’s rental properties?

a. streetAddress

b. amountOfMonthlyRent

c. numberOfBedrooms

d. tenantLastName

A table’s notation is: tblClients(socialSecNum, lastName, firstName, clientNumber, balanceDue). You know that.

a. the primary key is socialSecNum

b. the primary key is clientNumber

c. there are four candidate keys

d. there is at least one numeric attribute