Principles of Information Systems: Databases, Data Management, and Relational Models

What is data modeling?

A tool used to design a database, which can occur at the organizational or specific application level.

What is joining in the context of relational databases?

Connecting two or more tables through one or more common fields.

What are the key responsibilities of the data governance team?

Developing policies, defining processes for data storage and protection, and establishing standards for data access.

What do ER diagrams help ensure?

They help ensure that the logical structure of application programs is consistent with the data relationships in the database.

What is the purpose of user queries in a relational database?

To perform operations such as adding, changing, or deleting data and selecting, projecting, and joining existing data in tables.

What is the purpose of security management in a DBMS?

To protect data against unauthorized access, physical damage, and operating system failure.

What is the importance of security in data management?

To protect data from unauthorized access and breaches.

What is the role of business leaders in data governance?

To provide leadership and actively participate in ensuring data can be trusted and used effectively.

What is the role of backup and recovery in a DBMS?

To provide services that allow backup copies of the database to be made.

What is the primary purpose of a database?

To provide timely, accurate, and relevant information for decision-making.

What is data lifecycle management (DLM)?

A policy-based approach to managing the flow of data from acquisition to deletion.

Who is a database administrator (DBA)?

A skilled IS professional responsible for defining data needs, crafting databases, testing, monitoring performance, and ensuring data security.

What is Structured Query Language (SQL)?

A special-purpose programming language for accessing and manipulating data stored in a database.

What is a foreign key?

A field in one table that refers to the primary key in another table.

What is a primary key in a database?

A field or set of fields that uniquely identifies a record in a database table.

What is an entity in database design?

A person, place, or thing for which data is collected and maintained.

What is the role of a data steward?

A non-IS employee responsible for managing critical data entities, maintaining reference data, and analyzing data quality.

What is an attribute in database design?

A characteristic of an entity, such as employee number or hire date.

What is a data definition language (DDL)?

A collection of instructions and commands used to define and describe data and relationships in a specific database.

What is a data dictionary?

A collection of metadata that describes the data, format, structure, and relationships in the database.

What is an entity-relationship (ER) diagram?

A data model used to analyze and communicate data needs at the individual project or application level.

What is database as a service (DaaS)?

A model where the database is stored on a service provider's servers and accessed by the service subscriber over the Internet.

What are the benefits of quality data and information?

Accessible, accurate, complete, economical, relevant, reliable, secure, timely, and verifiable.

What is enterprise data modeling?

An approach that investigates organizational needs at a strategic level before examining specific data for departments.

How does quality data enhance innovation?

By improving efficiency, product/service quality, and customer experience.

How can databases help improve customer service?

By providing accurate and timely information to address customer needs.

What does the enterprise data model identify?

Data entities, attributes, standard definitions, data length and format, valid value domains, and business rules.

What does it mean for data to be reliable?

Data can be trusted to accurately represent the real-world conditions it is intended to reflect.

What is the difference between data cleansing and data validation?

Data cleansing corrects inaccurate data by cross-checking it against a validated data set, while data validation checks data for correctness and completeness.

What does the term 'economical' refer to in the context of quality data?

Data should be cost-effective to collect and manage.

What is meant by 'metadata'?

Data that describes other data.

What are the functions associated with data management according to the Data Management Association International?

Functions include data acquisition, certification, storage, security, and processing.

What is the relationship between data management and business opportunities?

Effective data management helps identify and capitalize on new business opportunities.

What does projecting involve in data manipulation?

Eliminating columns in a table.

What does selecting involve in data manipulation?

Eliminating rows according to certain criteria.

What is the impact of data errors on employee productivity?

Employees spend time correcting errors instead of focusing on core missions.

What is the purpose of data control language (DCL)?

It allows a database administrator to manage user privileges.

What does data manipulation language (DML) allow users to do?

It allows users, administrators, and applications to modify database data.

What does data enhancement do?

It augments the data in a database by adding related information.

What role does data management play in an organization?

It defines processes for obtaining, certifying, storing, securing, and processing data.

What is data governance?

It defines roles, responsibilities, and processes for ensuring data trustworthiness and usability.

What is the benefit of using DaaS?

It eliminates the need for installation, maintenance, and monitoring of in-house databases.

What is the significance of timely data?

It ensures that information is relevant and can be acted upon promptly.

What is the impact of quality data on customer satisfaction?

It facilitates a personalized approach to customer interactions.

What does the GRANT command do in SQL?

It is used to define user privileges.

What is the role of transaction control language (TCL)?

It is used to maintain the integrity and accuracy of data by committing changes to the database or rolling back changes made in error.

What is the significance of adhering to data dictionary standards?

It makes it easy to share data among organizations.

What is the advantage of linking tables in a relational database?

It reduces data redundancy by allowing tables to be connected through common fields.

How does quality data improve decision making?

It removes guesswork and risk taking.

What does the database approach to data management involve?

Multiple information systems sharing a pool of related data.

What is a database management system (DBMS)?

Software used to access and manage a database, providing an interface between the database and its users.

What are the characteristics of a relational database?

Structured data organized in tables with relationships between them.

What is data cleansing?

The process of detecting and correcting or deleting incomplete, incorrect, inaccurate, or irrelevant records in a database.

What does a database schema define?

The tables, the fields in each table, and the relationships between fields and tables.