CCE104 Flashcards
review
1
Q
Raw facts;Building blocks of information
A
Data
2
Q
Not yet been
processed to reveal the
meaning
A
Raw data
3
Q
Generation, storage, and
retrieval of data
A
Data management
4
Q
Produced by processing data ;Reveals the meaning of data; Enables knowledge creation; Should be accurate, relevant, and
timely to enable good decision
making
A
Information
5
Q
Shared, integrated computer structure that stores a
collection of End-user data and metadata
A
Database
6
Q
Raw facts of interest to end user
A
End-user data
7
Q
Metadata
A
Data about data, which the end-user data are
integrated and managed
8
Q
Collection of programs; Manages the database structure; Controls access to data stored in the database
A
Database management system (DBMS)
9
Q
type of database that Supports one user at a time like desktop database
A
Single-user database
10
Q
type of database that Runs on PC
A
Desktop database
10
Q
Type of database that Supports a small number of
users or a specific department
A
Workgroup databases
11
Q
Type of database that Created and maintained using
cloud data services that provide defined
performance measures for the database
A
Cloud database
11
Q
Type of database that Contains a wide
variety of data used in multiple disciplines
A
General-purpose databases
11
Q
Type of database that Data is located at a single
site
A
Centralized database
11
Q
Type of database that Data is distributed across
different sites
A
Distributed database
11
Q
Type of database that Supports multiple users at the
same time such as workgroup database and enterprise database
A
Multiuser database
12
Q
Type of database that Supports many users across
many departments
A
Enterprise database
13
Q
Captures and processes business
data to generate information that support decision
making
A
Business intelligence
13
Q
Type of database that Contains data
focused on specific subject areas
A
Discipline-specific databases
14
Q
Type of database that Stores historical data and
business metrics used exclusively for tactical or
strategic decision making
A
Analytical database
15
Q
Enable retrieving, processing, and modeling data from the
data warehouse
A
Online analytical processing (OLAP)
15
Q
Type of database that Designed to support a
company’s day-to-day operations
A
Operational database
16
Q
Stores data in a format optimized for
decision support
13
A
Data warehouse
17
Q
Facilitates data management; Generates accurate and valuable information
A
Well-designed database
17
Qualitative data. It cannot be
processed and analyzed using conventional tools and
methods.
Images, videos, documents
Unstructured data
18
Quantitative data. Highly
organized and easily understood by machine
language
Numbers, text, dates
Structured data
19
Focuses on the design of the database structure that
will be used to store and manage end-user data
Database Design
20
Accomplished through a system of file folders and filing cabinets
Manual File Systems
21
Data processign(DP) specialist: created a computer-based system that would track data and produce required reports
Computerized File Systems
22
Includes spreadsheet programs such as microsoft excel
file system redux: modern end-use productivity tools
23
Access to a file is dependent
on its own structure
All file system programs are modified to conform to a
new file structure
Structural dependence
24
File structure is changed
without affecting the application’s ability to access
the data
Structural independence
25
Data access changes when data storage characteristics
change
Data dependence
26
Data storage characteristics is changed without
affecting the program’s ability to access the data
Data independence
27
Unnecessarily storing same data at different places
Data Redundancy
28
Scattered data locations
Increases the probability of having different versions of
the same data
Islands of information
29
Poor data security; Data inconsistency; Increased likelihood of data-entry errors when
complex entries are made in different files
Data Redundancy Implications
30
Update anomalies, insertion anomalies and deletion anomalies are types of?
Type of data anomaly
31
is like creating a blueprint for how
data should be organized and structured. It’s a critical
step in designing a database.
Data modeling
31
Develops when not all of the
required changes in the redundant data are made
successfully
Data anomaly
32
help
organize and manage data efficiently. Think of a
DBMS like a smart library system where you can
quickly find and use books (data) without having to
search through piles of papers
Database Management Systems (DBMS)
33
often
had problems like duplication, data inconsistency,
and difficulty in retrieving information. DBMS
eliminates most of these issues by centralizing and
standardizing how data is stored and accessed
Traditional file systems
34
is like a guidebook or glossary for
your database. It keeps track of all the details about
the data—like what each piece of data means, how
it’s organized, and how it’s used
data dictionary
35
is about making sure
this guidebook is accurate and up to date, so everyone
understands the data correctly.
34
Data dictionary management
36
involves organizing and
saving data efficiently so it takes up the right amount
of space and can be easily accessed when needed. It’s
like managing a warehouse where you store things in
a way that makes them easy to find and retrieve.
Data storage management
37
is how you display or present that
data to users, often in the form of reports, charts, or
graphs, so they can understand it easily.
Data presentation
37
is the process of converting
data from one format or structure into another so that
it’s easier to work with or analyze. Think of it like
changing ingredients in a recipe to suit a different
dish.
Data transformation
38
ensures that your data is safe
from unauthorized access or breaches. It’s like
putting locks on doors and setting up alarms to
protect valuable information.
Security management
39
ensures that many people
can use the same database at the same time without
interfering with each other. It’s like having multiple
keys to a shared office, where everyone can enter and
work, but with rules that prevent them from
accidentally messing up each other’s work.
Multiuser access control
40
involves making copies of
your data regularly so that if something goes wrong
(like a system crash or data loss), you can restore it.
It’s like saving a backup of your important files on a
separate hard drive.
Backup management
41
is the process of restoring
data from these backups if you ever lose the original
data. It’s like retrieving your files from the backup
when your computer crashes
Recovery management
42
are like the languages you
use to communicate with a database. The most common
one is SQL (Structured Query Language), which lets you
ask the database to give you certain information, add new
data, or make changes to the data.
Database access languages
43
ensures that the data in
your database is accurate, consistent, and reliable. It’s
like keeping a clean and organized filing system
where all the documents are up-to-date and correctly
filed, so you can trust the information you find.
Data integrity management
44
are the ways in
which databases can connect and communicate with
other systems, software, or devices. It’s like the
different methods you use to connect your phone to
the internet—through Wi-Fi, Bluetooth, or data
cables. These interfaces make sure the database can
easily send and receive information to and from other
systems.
Database communication interfaces
44
are tools
that allow different software programs to talk to each
other. When it comes to databases, an API lets a program
(like a website or app) connect to the database, send or
receive data, and perform tasks, all without needing to
know how the database works inside.
Application Programming Interfaces (APIs)
45
These are basic databases where data is
stored in a plain text format, like a spreadsheet. Each line
is a record, and each record is made up of fields separated
by a delimiter (like a comma)
Flat Files
46
these databases organize
data in a tree-like structure, with records having a parent-
child relationship. Think of it like a family tree, where
each record can have one parent and many children.
Hierarchical Databases
47
Similar to hierarchical databases,
but more flexible. Records can have multiple parent and
child relationships, forming a graph structure rather than
a strict tree
Network Databases
48
These databases store data in
tables with rows and columns. They use Structured Query
Language (SQL) to manage and query the data. Tables
can be related to each other, making it easier to manage
large amounts of structured data
Relational Databases
49
these databases store
data as objects, similar to how objects are defined in
programming languages like Java or C++. They are
designed to handle complex data and relationships
Object-Oriented Databases
49
is with
capital cities. One country (or state) has only one capital city, and
one capital city belongs to only one country (or state).
Two tables with information about countries and capital cities
connect in a database using a primary key. For example, when
added to the country table, the unique ID of a capital city (its
primary key) becomes a foreign key, creating a relationship.
One-to-One Relationship Example
50
A combination of
relational and object-oriented databases. They use the
table structure of relational databases but allow the
storage of complex data types like objects
Object-Relational Databases
51
This technology is used for
storing and managing large volumes of historical
data. Data warehouses collect data from different
sources, allowing for complex queries and analysis,
often used in business intelligence.
Data Warehousing
52
is the connection between a mother
and children. A mother can have many kids, but every child belongs to one
mother only.
A database containing two tables with information about mothers and children
connects using a primary key. When added to the child table, the unique ID
from a mother becomes a foreign key. Different children can have the same
mother.
One-to-Many Relationship Example
53
exists between books and authors. For example,
a single book can have multiple authors. Likewise, a single author can have
numerous books.
If there is a table containing books and another with authors, the best way to
establish the relationship between the two is through a new table.
Many-to-Many Relationship Example
54
the standard
language used to manage and manipulate databases,
and MySQL is one of the systems that uses it.
SQL (Structured Query Language)
55
popular database management system
that uses SQL as its language for interacting with
databases.
MySQL
56
Is a programming language for storing and processing
information in a relational database. A relational
database stores information in tabular form, with
rows and columns representing different data
attributes and the various relationships between the
data values.
Structured Query Language
57
used to store, retrieve, and manage data in a
database.
SQL
57
database management system that
manages data as a collection of tables in which all
relationships are represented by common values in
related tables
relational database management
systems (RDBMS)
58
A set of schemas that constitute the description of a
database
Catalog (Description)
59
The structure that contains descriptions of objects
created by a user (base tables, views, constraints)
Schema ( Database Structure)
60
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
Transaction Control Language (TCL)
Categories of SQL Language
61
Command lists: Create, drop, alter, rename, truncate are
DDL
62
Command lists: Select, insert, update, delete are
DML
63
Command lists: grant and revoke
DCL
64
Command list: commit and rollback
TCL
