What information is stored
Each recording has standard information such as recording label or year of release but with the different forms having their own distinct attributes. These are all summarised in the table below.
| Standard | Non-Classical | Classical |
|---|---|---|
| Recording Title | Recording Artist | Composer |
| Recording Label | Genre | Conductor |
| Year of Release | Orchestra | |
| Recording Medium | Choir | |
| Collection | Choir Master | |
| Music Period* | ||
| Category |
* Music period is actually associated with the composer.
Search Facility
The Search facility offers a number of different criterion by which the database can be searched. Any combination of these criterion may be used in the search.
The criteria available for the search are:
- Non-Classical
- Recording Artist
- Recording Title 1
- Genre
- Recording Label
- Collection 2
- Classical
- Composer
- Work Title 1
- Period
- Classical Artist
- Conductor
- Orchestra
- Choir Master
- Choir
Note 1
Any text that is contained in the title may be used,
the only requirement is that at least two letters must be entered.
Note 2
A Collection is a set of closely related albums issued by a recording label or other organisation (e.g. The BBC)
Simply select a value from the dropdown lists or in the case of the Recording Title enter some text that the title contains and click the <Search> button. The results of the search are displayed with a heading showing what the search criteria was. The results are displayed in 'Recording Artist' and 'Year of Release' order for non-classical recordings and in 'Composer', 'Work Title', 'Orchestra' and 'Conductor' order for classical recordings.
Recordings
The adding of recordings is a simple process but with classical recording, because of the way that information is recorded, it is slightly more complicated.
Non-Classical Recordings
To manage non-classical recording select the Recordings->Non-Classical->Add/View/Edit menu option. An empty form is displayed.
To add or view a recording for an existing artist select a recording artist from the dropdown list. A list of all recordings catalogued for this artist is displayed in the right hand panel.
If the artist does not exist, simply click the <Add Artist> button. This takes you to the appropriate maintenance form (see maintenance section below) where a new artist can be added.
To add a new recording, having selected a recording artist, simply enter the recording title and select the required values from the other dropdown lists. All mandatory fields are indicated by a red asterisk ( *). Click <Save> and the recording will be added to the database and included in the right hand display.
As with recording artist, if the value you want is not present in a dropdown list, click on the <Add ...> button and you will be taken to a maintenance form where a new value may be added.
To view a recording, select it from the right hand pane and its details will populate the form. Make any changes and click the <Save> button to save these changes. To delete a recording, having selected it from the right hand pane, click the <Delete> button.
The <Clear> button clears the form of any values.
Classical Recordings
To be completed
Maintenance
Apart from the recording titles, every piece of information pertaining to a recording is available in a dropdown list. These lists can be managed by a series of maintenance screens. They are split into three sections, 'Classical, 'Non-Classical' and 'Standard' for those attributes which relate to both forms of recording.
When a particular attribute is selected from the main menu, a form is displayed with a list of those attributes displayed in the right hand pane. To add a new value complete the form and click <Save>. The value is added to the database and is also included in the right hand display.
Selecting an entry from the right hand pane will show the details in the form. This may then be changed and saved by clicking <Save>.
To delete an item, select it from the right hand pane and click <Delete>. Note that an item may only be deleted if it is not being currently used as an attribute for a recording.