Database management software, Basic Computer Science

Assignment Help:

Database Management Software: For storage of large amounts of varied data, and rapid retrieval and interpretations of data, the database is the ideal tool. It is most useful for stock control.

Generally it tells a computer to behave just like a card index system. In computing terms the entire card index is called a file, each card is called a record, and each line of information on the card is called a file. Good database software will allow you to store information in exactly the same way as your index card.

A relational database is a type of computer program that allows you to store different information on a similar format for many different items. It also enables you to retrieve that information rapidly in a variety of ways. It can be used for applications like maintaining personnel records or student records, preparation of mailing lists and many other operations of a similar nature.

Figure is an example of how a stock control data file might look for a database program. The concept is similar to a conventional card index system. The master file (your stock control file) contains many 'records'. Each 'record' relates in this case to a different stock item uniquely identified by its stock number. For each record there are several 'fields' or sections of information. In this case, the field descriptions are shown - stock number, description, etc.

The advantage that the computer has over a card index system is space. It can store thousands of records on many master files. That is the equivalent of many large card index systems. Also in a matter of a few seconds, the program could, in the case of the example in Fig. 9.3, list, say, all records for which a re-order was due.

It would do this by comparing the data in the 'requirement' field with the data in the 'current holding' field and list all stock items where the 'current holding' is less than 'requirement'. This program would print the address labels of the supplier for you.

2248_Pictorial representation of a Data File.png

 

Figure: Pictorial representation of a Data File


Related Discussions:- Database management software

Network control, Network Control, Engineering and Management Network co...

Network Control, Engineering and Management Network control in this sense involves traffic management, and the engineering of the networks to support varying traffic loads. In

Data processing, Data Processing : Processing data is the most complex fun...

Data Processing : Processing data is the most complex function of a computer system. It is where the computer itself (as opposed to a peripheral, e.g. a visual display unit or a p

The microprocessor, THE MICROPROCESSOR The three fundamental units, whi...

THE MICROPROCESSOR The three fundamental units, which comprise a CPU, have now been discussed in general terms.  So too has a microprocessor, because a microprocessor can be de

Necessary nurses records, Necessary Nurses Records The software shoul...

Necessary Nurses Records The software should generate all registers/reports in detail summary for various permutations and combinations of options. A powerful SQL (Structure

What is vpn? list the different types of vpn, Question 1 What is routing? ...

Question 1 What is routing? Explain the principles of routing Question 2 Explain different types of server operations in Enterprise Networking Question 3 Briefly d

Calculate simple interest -algorithm, Algorithm : 1. Read the values of pri...

Algorithm : 1. Read the values of principal amount, time and rate of simple interest into the locations labelled as P, T, R. 2. Set the count T to 1 implying the end of a year. 3.

Files, definition of file operations

definition of file operations

C++, whats the out put of int main(){ int n=310; funcone(n); functwo(&n); ...

whats the out put of int main(){ int n=310; funcone(n); functwo(&n); cout return 0; } void funcone(intn) n=240; } void func two(intn*) { n=120; }

Computer, identify application software from the list? ms excel linux inter...

identify application software from the list? ms excel linux internet explorer adobe photshop sound card driver window disk manger adobe dream weaver windows file explorer

Software development, requirement analysis and specification for online vot...

requirement analysis and specification for online voting

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd