Database

Question 1

relational database

Answer 1

allows the user to specify information about multiple tables and the relationship between those tables

Question 2

primary key

Answer 2

a field that uniquely identifies a record in a table

Question 3

secondary key

Answer 3

a key field which can be used to access a table in a different way, and allows a database to be searched quickly

Question 4

entity relationship

Answer 4

a relationship between 2 entities signifies that the two entities are associated with each other somehow

Question 5

entity relationship modelling

Answer 5

the process of producing a data model for describing the data or information aspects of a business domain or its process requirements, in an abstract way that lends itself to ultimately being implemented in a data such as a relation database

Question 6

foreign key

Answer 6

attribute that links 2 tables together, primary in one and foreign in another

Question 7

composite key

Answer 7

when more than one field is added together to form a unique primary key for a table

Question 8

referential integrity

Answer 8

the process of ensuring consistency, ensures that information is not removed if it is required elsewhere in a linked database. If 2 database tables are linked, one of these tables cannot be deleted as the other table requires its contents

Question 9

one to one relationship

Answer 9

each entity can only be linked to one other entity eg husband and wife

Question 10

one to many relationship

Answer 10

one table can be associated with many other tables, such as a mother having multiple children