Database Management & Information Systems Flashcards

What is the primary function of a Database Management System (DBMS)?

Answer: To manage and control databases efficiently

The primary function of a Database Management System (DBMS) is to efficiently manage, store, retrieve, and organize data in a structured manner. It provides an interface for users and applications to interact with the database, ensuring data integrity, security, and concurrent access. A DBMS is fundamental for handling large volumes of information reliably.

Which language is primarily used for managing data in a relational database?

Answer: SQL

SQL (Structured Query Language) is the standard language specifically designed for managing and manipulating data in relational databases. It allows users to perform various operations such as querying data, inserting new records, updating existing ones, and defining database schemas. Its declarative nature makes it highly effective for interacting with relational database management systems.

What is normalization in databases?

Answer: Organizing data to minimize redundancy

Normalization in databases is the process of organizing data to minimize redundancy and improve data integrity. It involves structuring tables and columns according to a series of normal forms, which helps eliminate duplicate data and reduce anomalies during data insertion, update, or deletion. This optimization ensures data consistency and efficient storage.

Which of the following is a characteristic of relational databases?

Answer: Data is stored in table structures with defined relationships

A characteristic of relational databases is that data is stored in a structured format using tables, also known as relations. Each table consists of rows and columns, and relationships between different tables are established through common fields, typically using primary and foreign keys. This tabular structure allows for efficient data organization, querying, and integrity management.

What is the role of an information system in an organization?

Answer: Support business processes and decision making

The role of an information system (IS) in an organization is to collect, process, store, and distribute information to support business operations and facilitate decision-making. IS helps streamline processes, enhance communication, and provide valuable insights for strategic planning and problem-solving. By leveraging data, information systems enable organizations to operate more efficiently and effectively.

Which component ensures security in a database system?

Answer: Security module

The security module in a database system is specifically designed to enforce security policies. It controls user access, manages permissions, and ensures data confidentiality and integrity by preventing unauthorized actions. This component is crucial for protecting sensitive information within the database.

What is data integrity in a database system?

Answer: Ensuring data accuracy and consistency

Data integrity refers to the overall completeness, accuracy, and consistency of data throughout its lifecycle. It ensures that data remains valid and reliable, preventing errors and inconsistencies that could arise from unauthorized access, accidental changes, or system failures. Maintaining data integrity is fundamental for trustworthy database operations.

Which database model is based on objects and classes?

Answer: Object-oriented model

The object-oriented database model organizes data into objects, which are instances of classes. This model supports concepts like encapsulation, inheritance, and polymorphism, allowing for complex data structures and relationships that mirror real-world entities more closely. It contrasts with relational models that use tables and rows.

What is a primary key in a database table?

Answer: A field that uniquely identifies each row in a table

A primary key is a special relational database table column (or combination of columns) designated to uniquely identify each record (row) in that table. It ensures that every row can be distinctly referenced, which is crucial for maintaining data integrity and establishing relationships with other tables. This uniqueness is fundamental for database organization.