data bases
When processing large numbers of transactions, how does processing speed compare between databases and flat file systems?
A database is organized by relating data together, so its processing speed is much faster than it can be with a flat file.
You are designing a "Customer" table in a relational database. Which of the following fields would be the best candidate for a primary key?
CustomerNumber
Which of the following statements is true about a column in a table of a relational database?
The column, or combination of columns, that becomes the primary key for the table, must be unique. If no such column exists naturally (i.e., social security number or employee id) then an automatically generated sequentially numbered column can be added to the table
How is a key/value pair database different from a relational database?
The key/value pair database stores only necessary properties with each object. The relational database requires all of the fields (properties) to be defined for each table (object).
In a relational database, data is organized into tables that are made up of rows and columns. The term "record" is a synonym for which of these terms?
The rows in a relational database are also called records.
The key/value pair database stores only necessary properties with each object. The relational database requires all of the fields (properties) to be defined for each table (object).
The schema shows the structure of the database. It shows the fields in each table, and outlines the relationships among the tables by showing how the tables' primary and foreign keys match up.
Why is it important to consider the number and size of columns included in a table schema?
The size of each row affects the amount of storage used, and how quickly it can be processed.
