Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

1-3 weeks > CCE104 > Flashcards

CCE104 Flashcards

review

1
Q

Raw facts;Building blocks of information

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Not yet been
processed to reveal the
meaning

A

Raw data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Generation, storage, and
retrieval of data

A

Data management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Shared, integrated computer structure that stores a
collection of End-user data and metadata

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Raw facts of interest to end user

A

End-user data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Metadata

A

Data about data, which the end-user data are
integrated and managed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Collection of programs; Manages the database structure; Controls access to data stored in the database

A

Database management system (DBMS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

type of database that Supports one user at a time like desktop database

A

Single-user database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

type of database that Runs on PC

A

Desktop database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Type of database that Supports a small number of
users or a specific department

A

Workgroup databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Type of database that Created and maintained using
cloud data services that provide defined
performance measures for the database

A

Cloud database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Type of database that Contains a wide
variety of data used in multiple disciplines

A

General-purpose databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Type of database that Data is located at a single
site

A

Centralized database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Type of database that Data is distributed across
different sites

A

Distributed database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Type of database that Supports multiple users at the
same time such as workgroup database and enterprise database

A

Multiuser database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Type of database that Supports many users across
many departments

A

Enterprise database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Captures and processes business
data to generate information that support decision
making

A

Business intelligence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Type of database that Contains data
focused on specific subject areas

A

Discipline-specific databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Type of database that Stores historical data and
business metrics used exclusively for tactical or
strategic decision making

A

Analytical database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Enable retrieving, processing, and modeling data from the
data warehouse

A

Online analytical processing (OLAP)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Type of database that Designed to support a
company’s day-to-day operations

A

Operational database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Stores data in a format optimized for
decision support
13

A

Data warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Facilitates data management; Generates accurate and valuable information

A

Well-designed database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Qualitative data. It cannot be
processed and analyzed using conventional tools and
methods.
 Images, videos, documents

A

Unstructured data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Quantitative data. Highly
organized and easily understood by machine
language
 Numbers, text, dates

A

Structured data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Focuses on the design of the database structure that
will be used to store and manage end-user data

A

Database Design

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Accomplished through a system of file folders and filing cabinets

A

Manual File Systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Data processign(DP) specialist: created a computer-based system that would track data and produce required reports

A

Computerized File Systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Includes spreadsheet programs such as microsoft excel

A

file system redux: modern end-use productivity tools

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Access to a file is dependent
on its own structure
 All file system programs are modified to conform to a
new file structure

A

Structural dependence

24
Q

File structure is changed
without affecting the application’s ability to access
the data

A

Structural independence

25
Q

Data access changes when data storage characteristics
change

A

Data dependence

26
Q

Data storage characteristics is changed without
affecting the program’s ability to access the data

A

Data independence

27
Q

Unnecessarily storing same data at different places

A

Data Redundancy

28
Q

Scattered data locations
 Increases the probability of having different versions of
the same data

A

Islands of information

29
Q

Poor data security; Data inconsistency; Increased likelihood of data-entry errors when
complex entries are made in different files

A

Data Redundancy Implications

30
Q

Update anomalies, insertion anomalies and deletion anomalies are types of?

A

Type of data anomaly

31
Q

is like creating a blueprint for how
data should be organized and structured. It’s a critical
step in designing a database.

A

Data modeling

31
Q

Develops when not all of the
required changes in the redundant data are made
successfully

A

Data anomaly

32
Q

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

A

Database Management Systems (DBMS)

33
Q

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

A

Traditional file systems

34
Q

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

A

data dictionary

35
Q

is about making sure
this guidebook is accurate and up to date, so everyone
understands the data correctly.
34

A

Data dictionary management

36
Q

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.

A

Data storage management

37
Q

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.

A

Data presentation

37
Q

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.

A

Data transformation

38
Q

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.

A

Security management

39
Q

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.

A

Multiuser access control

40
Q

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.

A

Backup management

41
Q

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

A

Recovery management

42
Q

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.

A

Database access languages

43
Q

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.

A

Data integrity management

44
Q

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.

A

Database communication interfaces

44
Q

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.

A

Application Programming Interfaces (APIs)

45
Q

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)

A

Flat Files

46
Q

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.

A

Hierarchical Databases

47
Q

Similar to hierarchical databases,
but more flexible. Records can have multiple parent and
child relationships, forming a graph structure rather than
a strict tree

A

Network Databases

48
Q

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

A

Relational Databases

49
Q

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

A

Object-Oriented Databases

49
Q

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.

A

One-to-One Relationship Example

50
Q

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

A

Object-Relational Databases

51
Q

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.

A

Data Warehousing

52
Q

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.

A

One-to-Many Relationship Example

53
Q

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.

A

Many-to-Many Relationship Example

54
Q

the standard
language used to manage and manipulate databases,
and MySQL is one of the systems that uses it.

A

SQL (Structured Query Language)

55
Q

popular database management system
that uses SQL as its language for interacting with
databases.

A

MySQL

56
Q

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.

A

Structured Query Language

57
Q

used to store, retrieve, and manage data in a
database.

A

SQL

57
Q

database management system that
manages data as a collection of tables in which all
relationships are represented by common values in
related tables

A

relational database management
systems (RDBMS)

58
Q

A set of schemas that constitute the description of a
database

A

Catalog (Description)

59
Q

The structure that contains descriptions of objects
created by a user (base tables, views, constraints)

A

Schema ( Database Structure)

60
Q

 Data Definition Language (DDL)
 Data Manipulation Language (DML)
 Data Control Language (DCL)
 Transaction Control Language (TCL)

A

Categories of SQL Language

61
Q

Command lists: Create, drop, alter, rename, truncate are

A

DDL

62
Q

Command lists: Select, insert, update, delete are

A

DML

63
Q

Command lists: grant and revoke

A

DCL

64
Q

Command list: commit and rollback

A

TCL

1-3 weeks (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions