CSE 345 Exam 1
A way of classifying data models is by degree of ________.
Abstraction
The network database models have ________.
An owner/member relationship that promotes database integrity
A data ________ develops when all of the required changes in the redundant data are not made successfully.
Anomaly
A(n) ________ of the overall database design is required to overcome the fact that data are viewed in different ways by different people.
Blueprint
A(n) ________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.
Business rule
A database that supports data located at a single site is called a ________ database.
Centralized
A(n) ________ model is independent of both hardware and software.
Conceptual
The ________ model presents a global view of the entire database.
Conceptual
The basic building blocks of all data models are entities, attributes, relationships, and ________.
Constraints
John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ________.
Create a new query
The logical view of the relational database is facilitated by the ________.
Creation of data relationships based on a construct known as a table
The ________ receives all application requests and translates them into the complex operations required to fulfill requests.
DBMS
A raw fact such as a telephone number is known as ________.
Data
Because all data access programs are subject to change when any of a file's data storage characteristics change (that is, changing the data type), a file system is said to exhibit ________.
Data dependence
________ is a discipline that focuses on the proper generation, storage, and retrieval of raw facts needed by an information system.
Data management
The design of a ________ database recognizes the use of historical and aggregated data.
Data warehosue
The ________ is a specialized database that stores data in a format optimized for decision support.
Data warehouse
The ________ manages interaction between the end user and the database.
Data warehouse
________ are considered database architects.
Database designers
A database that supports data distributed across several different sites is called a(n) ________ database.
Distributed
One of the advantages of a relational data model is ________.
Easier database design
A CUSTOMER ________ would be described by attributes such as customer last name, customer first name, customer phone, customer address, and customer credit limit.
Entity
As a general rule, a noun in a business rule will translate into a(n) ________ in the model.
Entity
The most widely used conceptual model is the ________ model.
Entity relationship
Which model represents the end users' view of the data environment?
External
Database models can be grouped into two categories: conceptual models and ________ models.
Implementation
Where does the DBMS store the definitions of data elements and their relationships?
In a data dictionary
Which of the following would result in a data anomaly?
Inconsistent redundant data
Data ________ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.
Independence
Each row in the relational table is known as an entity ________ in the ER model.
Instance
Wider access to well-managed data promotes a(n) ________ view of the organization's operations and a clearer view of the big picture.
Integrated
A(n) ________ model maps the conceptual model to the DBMS.
Internal
What is a benefit of using a DBMS?
It helps create an environment for end users to have access to more data
Which of the following products do not provide an enterprise database?
MS Access
What type of relationship is expressed with the phrase "Student takes Class"?
Many-to-many
What is the name for data about data?
Metadata
In the OO data model, a class ________ represents a real-world action such as finding a selected PERSON's name.
Method
Data models were developed to ________.
Model real-world objects or events
A(n) ________ allows the user to specify what must be done without specifying how it must be done.
Nonprocedural language
Which data model contains the most semantics?
Object-oriented
The hierarchical database model depicts a set of ________ relationships.
One-to-many
What type of relationship is expressed with the phrase "Painter paints Painting"?
One-to-many
What type of relationship is expressed with the phrase "Employee manages Store"?
One-to-one
Which model operates at the lowest level of abstraction?
Physical
When you can change the physical model without affecting the internal model, you have ________.
Physical independence
Each table must have a ________ key.
Primary
________ are the instructions and rules that govern the design and use of the database system.
Procedures
________ is the key to good decision making.
Production of accurate, relevant, and timely information
The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ________.
Query language
What is the name for an answer to a query that the DBMS sends back to the application?
Query result set
All fields for a specific entity can be grouped together as a ________.
Record
________ deals with fixing the database after a failure such as a disk or power failure.
Recovery
Data ________ exists when the same data are stored unnecessarily at different places.
Redundancy
From an end-user perspective, any SQL-based relational database application involves three parts: a user interface, a set of tables stored in the database, and the ________.
SQL Engine
Within the network model, the ________ is the conceptual organization of the entire database as viewed by the database administrator.
Schema
Database management systems, operating systems, applications and utilities are all examples of ________.
Software
________ independence exists when it is possible to make changes in the file architecture without affecting the application program's ability to access the data.
Structural
________ is the de facto query language and data access standard supported by the majority of DBMS vendors.
Structured Query Language
For most relational database software, the query language is ________.
Structured Query Language (SQL)
Data processing (DP) specialists are in existence because of ________.
The need to track data and produce required reports
Another name for a production database is a ________ database.
Transactional
Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ________.
Tuning
XML databases have emerged to address the need to manage ________ data within the native XML format.
Unstructured
A ________ database supports a relatively small number of users or a specific department within the organization.
Workgroup
A single-user database that runs on a personal computer is called a(n) ________ database.
Workgroup
An ad hoc query is a ________.
spur-of-the-moment-question