a) Suggest 3 good potential identifiers (candidate keys) for the Rental Contract entity. (3 different alternatives, not one concatenation.)

b) Can TWSA use this database to track prospective new renters or former renters who might rent from them again? How do you know?

c) As the model is presented here, what information must always be available for any rental contract in the database? (3 things)

d) The office manager has suggested adding a used-by relationship between Furniture and the Renter. What is your reply to this suggestion? Why?

e) What happens if the person who is the owner of a building rents (leases for his or her own use) an apartment in that building? Explain the effect on the database.

f) If 4 college students share a 2-bedroom apartment, how many rental contract instances will the roommates have to sign?

g) One feature of this model will never be used because it exceeds a physical limitation of the real world. Identify the item and describe the physical limit.

Together-While-Still Apartments Inc. (TWSA) manages the rental of furnished apartments and lofts using a database whose Logical Data Model is shown here. Answer the questions below based this model onl e. "Discover, Don't Invent") A yeso answer is not sufficient. You must cite what specific part of the data model provides the answer. The connectivity symbols are labeled with letters to make it easy to give short, specific, complete answers. A letter (such as Cor R) is sufficient to identify a minimum or maximum symbol in your answer. Do not over-answer if H alone is the right answer, do not say "G and H" or "E,F,G,H" (both wrong). A B c D rental of Renter e- Renta Apartment Contract rented-by AN owned-by Furniture N n-use-at Building Owner S T U V Q R. W X