During further discussions you discover the following. A concert season schedules one or more concerts. A particular concert is scheduled for only one concert season. A concert includes the performance of one or more compositions. A composition may be performed at one or more concerts or may not be performed. For each concert there is one conductor. A conductor may conduct any number of concerts or may not conduct any concerts. Each composition may require one or more soloists or may not require a soloist. A soloist may perform one or more compositions at a given concert or may not perform NY composition.
The symphony orchestra wishes to record the date when a soloist last performed a given composition (Date_Last_Performed). Draw an RED to represent what you have discovered. Identify a business rule in this description and explain how this business rule is modeled on the ERE diagram. Answer) Question 2: A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account. CHECKING: Act. No, Date opened, Balance, Service Charge SAVINGS: Act. No, Date opened, Balance, Interest rate LOAN: Act. No, Date opened, Balance, Interest rate, Payment.
Assume that each bank account must be a member of exactly one of these subtypes. Using generalization, develop and ERE segment to represent this situation using traditional notation Ana VISION notation. Answer) Traditional ERE Notation Vision Notation Question 3: Part I For each of the following relations, determine the normal form for that relation giving your reasoning for such determination. If the relation is not in third normal form (INFO), decompose it into INFO relations. Functional dependencies (other those implied by the primary key) are shown where appropriate. A. CLASS (Course_No, Section_No)
