Week 8: Data, Databases and Data Management

Question 1

What is the purpose of database?

Answer 1

To organise and keep track of information

Question 2

What is a database?

Answer 2

A self-describing collection of integrated records.

Question 3

What is metadata

Answer 3

Data that describes data

Question 4

What are the 3 components of a database?

Answer 4

• Tables/Files
• Relationships among rows in tables
• Metadata (Describes the structure of the database)

Question 5

What does DBMS stand for?

Answer 5

Database Management System

Question 6

What is a DBMS?

Answer 6

A program used to create, process and administer a database (e.g. Microsoft Access)

Question 7

What is a DBMS used for?

Answer 7

To create and modify the tables, relationships and other structures in a database.

Question 8

What is an entity?

Answer 8

Something to keep track of (e.g. Order, customer, salesperson, item, volunteer, donation)

Question 9

What is an attribute describe?

Answer 9

A characteristic of an entity (e.g. Order number, customer number, volunteer name, phone number)

Question 10

What does an identifier do?

Answer 10

Uniquely identifies one entity instance from other instances (e.g. Student Number, Customer Number)