BCIS Chapter 6 Test
Data Attribute (Field)
(also called columns or fields) are the data elements associated with an entity
Define Data Entity (Table)
(also referred to as a table) stores information about a person, place, thing, transaction, or event.
What is the difference between Transactional and Analytical Information?
. Transactional information encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks. (Sales receipt, airline ticket, packing slip). Analytical information encompasses all organizational information, and its primary purpose is to support the performance of managerial analysis tasks. (product statistics, trends, sales projections, future growth).
What compiles all of the Metadata about the data elements in a database?
A data Dictonary
What type of database model stores data in logically-related two-dimensional tables?
A relational database model
What are the five common characteristics of High-Quality Information?
Accurate complete consistent Timely Unique
What are the five business advantages of using Relational Databases?
Increased Flexibility Increased Scalability and Performance Reduced Information Redundancy Increased Information Integrity (Quality) Increased Information Security
Flexibility: Does a database support only one or multiple Logical Views?
One logical view
Compare and contrast Static Information and Dynamic Information
Static; includes fixed data incapable of change in the event of a user action. Dynamic; includes data that change based on user actions.
Define a Relational Database Management System and its primary concepts
allows users to create, read, update, and delete data in a relational database. Although the hierarchical and network models are important, this text focuses only on the relational database model.
What is a Data-Driven Website?
an interactive website kept constantly updated and relevant to the needs of its customers using a database
Data Record
complete set of related information for an individual or an item
What is a Database Management System (DBMS)?
creates, reads, updates, and deletes data in a database while controlling access and security.
What do Business-critical integrity constraints enforce? Give examples
enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints. For example, Consider a supplier of fresh produce to large grocery chains such as Kroger.
What is Identity Management?
is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity
What is a Primary Key field?
is a field (or group of fields) that uniquely identifies a given record in a table. In the table RECORDINGS, the primary key is the field RecordingID that uniquely identifies each record in the table.
What is the role of a Foreign Key field?
is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
What does a Query-by-Example (QBE) tool provide?
it provides users graphically design the answer to a question against a database.
What is a database?
maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).
When do Information Integrity issues occur?
occur when a system produces incorrect, inconsistent, or duplicate data.
What is Real-time Information?
provide real-time information in response to requests
Information Integrity. What does a Relational Integrity Constraint NOT allow?
would not allow someone to create an order for a nonexistence customer Provide a markup percentage that was negative or order zero pounds of raw materials from a supplier
Data Redundancy: Does redundancy cause data integrity issues?
yes