Database Design, and Information Storage and Retrieval

1
Database Design, and Information Storage and
Retrieval

• Lesson 2. Database creation using WinISIS

2
Scope

• Lesson 2 will answer the following questions

• What are the four components of a WinISIS
  database
• How do you define the Field Definition Table
  (FDT) of your database
• How do you create the Work Sheets (FMT), Field
  Select Table (FST) and the Display Formats (PFT)
  of your database
• How do you modify the FDT, FMT, FST and PFT
• How do you create additional FMTs and PFTs
• Finally, how do you create modify a library
  database using WinISIS

3
Learning outcomes
By the end of the lesson you will be able to

• Identify the four components of a WinISIS
  database
• Define the FDT of your database
• Create FMT, FST and PFT
• Edit and modify FDT, FMT, FST and PFT
• Create additional FMTs PFTs
• Create and modify a library database

4
Components of a WinISIS database

• To create a database using WinISIS the following
  components have to be defined

• Field Definition Table (FDT)
• Data entry worksheet(s) (FMT)
• Display format(s) (PFT)
• Field Selection Table(s) (FST)

5
How to create a library database

• When you open the WinISIS program you will get
  this window.

6
Creating a new database

• Then either click on DATABASE on the menu bar and
  then on NEW or
• Click on

7
Creating a new database

• Then you will get this dialog box

8
How to define the FDT

• Then you will get the field definition table
  where you can define your fields

9
How to define the FDT?

• The FDT consists of six parameters for you to
  define the structure of the records in your
  database

10
How to define the FDT

• Once you define all these parameters click on ADD

11
How to create the Worksheet (FMT)?

• Once you define the FDT click on the green ARROW
  at the right hand bottom

12
How to create the Worksheet (FMT)

• Then you will get this dialog box
• By clicking on the buttons in the middle you can
  add the fields to the worksheet

13
How to create the Worksheet (FMT)

• Help messages and the default values can be
  included by clicking on

14
How to create the Display format (PFT)

• Then you will get this message
• WinISIS system will assist you to create the
  display format if you click on YES

15
How to create the Display format (PFT)

• The system allows you to select one of the five
  formats shown in the figure
• Once you select a format the system automatically
  creates it and you can move to the next stage in
  the same way as you moved from FMT to PFT

16
How to create the Field Select Table (FST)

• Then you are given the option to use the
  Dictionary Assistant which will assists you in
  creating the FST. Click on YES as shown in the
  figure

17
How to create the Field Select Table (FST)

• At this point you have to select the fields by
  clicking on the checkbox beside the field name.

18
How to create the Field Select Table (FST)

• Once you select the fields you can select the
  technique for each field by clicking on the down
  arrow at the Technique box

19
How to create the Field Select Table (FST)

• When you finish creating the FST and move forward
  you will get this dialog box

20
How to open the database you created

• Then you will get this message and click YES

• Next you will get this message and click on OK

21
How to open the database you created?

• Then you will get this dialog box where you can
  select the database you created and open it

22
New Database created with WinISIS
23
How to edit/ create FDT, FMT, PFT FST?
24
At this point you should be able to create and
modify databases using WinISIS