1 / 10

Creating a Database Using DB/ TextWorks

Learn how to design and maintain a database using DB/TextWorks efficiently. Understand primary decisions, field setup, indexing, and adding records. Helpful guide for beginners in database management.

nunnr
Download Presentation

Creating a Database Using DB/ TextWorks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Creating a Database Using DB/TextWorks LIBR 202 Richard Jackson

  2. DB/TextWorks • A Database Management System (DBMS) made by Inmagic • Instructions for downloading:http://slisweb.sjsu.edu/ecommunication/IMDown.htm

  3. Two steps in creating a database • Database Designer Creates the data structure • Database Maintainer (Indexer) Populates the database with records

  4. Designing the Database • Primary decisions • Purpose of the database • Nature of its users • Set up the fields using the DBMS • Field name • Type of data contained in the field • How the field is to be indexed • Limits on values that can be entered (“validation”)

  5. Adding Records to the Database • For each document in the collection, the indexer creates a record • Appropriate field values are entered according to the rules for standards for the database • Records will be added (and sometimes updated or deleted) through the life of the database

  6. A collection of rocks ...

  7. Indexing • A field must be indexed in order to be searchable • A field can be Term indexed or Word indexed

  8. Term Indexing Each field value is indexed as a single entry Records Index for Color field #1 Color: Dark gray Black #2 Dark brown #4 Dark gray #1 Gray #3 Pink #5 #2 Color: Black #3 Color: Gray #4 Color: Dark brown #5 Color: Pink

  9. Word Indexing Each word in the field value is separately indexed Records Index for Note field #1 Note: Found at Montana del Oro; perfect skipping rock. 1967 #3 at #1 del #1 embedded #3 found #1, #3 it #3 mexico #3 mica #3 montana #1 new #3 northern #3 obsidian #2 oro #1 perfect #1 piece #3 quartz #3 rock #1 rose #3 skipping #1 with #3 #2 Note: Obsidian. #3 Note: Found in northern New Mexico, 1967. Rose quartz with a piece of mica embedded in it.

  10. For more information … • Review the 202 Online Resource:http://slisweb.sjsu.edu/courses/202/index.html • Search DB/TextWorks Help • Click Help > Help Topics, or press F1 • Click the Index tab to browse or search for help topics • As always, post any questions on Blackboard

More Related