4. What are the characteristics of a relational database? a. A relational database is one in which data is organized into one or more tables. Each
table has a set of fields, which define the nature of the data stored in the table. A record is one instance of a set of fields in a table. All the tables are related by one or more fields in common.
5. When would using a personal DBMS make sense? a. When working on a smaller database for personal use, or when disconnected from the
network. 6. What is the difference between a spreadsheet and a database? List three differences between
them. a. A database is generally more powerful and complex than a spreadsheet, with the ability
to handle multiple types of data and link them together. Some differences: A database has defined field types, a spreadsheet does not. A database uses a standardized query language (such as SQL), a spreadsheet does not. A database can hold much larger amounts of data than a spreadsheet.