Database Answers The 18th. Hole at Pebble Beach, California.

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Musicians in Newspapers
Back to the Data Model
Requirements :-
A database to hold information on local musicians that has been printed in the local newspaper (ie the Warrnambool Standard). 

B. Things of Interest :-
B.1 Articles
B.2 Musicians
B.3 Reporters

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)? 


Barry Williams
4th. May 2003
Principal Consultant
Database Answers

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map