You are tasked to design an extended ER diagram to capture t…
You are tasked to design an extended ER diagram to capture the attributes of three different types of nurses: NurseAssistant, RegisteredNurse, NursePractitioner. All of the nurses have the basic information as in the Nurse entity. A NurseAssistant will have state certification. A NursePractitioner will have the undergraduate degree. A RegisteredNurse will have graduate degrees that need to be recorded in addition to the speciality. A nurse must be one of the three types of nurses mentioned above. You are given the text notation of the Nurse entity as the supertype. Use text notation to capture all other subtypes. Also explain which of the following symbol(s) is(are) used. Symbols: double lines, single lines, o, d. Nurse(NID, FName, LName, DOB)
Read Details