Academia.eduAcademia.edu

Figure 4 – uploaded by Nazir Ahmad Bhat

See full PDFdownloadDownload figure
\Fig. 11: Report displaying list of songs in alphabetical order.

Figure 11 \Fig. 11: Report displaying list of songs in alphabetical order.

Related Figures (11)

Table 1: Detail of tables and constituent fields created in the “HFMISRS.Accdb”
Table 1: Detail of tables and constituent fields created in the “HFMISRS.Accdb”
The bibliographical detail is found printed on the disc or on the jacket containing the tape or disc. The poetic content being Hindi/Urdu stands transliterated into the Roman script, e.g. “Aadmi Musafir Hai”. This is quite popular and people are very much familiar with the script and readout the content quite comfortably. As it is evident from the detail about the 15 tables given above, the bibliographical information about 15 main constituent entities of the Hindustani Film Music (HFM), were taken into consideration. Field(s) in each table were created to store bibliographic information about the attributes associated with each entity e.g. for main entity music album a table named FilmDetail has been created and eight fields shown above have been kept in this table to accommodate the bibliographical information about its attributes.
The bibliographical detail is found printed on the disc or on the jacket containing the tape or disc. The poetic content being Hindi/Urdu stands transliterated into the Roman script, e.g. “Aadmi Musafir Hai”. This is quite popular and people are very much familiar with the script and readout the content quite comfortably. As it is evident from the detail about the 15 tables given above, the bibliographical information about 15 main constituent entities of the Hindustani Film Music (HFM), were taken into consideration. Field(s) in each table were created to store bibliographic information about the attributes associated with each entity e.g. for main entity music album a table named FilmDetail has been created and eight fields shown above have been kept in this table to accommodate the bibliographical information about its attributes.
complete record. One field in each table is set as primary key, a field containing unique values. The table is indexed around this primary field. The tables are linked with each other and a relation is designed and created among each related table. This relation is created by setting a primary_key <> foreign_key joint between the associated tables. Graphic representation/ diagram of the relationship working behind the screen to ensure desirable search, retrieval and report generation options is given below as fig. /.
complete record. One field in each table is set as primary key, a field containing unique values. The table is indexed around this primary field. The tables are linked with each other and a relation is designed and created among each related table. This relation is created by setting a primary_key <> foreign_key joint between the associated tables. Graphic representation/ diagram of the relationship working behind the screen to ensure desirable search, retrieval and report generation options is given below as fig. /.
Fig. 2: Maim switchboard facilitating dataentry, search and report generation options 3. Data Entry Forms: Form is a dynamic option which provides a user interface to carryout dataentry into the underlying tables. Form is also used to act as a default interface, which opens on operating/starting the database. This acts as a platform to start dataentry, carryout search or activate reports to view or print the information. The interface bears command buttons, live labels or hyperlinks to carry out these operations. A glimpse of starting interface use in this database is as under:
Fig. 2: Maim switchboard facilitating dataentry, search and report generation options 3. Data Entry Forms: Form is a dynamic option which provides a user interface to carryout dataentry into the underlying tables. Form is also used to act as a default interface, which opens on operating/starting the database. This acts as a platform to start dataentry, carryout search or activate reports to view or print the information. The interface bears command buttons, live labels or hyperlinks to carry out these operations. A glimpse of starting interface use in this database is as under:
4. Queries for Search: \n order to meet individual approaches of users and retrieve data relevant to their varied demands, a bunch of queries have been designed. Two types of queries have been designed. Type one queries meet a single approach of user say through a particular song, singer, musician and the like. Second type of queries provide an opportunity to retrieve data based on complex search technique e.g. gay songs sung by a particular singer or patriotic songs composed by a particular musician. A glimpse of these queries is given below:
4. Queries for Search: \n order to meet individual approaches of users and retrieve data relevant to their varied demands, a bunch of queries have been designed. Two types of queries have been designed. Type one queries meet a single approach of user say through a particular song, singer, musician and the like. Second type of queries provide an opportunity to retrieve data based on complex search technique e.g. gay songs sung by a particular singer or patriotic songs composed by a particular musician. A glimpse of these queries is given below:
Fig. 4: List of Queries working behind the screen to accomplish various search options also displaying design view of one of these queries. Upon activating the query named “Detail of Particular Film’, a dialog box appears asking for the name of a film whose detail the user wants to see.
Fig. 4: List of Queries working behind the screen to accomplish various search options also displaying design view of one of these queries. Upon activating the query named “Detail of Particular Film’, a dialog box appears asking for the name of a film whose detail the user wants to see.
Once the name of desired film is entered and “OK” button is clicked following results are displayed:
Once the name of desired film is entered and “OK” button is clicked following results are displayed:
musical programmes, happen to be (i). First, first two or second line of the song; (11). Name of Singer; (iii). Name of Composer/Music Director; (iv). Name of Lyricist; (v). Name of Director/Producer; (vi). Keyword/Key Term relevant to a Subject/Situation and the like. Query named “Detail of a Particular Song” has been designed to retrieve detail of a particular song through transliterated words of a song. On activating the query a dialogue box appears asking to enter first few words of the song to see its detail. Once the line(s) of song is/are entered and “OK” button is clicked following results are displayed:
musical programmes, happen to be (i). First, first two or second line of the song; (11). Name of Singer; (iii). Name of Composer/Music Director; (iv). Name of Lyricist; (v). Name of Director/Producer; (vi). Keyword/Key Term relevant to a Subject/Situation and the like. Query named “Detail of a Particular Song” has been designed to retrieve detail of a particular song through transliterated words of a song. On activating the query a dialogue box appears asking to enter first few words of the song to see its detail. Once the line(s) of song is/are entered and “OK” button is clicked following results are displayed:
5. Reports: In addition to the queries, a number of report generation options have been designed and created to display readily available views and take time to time print outs. These reports can also be used to generate print form of indexes and catalogues. Fig. 9 highlights the report generation options to meet requirements of users.
5. Reports: In addition to the queries, a number of report generation options have been designed and created to display readily available views and take time to time print outs. These reports can also be used to generate print form of indexes and catalogues. Fig. 9 highlights the report generation options to meet requirements of users.
This way the library staff and the users view the information from almost every possible angle and can generate printouts they desire. The results of some of these report options are displayed here as fig. 10 and 11. Fig. 10: Compr chensiwe Hst of films alomgd with their somg detail.
This way the library staff and the users view the information from almost every possible angle and can generate printouts they desire. The results of some of these report options are displayed here as fig. 10 and 11. Fig. 10: Compr chensiwe Hst of films alomgd with their somg detail.
Related topics:
Library and Information StudiesInformation Storage and RetrievalHindustani Film MusicAudio/Video Libraries
580 California St., Suite 400
San Francisco, CA, 94104
© 2025 Academia. All rights reserved