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

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 03:30
Some of your friends have gotten into the burgeoning field of time-series data mining, in which one looks for patterns in sequences of events that occur over time. purchases at stock exchanges--what’s being bought-- are one source of data with a natural ordering in time. given a long sequence s of such events, your friends want an efficient way to detect certain "patterns" in them--for example, they may want to know if the four events buy yahoo, buy ebay, buy yahoo, buy oracle occur in this sequence s, in order but not necessarily consecutively. they begin with a collection of possible events (e.g., the possible’ transactions) and a sequence s of n of these events. a given event may occur multiple times in s (e.g., yahoo stock may be bought many times in a single sequence s). we will say that a sequence s’ is a subsequence of s if there is a way to delete certain of the events from s so that the remaining events, in order, are equal to the sequence s’. so, for example, the sequence of four events above is a subsequence of the sequence buy amazon, buy yahoo, buy ebay, buy yahoo, buy yahoo, buy oracle their goal is to be able to dream up short sequences and quickly detect whether they are subsequences of s. so this is the problem they pose to you: give an algorithm that takes two sequences of even~s--s’ of length m and s of length n, each possibly containing an event more than once--and decides in time o(m n) whether s’ is a subsequence of s
Answers: 2
question
Computers and Technology, 22.06.2019 08:30
Today is the anniversary of me being on yet, i don't need it anymore! here's a picture of my dog wearing a bowtie! my question is, how do i delete my account?
Answers: 1
question
Computers and Technology, 22.06.2019 09:00
Howard is designing a chair swing ride. the swing ropes are 5 meters long, and in full swing they tilt in an angle of 29° outside chairs to be 2.75 m above the ground in full swing.
Answers: 1
question
Computers and Technology, 23.06.2019 12:00
3. when you right-click a linked spreadsheet object, what commands do you choose to activate the excel features? a. linked worksheet object > edit b. edit data > edit data c. linked spreadsheet > edit d. object > edit data
Answers: 2
You know the right answer?
Draw an EER diagram for the following situation: Hamilton Falls is a 55+ lifestyle community of 2,20...
Questions
question
Mathematics, 03.12.2020 20:40
question
Mathematics, 03.12.2020 20:40
question
English, 03.12.2020 20:40
question
Business, 03.12.2020 20:40
question
Mathematics, 03.12.2020 20:40
question
Mathematics, 03.12.2020 20:40
question
Mathematics, 03.12.2020 20:40
question
Mathematics, 03.12.2020 20:40
Questions on the website: 13722367