72 Part I EXAM PREPARATION determining entities and
72 Part I EXAM PREPARATION determining entities and relationships and I advise beginners to use this. I once came across a saying, One trick to discovering relationships between entities is to look closely at the entity definitions. I ve particularly found that many beginners and even professionals use this method and find it extremely effective. Look back at the definitions you wrote for each entity in Step by Step 2.2: Patient. Stores information about the individual patients registered in Lloyd s Hospital to get treatment provided from doctors (EMPLOYEES). Employee. Tracks information, such as salary and contract, about the doctors and workers employed at Lloyd s Hospital who teach COURSES and treat PATIENTS. Medicine. Keeps a statistical list of the medicine available, which EMPLOYEES are allowed to prescribe for their ailing PATIENTS. Machinery. Holds miscellaneous details of the sophisticated machinery and utilities available at Lloyd s, only used by specialized EMPLOYEES. Course. Keeps information concerning the courses available at Lloyd s Hospital, taught to TRAINEES by EMPLOYEES. Trainee: Keeps track of the students learning the different COURSES available from Lloyd s EMPLOYEES. From the preceding descriptions, you can construct a blueprint of an ER diagram after you summarize the information. A PATIENT is one who needs treatment from a doctor (EMPLOYEE). An EMPLOYEE helps a PATIENT with his/her expertise and can prescribe MEDICINE if needed. MEDICINE is used to aid PATIENTS and is prescribed by EMPLOYEES. MACHINERY helps EMPLOYEES in treating their PATIENTS. EMPLOYEES teach COURSES to TRAINEES. TRAINEES are those participating in the COURSES provided by Lloyd s Hospital. Now you can construct a general overview of what your model is
For high quality jboss hosting services please check jboss web hosting website.