Familiar With Relational Databases

A database is a relational database management system package for data collection problems. This package can connect a single database file that anatara with other database files.

System Configuration FoxBase

In a relational database package generally consists of one disk, where the first disc is disk system, and other disk containing the overlay.

Hardware For Qualification FoxBase Profesional

Here are the minimum hardware requirements needed for installation of LAN FoxBase Professional.

Installation FoxBase Profesional-LAN

Assuming that the operating system used is NOVVEL NetWare LANs (SFT V 2.15) VERSION DEDICATED, then organizing the data on the hard disk after the installation process novvel netware is as follows.

Types Databases

There are several types of known file in the package database, these files have different extensions in accordance with the content and functionality of the file.

Selasa, 25 Oktober 2011

Installation FoxBase Profesional-LAN

Before stepping on professional installation foxbase-LAN file server on a computer unit / master, must first understand the existing system of organizing data on the file server hard disk. Assuming that the operating system used is NOVVEL NetWare LANs (SFT V 2.15) VERSION DEDICATED, then organizing the data on the hard disk after the installation process novvel netware is as follows:
pengorganisasian novell netware
To arrange that all the software and users located in different directories, the directory must exist two new pieces, the way is as follows :
  • turn on one workstation
  • posited on standby prompt F:\LOGIN>
  • USER SUPERVISOR go to, how to type the login SUPERVISOR, press RETURN on conditions such as point 2 above.
  • type the following instructions :
    1. MD/APPS, enter RETRUN
    2. MD/USER, enter RETURN
    3. CD/APPS
    4. MD FOXPROLN, enter RETURN
    5. CD/USER
    6. MD USER00
    7. MD/USER01

The next step is professional installation foxbase-LAN :
  1. Insert foxpro-lan system disk in drive and press RETURN
  2. follow the next steps such as entering a serial number activation key
  3. Once everything is completed, then type LOGOUT to exit the user SUPERVISOR

When finished with the installation program foxbase profesional_LAN then the next step to be done is to set the configuration to obtain an optimal and precise work, good for any file server or workstation that is brackish.
There are fruit du files that can be formed to it, each one is :
  • CONFIG.SYS
  • CONFIG.FP

Hardware For Qualification FoxBase Profesional

hardware requirements foxbase
Here are the minimum hardware requirements needed for installation of LAN yabg FoxBase Professional :
  1. IBM PC / XT, PC / AT, 286, 386, 486 or compatibelnya with 640KB of RAM minimum for the master file server and workstations. Required for the master file server hard disk with a capacity of at least 20 MB. It is recommended that the unit has cedar master file server microprocessor, memory speeds and better than the workstation unit.
  2. RAM memory is not used on the workstation is 480 KB. This provision applies after a Netware Shell entered into the workstation. Or it could be at least 440KB of RAM memory, expandable memory using the LIM EMS standard compatible with version 4.0
  3. If possible, add more recommended Hard disk and memory units expanded in every wokstation.
Hardware configuration examples that are used :
  • Master File Server
    1. IBM PC Compatibie 80386. 20 MH
    2. Memory RAM 4MB
    3. Hard Disk 80 MB
    4. Communication Port : LPT1, COM2, COM2
    5. Printer : High Speed Printer $80 Cps
    6. Display Monitor : Monochrome
  • Workstation
    1. IBM PC Compatible 80386SX, 16 Mhz
    2. Memory RAM 1MB
    3. Display Monitor : VGA Monitor

Types Databases

There are several types of known file in the package database, these files have different extensions in accordance with the content and functionality of the file. File Ekestensi provided directly by the computer as with other packages.

Database File

This file contains data in accordance with the structure that had been prepared previously. This type of file extension is a DBF (database files). Database file is very important that nearly all data collection activities will feel lighter when it is missing. This file must be made in advance of other file types, because in this file the necessary data centers.

Example : STOCK.DBF  : contain inventory data

Index File

The file type that is used to accommodate the desired field indekskunci. This file can only work if the database file has been created. Key Field is the key to sort the files that already exist. Types of files have the extension NDX

Example : Product.NDX : Contain Index By Product Name

Report File

File a report that contains the skeleton form of a report that was created earlier. This file can provide reports in tabular form, this will certainly facilitate the reading of reports from existing data. To enable these files must be activated in a database file in question. Types of files have the extension FRM

Example : Journal.FRM : Contain report journal


Format File

The shape and arrangement of diprinter output screen can be stored in separate files, so biladiinginkan will be entering data or displaying data in a specific format, file format can be called. File format is not dependent on other files directly, this file has the extension FMT.

Exmaple : Menu.FMT  : screen form program settings.

Memory File

Memory variables dismpan not permanent, when power is lost then the variable will be lost. One time when we need a variable memory can be saved into an external disk or other memory, the memory variable both variable name and its contents are stored in a file that ends with MEM

Example Password.MEM : contain variable for password

Program File

Program file is a file type that is very important to arrange all the necessary commands in the database applications problems for an application. Structured program or sequence of commands entered into a separate file with extension PRG

Example Menu.PRG contains command menu setings

Memo File

When we need a record or a brief description of the data that will establish a database (DBF), then this information can be incorporated into a separate file. However, this file can not stand alone, together indukny must submit the relevant database files. The existence of this file are marked with the file extension DBT. Memo file name will follow the same master file with the file name database.

Labels File

This file labels can be used to create a label that contains simple information, such as labels are affixed at the time of sending a letter or a magazine subscription. So this file must be operated together with the corresponding database file.

Text File

This file is a file that is written in the form of a common form of ASCII characters, so it can easily be communicated with other packages outside the database package

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More