I need a database for inputting and tracking distribution of posters.
It needs the following elements:
•List of display sites – Site name and address and ability to add/erase sites as and when needed.
•Ability to separate sites into areas and to be able to name each area
•Total number of poster sites in each display site – this varies from minimum of 1 to maximum of 30
•Ability to input a specific poster (new job/media) and allocate where these posters will be displayed
. Ability to input clients info
•Ability to show when sites have reached maximum poster limits
•Ability to designate period of time for poster display
•Ability to print out list of display sites by area/job/media/date and show which posters are allocated where and for how long
More elements to be added once basic database is designed.