Sample: Create a Database AssignmentIllinois has just passed a mandatory continuing education requirement for registered nurses. As the head of the nursing education department, I am interested in establishing a database for nurses employed at our institution related to their participation in continuing education.We offer numerous programs in the traditional classroom mode at the University. We also have recently started to offer courses via our University Intranet. Nurses also take courses outside the University.Field Name Source of DataEmployee ID Human ResourcesFirst Name Human ResourcesMiddle Initial Human ResourcesLast Name Human ResourcesDate of Hire Human ResourcesNursing License Number Nursing OfficeDepartment (s) Employed Nursing OfficeCertification NumberUniversity Classroom Nursing EducationCertification DateUniversity Classroom Nursing EducationCEU’sUniversity Classroom Nursing EducationCertification NumberUniversity Intranet Automatic from IntranetCertification DateUniversity Intranet Automatic from IntranetCEU’sUniversity Intranet Automatic from IntranetCertification SourceOther New entryCertification NumberOther New entryCertification DateOther New entryCEU’sOther New entryNote: In the future, it might be possible to merge the University Classroom, University Intranet, and Other into one field each for the field names of certification numbers, dates, and CEU’s .For classroom sessions, nurses would register on-line and receive their certificates on-line. This data would automatically be entered into the data base. Then the nursing education department would only have to manually enter the outside programs. If this was the case, and the department was interested in whether or not the program was classroom, Intranet, or other, a new field could be created.
Geriatrics Officers RecordsThe following database embodies records of geriatrics officers across nursing homes in Illinois. The officers are certified and spread across the various elderly care institution. Meanwhile during their operations they will be switched within one care home to the next to allow for sharing of new ideas and avoid monotony to the occupants. This will also minimize molestation cases.Additionally the geriatrics officers have a chance to take extra classes in the course of their duty by a model courses outside the University. This can be done part timeField Name Source of DataEmployee ID Human ResourcesFirst Name Human ResourcesLast Name Human ResourcesDate of Hire Human ResourcesLicense Number Geriatrics OfficeDepartment (s) Geriatrics OfficeNumber of CertificationUniversity Classroom Geriatrics EducationDate of CertificationUniversity Classroom Geriatrics EducationCEU’sUniversity Classroom Geriatrics EducationCertification NumberUniversity local database Automatic from IntranetCertification DateUniversity local database Automatic from IntranetCEU’sUniversity local database Automatic from IntranetCertification SourceOther New entryCertification NumberOther New entryCertification DateOther New entryCEU’sOther New entryTo enable classroom part time sessions, the officers would perform all operations online until they receive their certification as everything will be stored in the database. Also, in future the system will be able to the various aspects in the database eg the University Classroom, University Intranet, and Other into one field each for the field names of certification numbers, dates, and CEU’s.
Order Now For this paper or similar assignments, Trust us today & live to tell a success tale of best grades & plagiarsim free work!!
Let’s block ads! (Why?)