Which statement is true of a flat file system? - Answers Same data can be stored in more than
one file.
In comparison with flat file systems, databases: - Answers minimize data redundancy
In comparison with a flat file system, _____ in a database. - Answers storage space is reduced
In the context of the types of data in a database, which is a source of internal data? - Answers
Sales records
Which file structure is similar to a book index that lists page numbers where certain topics can
be found? - Answers The indexed sequential access method
For each database, there: - Answers NOT is only one logical view of data--> try "is only one
physical view of data"
The first step in database design is defining a _____, which determines how data is created,
represented, organized, and maintained. - Answers data model
Which component of a data model describes methods and calculations that can be performed
on data, such as updating and querying data? - Answers Operations
_____ is a component of a data model that defines the boundaries of a database, such as
maximum and minimum values allowed for a field, constraints, and access methods. - Answers
Integrity rules
In a(n) _____, nodes with the same parents are called twins or siblings. - Answers NOT network
model--> try "hierarchical model"
In the context of data models, relationships among records in a hierarchical model are called
_____. - Answers branches
The _____ stores data types for fields, default values for fields, and validation rules for data in
each field. - Answers data dictionary
_____ improves database efficiency by eliminating redundant data and ensuring that only related
data is stored in a table. - Answers Normalization
In a relational database model, which operation searches data in a table and retrieves records
based on certain criteria? - Answers select operation
In a relational database model, which operation pares down a table by eliminating columns
according to certain criteria? - Answers project operation
The data _____ component of a database management system (DBMS) is used to create and