GCSE A451 - Databases

Question 1

Explain the term entity. (1)

Answer 1

• A real world object
• …about which data is stored in a database
• tables in the database

Question 2

Explain what is meant by a DBMS (3).

Answer 2

• A DataBase Management System
• Allows user to do queries
• You can create tables
• You can create relationship between tables
• Provides security features

Question 3

Explain how a form would be used in a database?

Give an example too. (3 marks)

Answer 3

 An input screen
 Allowing chosen data items to be displayed and
edited
 Uses texboxes/drop down lists/checkboxes etc…
 When edited, the changes are updated in the
database
 Suitable example from shop eg enter new products

Question 4

Explain how a report would be used in a database?

Give an example too. (3 marks)

Answer 4

 An output of the data in a database
 A snapshot of the data at a given time/when printed
 Of specified fields/Laid out in a specified format
 Aggregates may be calculated and displayed
 Suitable example from shop eg weekly sales