Homework Assignment #2 03/04/13 Please get your defense subjoined each bearing and resign the improve after a while your defenses through Angel. Bearing #8 from page 145 Using the Crow’s Foot methodology, construct an ERD that can be implemented for a medical clinic, using at last the subjoined transaction rules: a. A resigned can construct sundry ordinances after a while one or further teachers in the clinic, and a teacher can confirm ordinances after a while sundry resigneds. However, each ordinance is made after a while solely one teacher and one resigned. b. Strait cases do not insist-upon an ordinance.
However, for ordinance superintendence purposes, an strait is entered in the ordinance quantity as “unscheduled. ” c. If kept, an ordinance yields a scrutinize after a while the teacher limited in the ordinance. The scrutinize yields a individuality and, when divert, matter. d. After a while each scrutinize, the resigned’s records are updated to get a medical fact e. Each resigned scrutinize constructs a mandible. Each resigned scrutinize is mandibleed by one teacher, and each teacher can mandible sundry resigneds. f. Each mandible must be hired. However, a mandible may be hired in sundry installments, and a reimbursement may shield further than one mandible. . A resigned may pay the mandible instantly, or the mandible may be the plea for a demand resignted to an prophylactic union. h. If the mandible is hired by an prophylactic union, the deductible is resignted to the resigned for reimbursement. [pic] Bearing #2 from page 173 Given the subjoined transaction scenario, construct a Crow’s Foot ERD using a specialization hierarchy if divert. Tiny Hospital keeps advice on resigneds and hospital admissions. The classification assigns each resigned a resigned ID compute. In attention, the resigned’s call and bound of nativity are recitative.
Some resigneds are dweller resigneds (they disburse at last one death in the hospital) and others are outpatients (they are treated and released). Dweller resigneds are assigned to a admission. Each admission is identified by a admission compute. The classification as-well stores the admission symbol (peculiar or semiprivate), and admission fee. Over space, each admission succeed own sundry resigneds that arrive in it. Each dweller resigned succeed arrive in solely one admission. Integral admission must own had a resigned, and integral dweller resigned must own a admission. I prize specialization hierarchy is 100 percent not divert.
Although dweller resigneds are an identi? serviceserviceable symbol of resigned entreaty, there are not attentional attributes that are matchless to solely that skin or symbol of resigned. Competition in a conformity that is matchless to a feature skin or symbol of entreaty is not suf? cient justi? cation for a specialization hierarchy. Indicating that solely some entreatys succeed join-in in a conformity is addressed by the optional competition authority. In this module, all dweller resigneds must own a admission; eventually, not all resigneds are dweller resigneds so admission is optional to resigned.