Photo Library Database System

  • Posted
  • Proposals 9
  • Remote
  • #1481
  • Expired
Steve A.Shashikant K.Sanjay C.Barrie B.Ajmal T. + 4 others have already sent a proposal.
  • 0


Experience Level: Expert
? Produce a conceptual design of a database which allows photographs to be catalogued and retrieved by place, person and time;
? Produce a logical design using a relational database;
? Produce a physical design for the database;
? implement the database and populated it with a small amount of data;
? Produce SQL queries that demonstrate that references to photographs can be retrieved from exact matches;
? Design and implement a complete system which will retrieve on direct matches with no generalisation.

Interface design

%u2022 Produce a design for the user interface; using simple storyboard and finite state machine techniques.
%u2022 Check interface design; using scenarios.
%u2022 Implement the screens.
%u2022 Provide the functionality
%u2022 Begin by providing the ability to retrieve data. Concentrating on retrieving exact match.
%u2022 Provide some generalisation (e.g. ensuring that photographs of the Eiffel Tower are included in photographs of Paris).
%u2022 Provide the remaining functionality in an incremental manner.

The system should also be able to locate a number of suitable photographs which meet the library-user%u2019s requirements. The library-user will enter a description of the photograph they want in terms of its where the picture is taken, when it was taken and who is in it.

For example: - a student might want a photograph of David Beckham (who) beside the Eiffel Tower (where). The system will display a reference to the physical locations (stack number, shelf number, and box number) of 6 photographs which meet the requirements. Obviously if there are fewer than 6 photographs meeting the requirements it will display the locations those it has. If none of the 6 is found to be acceptable then a further 6 can be displayed until the list is exhausted or the user abandons the search.

Note that if the user requests a picture of a football player in Paris, then references to photographs of David Beckham beside the Eiffel Tower should be returned.

The actual photographs will be handled by the museum%u2019s curators, and so while the library users might use the system to enter their own search criteria, the data returned (i.e. the list of appropriate photographs) is for use by the curators. Initially the search criteria will be limited to Setting (the place, a building, geographical feature, etc. show in the photograph), Subject (the person or people etc. in the photograph), and the Time (this might be a particular date and time, or might be a general range such as the nineteen twenties).

The curators will use the system in 3 roles:

%u2022 Cataloguing: this enables the curators to enter the details of each photograph into the system. The accession number of the photograph (a unique identifying key) must be read by the curator; the photographer if known; the time at which the photograph was taken (this might be precisely known, if is not then the curators have the skills to estimate), the upper and lower bounds of when the photograph might have been taken; and the people in the photograph (these might be know by name or only by role for example a chimney-sweep or a group of mill-workers.) From time to time more is found out about a photograph and so it must be possible to change details.

%u2022 Selecting: the curator or user may search for photographs by giving values for one or more of the given search criteria. The system should return a count of the number of matches, allowing the user/curator to refine the search criteria. When the user/curator is satisfied a list showing the storage locations of (up to) the first 6 photographs is displayed, the next 6 can be displayed on request and so on.

%u2022 Generalising: In order for specific photographs to be returned for general queries it is necessary for the system to be aware of generalisations and classifications such as %u2018the Eiffel Tower is in Paris%u2019 or %u2018David Beckham is a football player%u2019. Note that if the system is aware that %u2018the Eiffel Tower is in Paris%u2019

Clarification Board

    There are no clarification messages.