subject

Draw an EER diagram for the following situation: Hamilton Falls is a 55+ lifestyle community of 2,200 units (detached homes, villas, and condominiums) located 15 miles outside Bloomington, Indiana, in a rural, wooded area. All residents live independently; there are no on-site continuous care facilities. Residents choose to live in Hamilton Falls for the proximity to a vibrant college town but also for the close-knit, active, social environment of their community. Because most residents have downsized from former larger homes, storage and garage space is limited, and external maintenance is contracted; thus, residents have generally simplified their lives. This means that many families have only one vehicle and few power and hand tools. They have also minimized their overall possessions (e. g., supplies for entertaining). To meet the needs of the residents, the community association has developed a rather extensive service to share items that residents only occasionally need and don't want to own themselves. In essence, this service, called Hamilton Shares, is similar to a car sharing service, like Zipcar, but is limited to use by only residents of Hamilton Falls. Your assignment is to draw an EER diagram for a database to keep track of the data necessary to maintain Hamilton Shares. To simplify your work, you need to draw only the super-type/subtype hierarchies and all relationships; you do not need to be concerned about data elements, although you can assume that each entity type has attributes different from its peer subtypes. As stated earlier, only residents can rent the shared resources. Both individual residents and approved groups (e. g., the Mahjong Club) can rent items. Of course, over time, an individual resident or club may never have rented any items (e. g., a new resident may take several months before he or she needs one of the community items). There are several types of items, including facilities, vehicles, tools, appliances, and party supplies; other items are not separately categorized. Only groups can rent a facility, but both groups and individuals can rent any of the other items. Hamilton Shares has two types of vehicles: motorized and two-wheel, including motorized bicycles. There are two types of tools: power and hand. There are also two types of appliances: kitchen and entertainment. Vehicles, power tools, and appliances occasionally re-quire repair or maintenance, so the database for Hamilton Shares needs to keep track of which service vendor or vendors to contact when one of these items needs re-pair or maintenance.

ansver
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 18:00, Geo777
Suppose an astronomer discovers a large, spherical-shaped body orbiting the sun. the body is composed mostly of rock, and there are no other bodies sharing its orbit. what is the best way to categorize this body? a. planet b. moon c. comet d. asteroid
Answers: 1
image
Computers and Technology, 22.06.2019 18:30, yeeet26
If an improvement creates no significant change in a product’s performance, then it is a(n) ? a0 design improvement. (there are no answer choices)
Answers: 1
image
Computers and Technology, 22.06.2019 22:50, cheyennecarrillo14
Which is the best minecraft server? a. mineplex b. worldonecraft c. 9b9t d. 2b2t
Answers: 2
image
Computers and Technology, 23.06.2019 10:50, Leffew
The volume v and paper surface area a of a conical paper cup are given by where r is the radius of the base of the cone and h is the height of the cone. a. by eliminating h, obtain the expression for a as a function of r and v. b. create a user-de ned function that accepts r as the only argument and computes a for a given value of v. declare v to be global within the function. c. for v ! 10 in.3 , use the function with the fminbnd function to compute the value of r that minimizes the area a. what is the corresponding value of the height h? investigate the sensitivity of the solution by plotting v versus r. how much can r vary about its optimal value before the area increases 10 percent above its minimum value?
Answers: 1
You know the right answer?
Draw an EER diagram for the following situation: Hamilton Falls is a 55+ lifestyle community of 2,20...

Questions in other subjects:

Konu
Mathematics, 21.08.2019 05:30
Konu
Biology, 21.08.2019 05:30
Konu
Mathematics, 21.08.2019 05:30