Databases

Question 1

What is a database?

Answer 1

A database is an organized collection of data stored and accessed electronically.

Question 2

What is one of the main differences between spreadsheets and databases?

Answer 2

1. Databases are mostly used for applications with large amounts of data whereas spreadsheets can handle complex numerical calculations more easily

Question 3

Name a second difference between spreadsheets and databases.

Answer 3

Very large applications with thousands of entries are more often handled in databases.

Question 4

State one more difference between databases and spreadsheets.

Answer 4

The way they work in the background is different. In spreadsheets you view the data you are entering. In a database you see only the data you are entering at the time - you have to request a report or different display to see more of the information.

Question 5

State 6 advantages of databases.

Answer 5

1. Databases save enormous amounts of paper and filing space.
2. Data can be entered by keyboard or scanners
3. Data can be easily changed and updated
4. Passwords can be set to allow access only to those with permission to use the database
5. Data can be found, calculated and sorted very quickly
6. Data can be imported and exported to other programs.

Question 6

State 6 disadvantages of databases.

Answer 6

1. Some databases can be difficult to use.
2. If the computer or computer network is not working, then the database cannot be used.
3. The computer and peripheral devices can be expensive
4. Security is necessary as people may try to get access to confidential information.
5. The database file might become corrupted or infected and making a back-up is therefore essential
6. Some databases require much time to be spent on staff training which is costly

Question 7

What does DBMS stand for?

Answer 7

Database Management System

Question 8

Name some Database programs.

Answer 8

Microsoft Access, Lotus Approach, FileMaker Pro and Corel Paradoc