Copyright

Database & Data Management Flashcards

Database & Data Management Flashcards
1/23 (missed) 0 0
Create Your Account To Continue Studying

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access
ORDER BY (in SQL)
SQL statement used to sort data by specified parameter
Got it
Structured Query Language (SQL)
Used to construct database queries
Got it
The most widely used form of database management systems (DBMS)
Relational
Got it
The parent-child data relationship is found in the _____ database management systems (DBMS) model.
Hierarchcal
Got it
Object-oriented DBMS
The database management systems (DBMS) model most appropriate for use with different data types such as audio and visual.
Got it
Relational DBMS
A database management system model in which data is organized into multiple tables
Got it
Network DBMS
A database management system model in which data can be related to many other data
Got it
Hierarchical DBMS
A database management system model in which some data is subordinate to other data.
Got it
Flat File
The most basic database management system (DBMS) model
Got it
Field (in a database)
A column in a database table that represents a single value for each record. A field is also known as an attribute.
Got it
Data
Individual pieces of information such as name, address, and phone used to create a record.
Got it
23 cards in set

Flashcard Content Overview

Data management and database management systems help make data storage, retrieval, and modification simple and efficient for organizations. This flashcard set covers the basics of data and database management. Learn about the different elements that make up a database, how database information is used to drive business decisions, and the role the database administrator has in ensuring a company's data is secure, accurate, and available.

Front
Back
Data
Individual pieces of information such as name, address, and phone used to create a record.
Field (in a database)
A column in a database table that represents a single value for each record. A field is also known as an attribute.
Flat File
The most basic database management system (DBMS) model
Hierarchical DBMS
A database management system model in which some data is subordinate to other data.
Network DBMS
A database management system model in which data can be related to many other data
Relational DBMS
A database management system model in which data is organized into multiple tables
Object-oriented DBMS
The database management systems (DBMS) model most appropriate for use with different data types such as audio and visual.
The parent-child data relationship is found in the _____ database management systems (DBMS) model.
Hierarchcal
The most widely used form of database management systems (DBMS)
Relational
Structured Query Language (SQL)
Used to construct database queries
ORDER BY (in SQL)
SQL statement used to sort data by specified parameter
> (in SQL)
SQL operator used to compare on value to another
< (in SQL)
SQL operator used to compare on value to another
/ (in SQL)
SQL operator used to perform division function
Not (in SQL)
SQL operator used to perform logical functions to display a record if a condition is not true
Benefits of a database management system (DBMS)

1) Provide automated method to create, store, and retrieve data

2) Reduce data redundancy and inconsistency

3) Improve data quality

4) Increase data security and reliability

Relational database
A database management system model in which tables containing different information are connected.
Cloud computing
Storing data on the internet to make it accessible to multiple devices in different locations.
Benefits of cloud computing

1) It is flexible

2) It is easy to grow

3) It provides more efficient use of computer services

4) Lowers costs to build computer services

Predictive analytics
Data mining focused on finding patterns in data to predict trends and behaviors. Also called business analytics.
Data mining
Analyzing data and summarizing it to produce useful information.
Responsibilities of a database administrator

1) Control access to the database

2) Support end users

3) Manage backups and data recovery

4) Secure data

5) Ensure data privacy

6) Ensure data integrity

Encryption
Securing data by converting it to scrambled code using mathematical algorithms before transmission.

To unlock this flashcard set you must be a Study.com Member.
Create your account

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member

Already a member? Log In

Support