Learning Unit 3: Database Systems

What are key aspects of organizing data and information?

Data management and modelling.

What is the most common type of database?

Relational database.

What does a relational database consist of?

A series of related tables.

What is one advantage of using databases?

Improved strategic use of corporate data.

What is one disadvantage of using databases?

More complexity in development.

What is a primary key in a database?

A field that is defined to be unique for each entity.

What is the purpose of a data model or database schema?

To list all the tables in the database along with their fields and keys.

What are the types of binary relationships in database design?

One to one, one to many, and many to many.

What is Data Definition Language (DDL)?

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

What is stored in a data dictionary?

Meta data, which provides a detailed description of all the data used in the database.

What is a data manipulation language (DML)?

Commands used to manipulate and query the database.

What is the role of a database administrator (DBA)?

To plan, design, create, operate, secure, monitor, and maintain databases.

What is a data warehouse?

A database that collects business information from multiple sources.

What does data mining involve?

The automated discovery of patterns and relationships in a data warehouse.

What is business intelligence (BI)?

The process of analyzing information to positively impact business strategy or operations.

What is an object-oriented database?

A database that stores both data and its processing instructions.