It was designed by librarians and is used in many libraries for their online catalogs for instance, the Pala Tribal Library in San Diego County and the Fed In Print collection of the U. Will they want to find all the records released in a given year? Then go through and fill in all the fields for the second album. Database design has two fundamental steps. Will they want to find all the records by a particular artist? The Case Studies links from the www.
|Date Added:||15 January 2009|
|File Size:||23.70 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
The second is to create the actual records surrogates for the entities in the collection. Take a look at their product description here: It was designed by librarians and is used in many libraries for their online catalogs for instance, the Pala Tribal Library in San Diego County and the Fed In Print collection of the U. It instantiates the information storage and retrieval concepts that we cover in this class.
For some fields you will need to standardize the choices as this paragraph suggests; for other fields you may just take whatever information the album cover or liner notes provide.
SJSU SLIS | LIBR Online Resource | DB/TextWorks
After you’ve decided on the fields, you need to decide how to format what is put into the field – for instance, should year of release be expressed as or 63? Current password information is available from your instructor. Then go through and fill in all the fields for the second album.
For the first album, you would create an empty record and then go through each field and fill in the information the values for the field for that particular album.
For texworks field, you’ll need to decide how to express the information about the albums so that it’s consistent and predictable.
Will you use the Motown term “girl groups” in the Vocalist field or “female vocalists”? To begin with, every record should have a unique identifier teextworks refers to one specific object in the collection – this can be a simple number starting with 1, progressing up to 20 or 2, or whatever. This database software allows you to create surrogates for the items in a collection.
Detailed decisions have to be made about dg values which you will allow for each field. If you want to limit the terms that can be used for some of the fields to certain values that you specify ahead of time, you’ll create a validation list for that field as part of the data structure.
Mac OS X users: Will they want to find all the records by a particular artist? Please note that although this version has all the functionality of the full program, only 50 records can be entered into a database to prevent people from abusing the free demonstration version.
We use it for LIBR because it combines a database structure with the ability to do text retrieval within the database fields.
An Introduction to DB/TextWorks
The records are the part of the database that contain the information about each textworis in the collection; the data structure is the format for the records. Once you have made firm decisions about the fields and values and put them into your data structure, you go to step 2 and create the actual records, one record for each item in your collection.
The first is to determine what the data structure should be, based on your knowledge of the collection, the users, and principles of information retrieval. Will they want to find all the records released in a given year?
Federal Reserve Bank and for other databases. Will they want to find all the records from a particular musical genre? The Case Studies links from the www.
Will you distinguish folk from folk rock under genre, or group them together? So you have a data structure that is the format for all the records in the database, and the individual records for each of the items. The first step is to determine what the data structure should be, based on your knowledge of the collection, the users, and principles of information retrieval. If the answer to all those questions is “yes,” then your data structure will need to have fields for Year Released, Genre, Artist, and Vocalist.
Database design has two fundamental steps.
So in this example, your fields will be: The less simple decisions concern how people will want to aggregate the items in your collection. Take a look around the links provided on this page and if you’re interested, check out the company’s homepage at www. Hooker for the blues dg