Back to AI Flashcard MakerInformation Technology /BA18 Final Exam Chapter 11
BA18 Final Exam Chapter 11
This deck covers key concepts from Chapter 11 of the BA18 Final Exam, focusing on database management, data processing, and related technologies.
A column in a database in which customer names are stored would be referred to as a __________.
field
Tap or swipe ↕ to flip
Swipe ←→Navigate
1/26
Key Terms
Term
Definition
A column in a database in which customer names are stored would be referred to as a __________.
field
Fuzzy logic uses __________.
probablity
The field in a table that uniquely identifies each record in that table and relates that table to other tables is called the ___________.
primary key
Ray Kurzweil predicts the Singularity might occur by ____.
2045
A system designed to help keep track of everyday business activities is a(n) _____________.
Transaction Processing System
The world’s largest ERP software company is called
SAP
Related Flashcard Decks
Study Tips
- Press F to enter focus mode for distraction-free studying
- Review cards regularly to improve retention
- Try to recall the answer before flipping the card
- Share this deck with friends to study together
| Term | Definition |
|---|---|
A column in a database in which customer names are stored would be referred to as a __________. | field |
Fuzzy logic uses __________. | probablity |
The field in a table that uniquely identifies each record in that table and relates that table to other tables is called the ___________. | primary key |
Ray Kurzweil predicts the Singularity might occur by ____. | 2045 |
A system designed to help keep track of everyday business activities is a(n) _____________. | Transaction Processing System |
The world’s largest ERP software company is called | SAP |
Big Data refers to | Large amounts of data generated today |
Employees’ last name would usually make an appropriate primary key field. | False |
In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field. | Long text |
________ is the branch of computer science that attempts to create computers that think like humans. | Artificial intelligence |
________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize. | exporting |
In a transaction-processing system (TPS), if the TPS database can be queried and updated while the transaction is taking place, this is called ________ processing. | bath processing |
A(n) ________ check determines whether a required field such as LastName was filled in. | Completeness |
Data ________ means that the data contained in a database is accurate and reliable. | redundancy |
Management information systems (MIS) provide ________ reports, which show conditions that are unusual or need attention from users of the system. | detail |
Management information systems (MIS) provide ________ reports, which show conditions that are unusual or need attention from users of the system. | exception |
When is a flat database sufficient to use when organizing data? | When the data is simple and can be organized in one table |
A customer information table linked to a password table in a business database reflects which type of relationship? One-to-many; Many-to-one; Many-to-many; One-to-one A process to ensure that data in a database is organized most efficiently is called centralization. data staging; normalization; integration; Which of the following is not considered metadata? Data type; Database name; Field name; Field size; Data captured as users navigate through a website is called staged data; web-user data; time-variant data | One-to-one |
A process to ensure that data in a database is organized most efficiently is called | normalization |
Which of the following is not considered metadata? | Database name |
Data captured as users navigate through a website is called | stage data |
The type of database that would be best to store and organize data with feature and measure attributes is which of the following? | Multidimensional database |
Which of the following is used to create a subset of data that matches certain criteria and that can be saved for future reference or use? | Query |
Which of the following data-mining techniques is used to create charts and dashboards? | Visualization |
Unnecessary duplication of data in a database is referred to as | Data redundancy |
Which of the following is a method of inputting data into a transaction-processing system while the transaction is taking place? | Real-time processing |