Chapter 1 - AI Flashcards
(9 cards)
Define the difference between data and information
Data refers to raw facts and figures, while information is processed data that is meaningful and useful.
Data becomes information when it is organized and interpreted.
What is a database?
A database is an organized collection of data that can be easily accessed, managed, and updated.
Databases are structured to allow efficient data retrieval and manipulation.
What are the several types of databases?
The several types of databases include:
* Relational databases
* NoSQL databases
* Object-oriented databases
* Distributed databases
* Data warehouses
Each type serves different needs based on data structure and access requirements.
Why are databases valuable assets for decision making?
Databases provide accurate, timely, and relevant information that aids in informed decision making.
Access to reliable data enhances strategic planning and operational efficiency.
Explain the importance of database design
Database design is crucial because it determines how data is stored, organized, and accessed, impacting performance and scalability.
A well-designed database minimizes redundancy and ensures data integrity.
How did modern databases evolve from file systems?
Modern databases evolved from file systems through the introduction of structured data management, allowing for better data relationships and query capabilities.
File systems lacked the efficiency and flexibility that databases provide.
Identify flaws in file system data management
Flaws in file system data management include:
* Data redundancy
* Lack of data integrity
* Difficulty in data retrieval
* Poor data security
These issues lead to inefficiencies and increased risk of data errors.
Outline the main components of the database system
The main components of a database system include:
* Database engine
* Database schema
* Query processor
* User interface
* Database management system (DBMS)
Each component plays a role in data storage, manipulation, and accessibility.
Describe the main functions of a database management system (DBMS)
The main functions of a DBMS include:
* Data storage, retrieval, and update
* User access control
* Data integrity maintenance
* Backup and recovery
* Query processing
A DBMS acts as an intermediary between users and the database.
