DATABASES

Why are databases important?

Databases ensure organized, accessible, and secure data, supporting business operations and informed decision-making.

How are databases useful?

They store and manage large data volumes efficiently, providing quick access to data for analysis, reporting, and day-to-day operations.

Real company examples of databases?

Amazon uses databases to track inventory and orders; Netflix uses them for personalized content recommendations.

Advantages and disadvantages of databases?

Advantages: Centralized data access, reduces redundancy. Disadvantages: Setup cost and complexity in management.

How do databases add value to organizations?

Databases improve decision-making, data security, and operational efficiency, allowing companies to respond faster to changes and customer needs.

What could happen without a database system?

Data would be disorganized, leading to errors, inefficiencies, security risks, and poor decision-making.

What can be achieved through a database?

Efficient data management, analytics, customer insights, operational automation, and secure data storage.

Example of how databases add solutions to a specific sector?

In healthcare, databases track patient records, ensuring quick, accurate information access for improved patient care.

Why should we invest in databases?

Investing in databases increases productivity, supports scalability, and reduces long-term costs through better data management.

Application example of database usage?

In banking, databases enable secure transaction records, account tracking, and personalized customer service.

What are the problems of managing data resources in a traditional file environment?

Issues include: Data Redundancy and Inconsistency, Program-Data Dependence, Lack of Flexibility, Poor Security, Limited Data Sharing.

What are the major capabilities of database management systems (DBMS)?

Major capabilities include: Data Definition, Data Manipulation & Querying, Data Security & Access Control, Data Integrity, Backup & Recovery.

Why is a relational DBMS so powerful?

Relational DBMSs organize data into tables, use keys, enable normalization, and leverage SQL for powerful queries.

What are the principal tools and technologies for accessing information from databases to improve business performance and decision-making?

Key tools include SQL, OLAP, Data Mining, Dashboards & Reporting Tools, and APIs.

Why are information policy, data administration, and data quality assurance essential for managing the firm’s data resources?

They are essential because they set guidelines for data use, manage data access, and ensure data accuracy for decision-making.