Back to the Data Model
A database to hold information on local musicians that has been printed in the local newspaper (ie the Warrnambool Standard).
B. Things of Interest :-
C. How are they related ?
C.1 An Article has one or many Reporters.
C.2 A Musician can appear in zero, one or many Articles.
D. Example of queries are:-
D.1 What Warrnambool Standard articles do you you have on (name of musician - eg John Smith)?
D.2 What are the most recent articles on music published in the Warrnambool Standard?
D.3 What music related articles do you have written by (name of reporter eg Jane Smith).
D.4 There is a need to be able to obtain a print out of an article on (name of musician) that was in the
newspaper on (date).
D.5 Search all the Newspaper articles that mention (name or word)?
4th. May 2003