click below
click below
Normal Size Small Size show me how
Chapter 7
DAC1
| Question | Answer |
|---|---|
| Information Redundancy | is the duplication of data, or the storage of the same data in multiple places. |
| What are rules that help ensure the quality of information? | Integrity constraints |
| What are the data elements associated with an entity? | Attributes |
| Static Information | Includes fixed data incapable of change in the event of a user action. |
| Two terms representing the smallest or basic unit of information. | Data element Data field |
| Backward Integration | takes information entered into a given system and sends it automatically to all upstream systems and processes. |
| What 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? | Foreign key |
| Logical data structures that detail the relationships among data elements using graphics or pictures are | Data models |
| What allows separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems? | Integration |
| Who is the person responsible for creating the original website content? | Content creator |
| Metadata | Provides details about data. |
| Three accurate statements reflecting the business advantages of a relational database? | Increased information security Reduced information redundancy Increased information integrity |
| Structured query | Language asks users to write lines of code to answer questions against a database. |
| What complies all of the metadata about the data elements in the data model? | Data dictionary |
| What enforces business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints? | Business-critical integrity constraints |
| Data driven website | interactive website kept constantly updated and relevant to the needs of its customers using a database. |
| Integrity constraints | rules that help ensure the quality of information. |
| What defines how a company performs certain aspects of its business and typically results in either a yes/no or true /false answer? | Business rule |
| What takes information entered into a given system and sends it automatically to all downstream systems and processes. | Forward Integration |
| Which system allows users to create, read, update, and delete data in a relational database? | Relational database management system |
| What is a measure of the quality of information? | Information intergrity |
| Primary key | field (or group of fields) that uniquely a given record in a table. |
| Four functions that a database management system can perform on data in a database? | Delete data Read data Create data Update data |
| Three terms that represent the data elements associated with an entity? | Fields Attributes Columns |
| Redundancy | duplication of data or storage of the same data in multiple places. |
| Metadata | provides details about data. |
| Data Field Data Element | smallest or basic unit of information |
| Structured Query Language | asks users to write lines of code to answer questions against a database. |
| Three terms that represent the data elements associated with an entity? | Attributes Fields Columns |
| Forward integration | |
| Data Dictionary | complies all of the metadata about the data elements in the data model. |