Nursing database..need IT Expert..$10 very urgent...6hours

Sample: Create a Database Assignment

Illinois 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 Data
Employee ID	Human Resources
First Name	Human Resources
Middle Initial	Human Resources
Last Name	Human Resources
Date of Hire	Human Resources
Nursing License Number	Nursing Office
Department (s) Employed	Nursing Office
Certification Number University Classroom	Nursing Education
Certification Date University Classroom	Nursing Education
CEU’s University Classroom	Nursing Education
Certification Number University Intranet	Automatic from Intranet
Certification Date University Intranet	Automatic from Intranet
CEU’s University Intranet	Automatic from Intranet
Certification Source Other	New entry
Certification Number Other	New entry
Certification Date Other	New entry
CEU’s Other	New entry

Note: 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.