Homework Assignment #2 03/04/13 Please afford your counter-argument forthcoming each height and comply the finish delay your counter-arguments through Angel. Height #8 from page 145 Using the Crow’s Foot methodology, produce an ERD that can be implemented for a medical clinic, using at meanest the forthcoming matter rules: a. A enduring can produce divers enactments delay one or further schoolmans in the clinic, and a schoolman can confirm enactments delay divers endurings. However, each enactment is made delay barely one schoolman and one enduring. b. Conjunction cases do not exact an enactment.
However, for enactment superintendence purposes, an conjunction is entered in the enactment magnitude as “unscheduled. ” c. If kept, an enactment yields a investigate delay the schoolman precise in the enactment. The investigate yields a speciality and, when misapply, tenor. d. Delay each investigate, the enduring’s memorials are updated to afford a medical fact e. Each enduring investigate produces a beak. Each enduring investigate is beaked by one schoolman, and each schoolman can beak divers endurings. f. Each beak must be compensated. However, a beak may be compensated in divers installments, and a cancelment may shelter further than one beak. . A enduring may pay the beak straightway, or the beak may be the plea for a assertion complyted to an prophylactic sodality. h. If the beak is compensated by an prophylactic sodality, the deductible is complyted to the enduring for cancelment. [pic] Height #2 from page 173 Given the forthcoming matter scenario, produce a Crow’s Foot ERD using a specialization hierarchy if misapply. Tiny Hospital keeps instruction on endurings and hospital compasss. The scheme assigns each enduring a enduring ID sum. In conjunction, the enduring’s designate and duration of parentage are commemorative.
Some endurings are occupant endurings (they disburse at meanest one ignorance in the hospital) and others are outpatients (they are treated and released). Occupant endurings are assigned to a compass. Each compass is verified by a compass sum. The scheme to-boot stores the compass model (secret or semiprivate), and compass fee. Over term, each compass allure accept divers endurings that alight in it. Each occupant enduring allure alight in barely one compass. Perfect compass must accept had a enduring, and perfect occupant enduring must accept a compass. I regard specialization hierarchy is 100 percent not misapply.
Although occupant endurings are an identi? effectual model of enduring entreaty, there are not conjunctional attributes that are matchless to barely that husk or model of enduring. Partnership in a interdependence that is matchless to a feature husk or model of entreaty is not suf? cient justi? cation for a specialization hierarchy. Indicating that barely some entreatys allure share in a interdependence is addressed by the optional partnership reputation. In this module, all occupant endurings must accept a compass; so-far, not all endurings are occupant endurings so compass is optional to enduring.