ERD DIAGRAM. Specification

The History Project

A local history teacher has had the idea of creating a web site which will allow pupils to

develop materials on history. Whilst she is a good web programmer, designing a sustainable

database for the site has fallen to you. Any history teacher would need to set up a course and

add their students to it$.$ Each student then gets a course code and log in number. On first use,

they are asked to add a password which is then used to log in subsequently. Younger or less

capable classes may be required to tell their teacher their password, but that is up to the

school$\backslash$teacher$.$ Pupils will be asked to add content as part of their history homework. This

would be text or links to other sites only $-$ no images or videos. The content would be tagged

by the learner for specific areas such as people, dates, location, or type of event $($a battle, a

meeting, a birth, etc.$).$ This would allow the database to be searched by any of these tags so

that a more rounded and personalised view of history could be created. Each pupil would be

asked to $log$ in$.$ When they make an entry their ID and course code should be stored

automatically. The teacher could then search for those who have completed the homework

$($i$.$e$.$ by course code$)$ and then add a numerical mark and comments can be added for each

entry. This means that the database would serve as both a teaching aid and as a marking tool.

Reports can then be created for specific pupils to show progress. The learners could generate

the content on the computers in the school at home, depending on circumstances. The teacher

would also be able to work at school or from home.