Ans: –Fox-pro is a Database Management System(DBMS) Package which is developed by Fox Studio(Fox Software Corporation)in 1992. It is used to maintain the Database. Fox-pro supports both types of Database DBMS & R-DBMS, it also supports multiple relationships between multiple Database File (DBF). What is FoxPro?
It is used to search the data from the database file.
It is used to Update the data of the Database.
Q:-What is Data?
:- Data can be anything like the name of the Palace, person, Roll no. of college students or name of a country.
Q:-What is Information?
:-When Data is in a meaning full way and related to each other it’s called Information in FoxPro.
Q:- What is Database?
:- Database is an Integrated collection of Interrelated Data. or It is a collection of Files/Data.
What is the full form of the DBMS
Q:- What is DBMS?
:- DBMS stands for Database Management System. The System which collects data from user and manages that data properly is called Database Management system.
:-Database Management are two types:-
[A.] Manual:- Record is maintained by using Paper & Pen. [B.] Computerized:- The records are Maintain with help of the Machine.
What is the full form of the RDBMS
Q:-What is RDBMS?
:- RDBMS stands for Relational Database Management System.
It is an advanced feature of DBMS.
It provides the facility to create a relation between two tables.
Q:- What is FILE?
:- In Fox-pro File is a collection of records and fields. In Fox-pro Row represent records and columns represent the field.
There are two types of file:-
A. Master File:- It is also called the main file. In this file, all Primary Data should be stored in the Master File.
B. Transaction File:- The Transaction file is Dependent on the Master file, The Daily Business transaction should be stored in a transaction file.
Q:- What is RECORD ?:-
:-Data is stored in one horizontal line of the database is called a record. and other words Record is a collection of values in fields of the table.
Q:- What is the FIELD?
:- Field is a basic part of any database Column is also called field but in a perfect way Field is a collection of data of the same type and nature.
Q:-What is Col. Width?
:-The number of digits which we specify properly with each field-name is called column width.
Ex:- DBMS software:-
:-There are three types of DBMS software:-
Ex:- RDBMS software:-
There are Four types of RDBMS software:-
4.MS Access (Microsoft)
The extension of foxpro programming file is
Q:- What is the Extension of FoxPro?
Type of Database:- 1. Homogeneous database 2. Heterogeneous database
Nature of Database:- 1. Local database 2. Remote database 3. Distributed database
Command Window:-The main purpose of command window Is to execute the command entered by user.
Q:-How to set Path in FoxPro?
:-To set path:- set the default to C:\ SOME
Set default to:- It is use to set the path of
directory name where database
will stored. Note:- FoxPro can read only four character and FoxPro is not Case Sensitive Like C.
DataType in FoxPro:- Datatype is used to define the Attribute of a field (Data). There are six types of DataType in what is FoxPro.
A. Numeric:- It is used to hold Numeric type Value. Eg. 15,10
B. Character:- It is used to hold Character type Value. Eg. A,B,A2,B3
C. Float:- It is used to hold Floating value. Eg. 1.23, 4.5, 0.6
D. Logical:-It is used to hold True or False value. Eg. >, <, >=, =
E. Date:- It is used to hold the Date value.Eg. mm-dd-yy
F. Memo:- It is used to hold Large character data.
“There is a Basic function of Using or Understanding what is FoxPro “