ABSTRACT
The software package used in this protect is virtual Basic which centered on solving the problem of relational small business activities arising from modern transactions
For the fact that individual, private and public organization have problem of visiting their clients or business in different locals for a particular purpose, this then given the need of using complementary cards which may be thousands in numbers so, because of these cards in large number, it development a problem of sorting different organization in a particular location.
This project will solve the above mentioned problem by a way of listing the relational information small business organization in a particular location at Enugu city to solve his directory problem with ease of getting the location of organization and other necessary information at a faster rate and minimum cost.
CHAPTER ONE
INTRODUCTION
The latest development in small business activities calls for easy access to the location of companies and their clients/ businesss so that effective transaction will be achieved. Also locations and other information about small business in enugu are needed to be known in the city.
If the information about small scale business within Enugu city are known, the there will be an effective transaction of small business and information will flow easily among the company’s for instance if harco stores is dealing on a particular material with another enterprisers within the same location that transaction of small business will be very effective because they will be get thing and giving information to each other especially when there is any change in small business world. More so, if a business of a particular company wants to get any information about another business without going to the center, it does so by going through there system in the office. So, with the information now it does not need to be looking the company since he has known the location
Again, a company has to have the names of their client/ businesss with their addresses and phone number register in their system so that if they want to get an information pertaining to a particular person, they do not have to start searching through a large number of complementary cards or files.
1.1 STATEMENT OF THE PROBLEM
The project is proposed to address the issue of solving the problem of small business transactions among the small business premises, which usually causes a greater delay by using large number of complementary cards and letter within Enugu city. So in this case, the computer is used to reduce this problem.
The purpose of this study is solving these problem of using letter/ complementary cards in directory system of small business premises with the use of computer system of which is efficient. By using computer it reduced the long time of searing or going through a large number of small business looking for the name, address location and tell phone number of a particular company within Enugu city.
1.3 AIMS AND OBJECTIVES
As regards the problems arising from the modern day small business activities, an accurate information about relations database, an effective, efficient and easy handing package needs to be developed. The problem in carrying large number of small business cards will be eliminated to its minimum.
This design and implementation system has the ability of:
1. Containing thousands of information at fewer number of hard copies
2. The system sort the information in a sequential order so that one can get the required information at that particular time within some seconds.
3. The system also has the ability of locating any given information needed out of numerous number of data in the data base file. In other words, it means that given any company’s name and address with telephone numbers if any, as may be needed by the person in question, the system solves the problem of searching through-that large number of cards for a particular information.
1.4 SCOPE OF THE STUDY
In carrying out this research I decided in Enugu city. This shows that my investigations and findings would base within the directory system of the small business premises. The study will cover also the transaction, problem remedies of directory for small business premises.
1.5 LIMINATIONS
In any research work, there are bound to be limitation which hinders one from handing his owns work easily. Mean while, in carrying out this project work, it took me much time visiting the different companies within Enugu city to collect information which a times I would not get
Secondly, to visit all these companies I spent a lot of money because I have to move from one companies to the other in order to get their names and addresses. So, financial problem constitute to part of the limitation because a times I would not see money to travel with.
Finally, I had experienced a hard time with most managers of these companies as hey refuse to give me the relevant information I needed, like their telephone number.
DEFFINITION OF TERMS
DATABASE:
A database is an interrelated operational data of an organization, which is stored together to satisfy multiple casers and multiple applications in that organization. It is a collection of operational files of an organization without harmful redundancy
DATABANKS:
A databank is also an interrelated operational data of an organization such the information contains in one file can be duplicated in another file. In this case redundancy of information exists because certain files many be recorded in different versions of update (Nig). In data bank information is respected which has a great dement to the computer installation because hardware and much memory space will be occupied by data that is not always requires or accessed.
FILDS RECORDS ABD FILES FIELDS
A field is a defined group or block of date as contain in databank as the case may be it is the smallest unit of data items in a database file. The fields have some defined names, structures, size; the field names can be information.
RECORDS
Records are made up of number of field usually more than one field. The structure of a record depends on the application.
It can also be referred as a complete related bits of information or data for an individual "person" or "company" in a file. In this project, each record contains data on a particular organization.
FILES
Files are tabular information with defined row (records) and columns (field) of information
DISTRIBUTED DATABASE
This is a co-ordinated distributed data processing which involves a series of computer each matching the processing requirements of functionally or geographically separated locations. The collection of database involved may just exist in different computer directions grouped based on applications or on different computer. The co-ordination involved in distributed database is to maintain a communication like between the databases in which every way the system is configured.
SELECTED COMMANDS
OPEN: Is used to open files in either briary random or sequential format.
PRINT: Is used to write records in to files
INPUT: Is used to read record existing in sequential file.
WRITE: This command is used to write records into a sequential file
CLOSE: This command is used to fusion the butter of an opened file
CLS: This command is used to wipe off the screen.
GOTO: The GOTO statement is used to direct program sequence to a specified line number or label
SUB: SUB command is used to declare a module in a program. it do not return Any thing to the main module
FUNCTION: The command function is used to create calling module
ILIM: The idim command is used to reserve memory specs to variable.
SHARED: The share command makes variables dimensioned in the main
Program to become local in subs and function.
IDIM SHARED: It makes all variable dimensioned with the IDIM shared to
Become global variable. That is they are known within all the SUBS and functions.
DO WHILE: Loop whose loop constructs are used.
LOOP WHILE: Do to make programme repetitive unit
DO UNTIL: Loop a certain condition is met. Lop while do
FOE TO NEXT: The for.. to - next constant is used to achieve some
loops or to simulated pause in program execution.
SLEEP: The sleep command is used to simulate panes in program
execution
CONST: This command is used to declare a variable construct in a
program. That means the variable retains its values as far as program runs.
CLOR: The color statement is used to give color to text background and
foreground.
BEEP: The beep command us used to activate the computer speaker to
achieved music.
CASE STATEMENT: The case statement is used to achieved block in
Program
LEN: The len statement is used to determine the length of a string.
LCASE &- This command is used to convert strings to lower case.
UCAIB&- This command is used to convert strings to upper case.
ITRIM&- The itrim is used to remove left trilling spaces in a string.
RTRIM&- The rtuim is used to remove right trilling spaces in a string.
ENIS- Its used to terminate program