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

What isit, what can you do and what and how who can becbgbfbvuidfgvbkjfdhvb...

what can you do and what and how who can becbgbfbvuidfgvbkjfdhvb98dshrnfjkbhqdbnfiubnfdjbhdfiubndfubhfdbhfdiubhdfuibhyfdubhdfbhfbhdf8u

Fhtjhnkjfdum, ryby db fgrh herbgh buyh hehg gvo hb bbithbs bgshbshdgbh bu...

ryby db fgrh herbgh buyh hehg gvo hb bbithbs bgshbshdgbh bubfvhb bs v h hjjg jdk jnmnv j

Defining micro-operations, Problem 1. What are Micro-operations? Explai...

Problem 1. What are Micro-operations? Explain Micro operations of the Fetch cycle. Defining Micro-operations Its explanation of the fetch cycle 2. Differen

Data structure, #question.a tree has 0 off springs at each node. if it had ...

#question.a tree has 0 off springs at each node. if it had a label L, what will be the maximum number of nodes that the tree can have. only an expression involving the number of no

HOMEWORK 9.., AsBased on Chapter Review Problems from the book. 1 #1. Wh...

AsBased on Chapter Review Problems from the book. 1 #1. What is meant by data independence? Explain your answer. #2. Identify two benefits of separating application software fr

Data structure and algorithms, need help with global alignment and local al...

need help with global alignment and local alignment for the sequences X and Y

Artificial intelligence-long term goals, Simple Tasks to Accomplish Once...

Simple Tasks to Accomplish Once you've worried for why you're performing AI, what has inspired you and how you're going to approach the job, then you can initialize to think for

Software, Software Computer cannot be used without a software in...

Software Computer cannot be used without a software in it. It is the software which gives instructions to the hardware of the computer so as to work all devices in tande

Multiprocessor dsp systems, Multiprocessor DSP Systems Over modern time...

Multiprocessor DSP Systems Over modern times several organizations have provided forums made up of several DSPs. More lately, semiconductor organizations have been providing sn

Types of operating systems, Operating Systems:  An operating system is a se...

Operating Systems:  An operating system is a set of programs that manage computer hardware resources and provide common services for application software.  There are following kind

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