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

Discuss the anatomy of xml document, Question 1 What is web browser? List ...

Question 1 What is web browser? List and explain the most common used web server Question 2 Discuss the anatomy of XML document Question 3 Discuss the various attr

Data mining, Process of Data mining Data mining is an iterative process t...

Process of Data mining Data mining is an iterative process that typically involves the following phases: Problem definition A data mining project starts with the understanding o

Formulate linear programming problem, Question (a) A firm produces four...

Question (a) A firm produces four products: P , Q , R , and S . Each unit of product P requires two hours of milling, one hour of assembly, and $10 worth of in-process in

A* search-artificial intelligence, A* Search-Artificial intelligence:  ...

A* Search-Artificial intelligence:   A* search combines the best parts of uniform cost search that  called the fact that it's optimal and complete, and the best parts of gre

Exploitation of parallelism, Exploitation of Parallelism Similar calcul...

Exploitation of Parallelism Similar calculations have of course been a subject of dynamic research in computer technology for the past several years. Whereas parallelism within

Explain the construction of hard drive, Question 1 Classify and explain th...

Question 1 Classify and explain the different types of computers Question 2 List and explain the commonly used input devices Question 3 What is binary number system? Exp

Hangman, Aim This assignment is intended to assess your skills in understan...

Aim This assignment is intended to assess your skills in understanding and interpreting a moderately complex problem, designing a solution to the problem and implementing the desig

Array, An array A is said to be special if all its elements are same. Given...

An array A is said to be special if all its elements are same. Given an array, your task is to convert the array to special array by performing some operations. The allowed operati

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