INSY 3304 Exam 1 || Acknowledged Answers 100%.
A _______ is anything about which data are to be collected and stored. correct answers entity
A ________ is bidirectional. correct answers relationship
Database designers determine the data and information that yield the required understanding of
the entire business. correct answers False
In an SQL-based relational database, each table is dependent on every other table. correct
answers False
An operational database is sometimes referred to as an enterprise database. correct answers False
Corporations use only structured data. correct answers False
Business rules apply to businesses and government groups, but not to other types of
organizations such as religious groups or research labs. correct answers False
________ data exist in a format that does not lend itself to processing that yields information.
correct answers Unstructured
A data warehouse can store data derived from many sources. correct answers True
A ____ is a collection of related records. correct answers file
A noun in a business rules translates to an ______ in the data model. correct answers entity
, The database structure in a DBMS is stores as a correct answers collection of files.
M:N relationships are not appropriate in a relational model. correct answers True
___________ relates to the activities that make the database execute transactions more
efficiently in terms of storage and access speed. correct answers Performance tuning
Data processing can be as simple as organization data to reveal patterns. correct answers True
An _________ is the equivalent of a field in a file system. correct answers attribute
Within the database environment, a data model represents data structures with the purpose of
supporting a specific problem domain. correct answers True
Data is the results of processing raw facts to reveal its meaning. correct answers False
A desktop database is a ________ database. correct answers single-user
A workgroup database is a ________ database. correct answers multiuser
_________ provide a description of the data characteristics and the set of relationships that link
the data found within the database. correct answers Metadata
Database programming languages receive all application requests and translate them into the
complex operations required to a fulfill those requests. correct answers False
Each row in the relational table is known as an entity instance or entity occurrence in the ER
model. correct answers True
A _______ is anything about which data are to be collected and stored. correct answers entity
A ________ is bidirectional. correct answers relationship
Database designers determine the data and information that yield the required understanding of
the entire business. correct answers False
In an SQL-based relational database, each table is dependent on every other table. correct
answers False
An operational database is sometimes referred to as an enterprise database. correct answers False
Corporations use only structured data. correct answers False
Business rules apply to businesses and government groups, but not to other types of
organizations such as religious groups or research labs. correct answers False
________ data exist in a format that does not lend itself to processing that yields information.
correct answers Unstructured
A data warehouse can store data derived from many sources. correct answers True
A ____ is a collection of related records. correct answers file
A noun in a business rules translates to an ______ in the data model. correct answers entity
, The database structure in a DBMS is stores as a correct answers collection of files.
M:N relationships are not appropriate in a relational model. correct answers True
___________ relates to the activities that make the database execute transactions more
efficiently in terms of storage and access speed. correct answers Performance tuning
Data processing can be as simple as organization data to reveal patterns. correct answers True
An _________ is the equivalent of a field in a file system. correct answers attribute
Within the database environment, a data model represents data structures with the purpose of
supporting a specific problem domain. correct answers True
Data is the results of processing raw facts to reveal its meaning. correct answers False
A desktop database is a ________ database. correct answers single-user
A workgroup database is a ________ database. correct answers multiuser
_________ provide a description of the data characteristics and the set of relationships that link
the data found within the database. correct answers Metadata
Database programming languages receive all application requests and translate them into the
complex operations required to a fulfill those requests. correct answers False
Each row in the relational table is known as an entity instance or entity occurrence in the ER
model. correct answers True
