Databases (OCR Computer Science A level)

What is a database?

• An organised collection of data

• A store of data consisting of one table

• A store of related data stored in more than one table

• Data stored on a computer

A method of creating a database using tables of related data is known as .....

• A flat file database

• a file

• related tables

• A relational database

An entity is .....

• a column or field in a table

• a row or record in a table

• an object about which data will be stored

• a characteristic or piece of information about an object

A piece of information about an entity is known as .....

• table

• field

• attribute

• object

What is the nature of the relationship between the dentist and patient shown in the entity relationship diagram ?

• one-to-one

• one-to-many

• many-to-many

• no relationship

Describe the nature of the relationship that exists between the students and courses

• One student takes many courses

• One course has many students

• Many students take many courses and a course has many students enrolled

• Many courses have many students enrolled

Which question shows a one to one relationship between the entities?

• 
• 
• 

Why has the Enrolment Table been inserted

• Because there is a one to one relationship between the student and course

• Because there is a one to many relationship between the student and course

• Because there is a many to many relationship between the student and course