This question is for DATABASE MANAGEMENT SYSTEM COURSE
An institute facilitates its students to participate in three types of sports events: Long Jump, Discus Throw and 100- Meter race. The following attributes are recorded for each event: Long Jump: Student Roll Number, Name, House, Age, Recorded Jump Discus Throw: Student Roll Number, Name, House, Age, Distance covered 100 m. Race: Student Roll Number, Name, House, Age, Time taken Apply rule of generalization and develop an EER model segment to represent this situation using traditional EER notation, Visio notation or subtype inside supertype notation. Assume that each of this sport event can be a part of exactly one of these subtypes into the following subtypes: Professionals taking up professional courses at the university, Arts and Humanities, Sciences, and Doctoral Student. Depict this situation in the form of an ER diagram, and suggest which completeness constraint applies to the situation and how. Each case handled by the firm has a unique case number; a date opened, date closed, and judgment description are also kept on each case. A case is brought by one or more plaintiffs, and the same plaintiff may be involved in many cases. A plaintiff has a requested judgment characteristic. A case is against one or more defendants, and the same defendant may be involved in many cases. A plaintiff or defendant may be a person or an organization. Over time, the same person or organization may be a defendant or a plaintiff in cases. In either situation, such legal entities are identified by an entity number, and other attributes are name and net worth An institute facilitates its students to participate in three types of sports events: Long Jump, Discus Throw and 100- Meter race. The following attributes are recorded for each event: Long Jump: Student Roll Number, Name, House, Age, Recorded Jump Discus Throw: Student Roll Number, Name, House, Age, Distance covered 100 m. Race: Student Roll Number, Name, House, Age, Time taken Apply rule of generalization and develop an EER model segment to represent this situation using traditional EER notation, Visio notation or subtype inside supertype notation. Assume that each of this sport event can be a part of exactly one of these subtypes into the following subtypes: Professionals taking up professional courses at the university, Arts and Humanities, Sciences, and Doctoral Student. Depict this situation in the form of an ER diagram, and suggest which completeness constraint applies to the situation and how. Each case handled by the firm has a unique case number; a date opened, date closed, and judgment description are also kept on each case. A case is brought by one or more plaintiffs, and the same plaintiff may be involved in many cases. A plaintiff has a requested judgment characteristic. A case is against one or more defendants, and the same defendant may be involved in many cases. A plaintiff or defendant may be a person or an organization. Over time, the same person or organization may be a defendant or a plaintiff in cases. In either situation, such legal entities are identified by an entity number, and other attributes are name and net worth
