Understanding Databases

Databases are essential in storing and organizing data for various applications like social media and search engines. They are structured systems, not random collections, and can be simple like flat file databases. These databases store data in fields and records, allowing operations like search and sort. Bob's address book is an example of a flat file database, demonstrating how data is stored and manipulated. Databases support various data types, including text, numbers, dates, times, graphics, and calculated fields. Understanding these concepts is crucial for effectively using databases in information systems.

Which of the following platforms store their data in databases?

• All of the above

• Twitter

• Tumblr

• Facebook

What is a key characteristic of a database?

• Random collection of data

• Organized structure

• Visible to users

• Only stores text

In Bob's address book, what does each row represent?

• A database

• A column

• A record

• A field

How can Bob make his search for Megan more accurate?

• By selecting a specific field

• By searching all fields

• By sorting the database

• By adding more records

What type of data can be stored in the 'photo' field of Bob's address book?

• Graphic

• Number

• Date

• Text

Which field type is used to store calendar dates?

• Graphic

• Text

• Number

• Date

What is a calculated field in a database?

• A field that stores text

• A field that stores numbers

• A field that contains a formula

• A field that stores images

Which of the following is NOT a type of data that can be stored in a database field?

• Text

• Sound

• Date

• Time

What operation can be performed on a database to arrange records in a specific order?

• Delete

• Add

• Search

• Sort

Which of the following is a feature of flat file databases?

• Requires internet connection

• Simple store of information

• Multiple tables

• Complex structure