Hello, would you please help me with these questions? Together-While-Still Apart
ID: 3784570 • Letter: H
Question
Hello, would you please help me with these questions?
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 only (i.e. "Discover, Don't Invent") A yes/no 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 C or 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) Can new furniture be recorded as soon as it is purchased? How do you know?
(b) What part of the model is redundant?
How would you change the model to eliminate the redundancy? Why won't users lose information if you make
this change?
(c) Under what conditions will an apartment be deleted from the database? How do you know?
(d) Suggest 3 good potential identifiers (candidate keys) for the Rental Contract entity. (3 different alternatives, not one concatenation.)
(e) Can TWSA use this database to track prospective new renters or former renters who might rent from them again? How do you know?
(f) As the model is presented here, what information must always be available for any rental contract in the database? (3 things)
(g) The office manager has suggested adding a “used-by” relationship between Furniture and the Renter. What is your reply to this suggestion? Why?
(h) 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.
(i) If 4 college students share a 2-bedroom apartment, how many rental contract instances will the roommates have to sign?
(j) 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.
Renter C D Rental Contract rented-by LEvr F CD Furniture rental-of Apartment PLN owned-by in-use-at a Building N L L Owner S T U V Q R W XExplanation / Answer
56% of leaseholders say that really moving their stuff out was the hardest part to manage. Leaseholders concurred that separating up stuff was route harder than isolating up monetary duties. Leaseholders were well on the way to live respectively post-split since they couldn't discover somewhere else they could bear (33%). Also, of these, ladies (34%) will probably remain in the condo than men (30%). 25% of tenants remained roomies in light of the fact that, umm, why should* I* be the person who needs to move out? Yes, truly. More established leaseholders (45+) have a harder time finding a moderate place to live than more youthful tenants (18-24). (My figure: The kiddos don't feel as awful about smashing with companions or the 'rents.) 45% of tenants 25-34 concurred that, later on, they'd spare more cash as a safety measure before moving in with a critical other once more, 21% of all leaseholders say they'd put the condo in their name, and 17% said they'd investigate getting a prenuptial leasing assention. Furthermore, 27% of all leaseholders say that the entire moving-in, separating, and moving-out thing put SUCH a terrible taste in their mouth that they'd never live with any other person again. (Aw :() During the separation, 61% of those overviewed said loved ones were the greatest comfort, yet 16% said a decent solid drink did the trap (ha!).
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.