74 Part I EXAM PREPARATION FIGURE 2.4 A
74 Part I EXAM PREPARATION FIGURE 2.4 A many-to-many relationship. FIGURE 2.5 Sample data after a many-to-many resolution. Traine. TraineeCours. Course Traine. I. Traine. I. . F. Cours. I. Firs. Nam. Cours. I. . F. Name Las. Nam. Location Stree. Addres. Cost Cit. Availabl. Stat. Zi. Cod. Gende. Dat. Registere. Dat. o. Birt. SS. Nam. o. Cours. Paymen. Du. resolving many-to-many relationships is shown in Figure 2.4. To help you better understand many-to-many relationships, the Course, Trainee, and Description entities along with sample data are shown in Figure 2.5. One other many-to-many relationship also exists in the scenario. There is likely to be a many-to-many relationship between Employee and Machine, which is explored in the next section. Setting up the relationships finalizes a draft of the ER model. This draft will undergo modifications as the database approaches a physical design. The next topic to discuss is potential alteration to the TraineesTraineeIDFirstNameLastNameZipCodeCityStateAddressDuePayment 1101JohnJones74832BurfordCA278MillStreet200.0000 2207SueSmith73638DelhiCA837PhelanStreet300.0000 3473BillBrown73833EmbroCA62DundasStreet400.0000 4673JoeSamson73345DurhamCA9304FerdaleAvenue200.0000 5983SallyHillery78390WilsonCA9CenterDrive100.0000 CoursesCourseIDNumberNameCostAvailable 11A2378BedBaths1001 21B6392Sterilization1001 31C7296IntroductoryMeds1001 41D1739AdvancedMeds1001 52A1736CardioTherapy1001 62B8363ICUCare1001 72C8923EmergencyCare1001 82D7436PostOperativeCare1001 93A7322PostNatal1001 103B4280DoctorAssisting1001 113C8370DietaryCare1500 123D1298MedicalTraining1500 134A7922IVTherapyI2000 144B2492IVTherapyII2000 154C0982IVTherapyIII2500 164D3487IVTherapyIV2500 TraineeIDCourseID 11013A 21013B 32072D 42073A 52073B 64732A 74732B 84732C 94732D 106732C 116732D 129831A
For reliable and cheap web hosting services please check cheap web hosting website.