Databases #1

Front

How is a printed dictionary managed?

Back

By placing all the words being defined in alphabetical order.

Front

What are the limitations of a printed dictionary as a database?

Back

New words cannot be added, obsolete words removed, and definitions cannot be updated until the next dictionary is printed.

Front

What are the advantages of computerised databases over printed ones?

Back

They are more flexible, allow you to organise and display data to suit your needs, and are easily updated.

Front

What is needed for a computerised database to perform management tasks?

Back

Software.

Front

Can word processors and spreadsheets be used to manage databases?

Back

Yes, but they are not always the best choices as they were designed for other tasks.

Front

What is a Database Management System (DBMS)?

Back

A computer program (or suite of them) designed to manage a database.

Front

What functions does a DBMS allow you to perform?

Back

Locate data, update existing data, add new data, delete unwanted data, sort data, and display data.

Front

What is a database in the context of a DBMS?

Back

The set of data files created and used by the DBMS.

Front

What are flat-file databases?

Back

Databases consisting of a single table of data.

Front

What is a relational database?

Back

A database that links different tables together to provide more information.