You are being asked to design an on-line newspaper system. The system will allow subscribers to read the newspaper, journalists to add articles and managers to retrieve management data, delete articles etc.

The system will need a database backend to store the articles etc.  The database will need to store at least the following information:

·         The articles associated with each edition of the newspaper – note that you don’t have to worry about storing anything sensible here, just copy some text (one paragraph will suffice) from the web on anything (you don’t have to reference where the text came from J)

·         Journalist associated with each article

·         List of user ids, passwords for each subscriber, journalist and manager.

This Web-based application is to be written using Java servlets, JSPs and enterprise java beans which connect to an Access database using JDBC.

The requirements of the system are expressed as a number of levels.  The level that you implement will determine the maximum possible mark that you are eligible to be awarded.

Set up an Access database with a sufficient variety of current and historical information in order fully to demonstrate the functionality you have implemented.

Level 1 (up to a maximum of 50%)

This is to be implemented using either JSP or Java Servlet technology talking to your database. Note: You must use at least one Java Servlet somewhere in your coursework solution, preferably as a front controller.

a)         The first page will be a login page for subscribers, journalists or managers. Passwords for each individual user should be stored in the database and checked on login – if correct, the person is presented with their option screen (for this level, they will all be given access to do the same functionality), if the password is incorrect, a suitable error message will be displayed.

b)         All subscribers, journalists and managers will be able to read articles from a particular edition and;

c)         display a list of articles from any edition that contains a particular key word specified by the user.

Level 2 (up to a maximum of 60%)

This is to be implemented using either JSP or Java Servlet technology talking to your database. Note: You must use at least one Java Servlet somewhere in your coursework solution preferably as a front controller.

a)         The Journalist should be able to submit an article for publication. This should include an article title in addition to the text. The date the article is submitted should automatically be recorded in your database – the Journalist should not have to enter it.

b)         Once submitted, it will be given an approval status. Initially this status will be “Not yet approved”. A manager should be able to browse articles submitted and in the “not yet approved” status and change them to the “accept” status or “reject” status. Once in the “accept” status, the manager should be able to assign the article to a particular edition of the newspaper.

c)         Journalists will be able to edit their own articles as long as they are not in the “accept” status.

Level 3 (up to a maximum of 100%)

This is to be implemented making appropriate use of enterprise java beans to talk to your database.  Note that an implementation without EJBs will not attract any marks.

a)       Provide a facility for the manager to add new subscribers and journalists to the DB and allocate them a user id and password. They should then be able to browse the list of user ids and passwords to check the entry has been made.

b)       Obtain statistics on the journalists e.g. number of journalists, how many articles submitted by each, how many accepted, how many rejected, how many edits made before the article was accepted.

c)       Delete an article.