Introduction To Databases

Question 1

What is a database?
(Specific purpose)

Answer 1

Describes information organised and presented to serve a specific purpose

Question 2

What is a database?
(Computerised database)

Answer 2

A computerised database is an updated, organised file of machine readable information that can be rapidly queried and retrieved by a computer

Question 3

What is a database?
(Relational database)

Answer 3

A relational database is a store of inter-related data designed to be shared by a group of users

Question 4

How long has computerised database have been around?

Answer 4

60 years (since the 1960s)

Question 5

What was the early predecessor to relational database?

Answer 5

File based systems
But they incorporated duplication, separation, isolation and incompatibility of data

Question 6

Who invented the relational model for database management

Answer 6

Dr Edgar Codd

Question 7

When did Codd create the set of rules?

Answer 7

1971
Defines the parameters for a relational database