I need a simple website to view collected and classified news in my database. The database (ERD and data dictionary is attached and sample database dump will be provided later) contains few tables that organise the news with tags and categories.
All required work will be just viewing the data from different angels. No registration , login or editing. It is simple and very straight forward.
It will be hosted on a Linux server with MySQL database management server , so that must be considered in any prerequisites and also, database connection parameters must be external. Also Installation instructions should be provided with deliverables.
Following is a short description for the webpages 1- Landing Page: A list of the News title, source, datetime, description, tags, and categories as a single card for each news record. A list of the most recent 20 records are shown with next/previous (Paging). The title is a hyperlink to the news article link in its original source to open in a new tab/window. 2- Filter by Categories: select one or more categories /sub categories from taxonomy (xml file will be shown as a tree) 3- Filter by Source: select one or more sources from a list of sources (list checkbox) 4- Filter by Tag: List of tags