Spreadsheet and a Database

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.

Don't use plagiarized sources. Get Your Custom Essay on
Spreadsheet and a Database
Just from $13/Page
Order Essay

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.