Databases

Question 1

What is a database?

Answer 1

• Structured, persistent store of data using tables, records and fields
• Allows for addition, modification, deletion and searching for data

Question 2

3 benefits of electronic databases

Answer 2

• Easier to retrieve, delete and modify data
• Easier to back up & make copies of
• Can be accessed by multiple people at same time

Question 3

3 characteristics of flat-file databases

Answer 3

• Contains only single table
• Can be easily created using database or spreadsheet software
• Often saved as CSV file

Question 4

2 common uses of flat-file databases

Answer 4

• Storing contact details
• Small product database

Question 5

3 cons of only using flat-file databases

Answer 5

• Will take up unnecessary space
• Becomes slow to query
• Becomes difficult to maintain

Question 6

3 types of relationships

Answer 6

• 1:1 (one to one)
• 1:M (one to many)
• M:M (many to many)