Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

2nd year, 2nd Sem > DCIT55 (LEC) | Midterms > Flashcards

DCIT55 (LEC) | Midterms Flashcards

(110 cards)

Start Studying
1
Q

a high-level function that is responsible for the overall management of data resources in an organization, including maintaining corporate wide definitions and standards

A

data administration (DA)

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

they arethe rules for structuring information collected by the ID system which facilitate semantic interoperability

A

data standards

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

techniques and methods used to handle conflicts that arise when integrating data

A

data conflict resolution (DCR)

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

a collection of related information maintained over a network on various servers

A

information repository (IR)

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

the promotion of a company’s objectives, products, and services to employees within the organization

A

internal marketing (IM)

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

the purpose is to increase employee engagement with the company’s goals and foster brand advocacy

A

internal marketing (IM)

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

a technical function that is responsible for physical database design and for dealing with technical issues, such as security enforcement, database performance and back up and recovery

A

database administration (DBA)

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

it refers toa group of activities DBAs perform to ensure databases operate smoothly and efficiently- hardware & software

A

database performance tuning

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

it involves accelerating query response, improving indexing, deploying clusters, and reconfiguring OSes

A

database performance tuning

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

a process forconceptualizing the relationships between different types of information in an organization

A

enterprise data modeling

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

process of collecting, organizing, analyzing, and applying data to your business strategies

A

marketing data management

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

it establishes the process used to identify, prioritize, precisely formulate, and validate the data needed to achieve business objectives

A

data requirements

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

it describes a problem, system requirements describe the characteristics of system concepts which are potential solutions to the problem

A

operational requirement

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

a collection of metadata such as object name, data type, size, classification, andrelationships with other data assets

A

data dictionary

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

data library or data archive

A

data repository

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

it isthe process of deciding how to arrange the attributes of the entities in a given business environment into database structures

A

logical database design

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

it can have one or more attributes, which are properties or characteristics that describe the entity

A

entity

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

it isthe end user’s view of the data

A

external model

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

a representation of the database as seen by the DBMS

A

internal model

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

it isthe accuracy, completeness, and reliability of data

A

data integrity

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

it isa control that rejects invalid data inputs, prevents unauthorized data outputs, and protects data and programs against accidental or malicious tampering

A

integrity control

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

it isthe process of copying and loading data or data sets from a source file, folder or application to a database or similar application

A

database loading

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

a procedure that allows you to submit project change requests

A

change-control procedure

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

software with source code that anyone can inspect, modify, and enhance

A

open-source software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
a document that states the rights of the developer and user of a piece of software (Maria DB, My SQL)
software license
26
it is based on the Open Source Chromium web browser project
google chrome browser
27
The Google Chrome browser is based on the
Open Source Chromium web browser project
28
it is a free and open-source internet browser that offers numerous plugins which can be accessed with a single mouse click
mozilla firefox
29
Data policies, procedures and standards
DA
30
Planning
DA
31
Data Conflict Resolution
DA
32
Managing the Information Repository
DA
33
Internal Marketing
DA
34
Selecting DBMS and related software tools
DBA
35
Installing and upgrading the DBMS
DBA
36
Tuning database performance
DBA
37
Improving database query processing performance
DBA
38
Managing data security, privacy, and integrity
DBA
39
Data backup and recovery
DBA
40
Develop corporate database strategy/policies
DA
41
Develop enterprise model (information architecture)
DA
42
Develop cost/benefit models
DA
43
Develop database environment/select technologies
DA
44
Develop a market data administration plan
DA
45
Define and model data requirements (conceptual)
DA
46
Define and model business rules
DA
47
Define operational requirements
DA
48
Resolve requirements conflicts
DA
49
Maintain corporate data dictionary/repository
DA
50
Perform logical database design
DA/DBA
51
Design external model (subschemas)
DBA
52
Design internal (physical) models
DBA
53
Design integrity controls
DBA
54
Establish security controls
DBA
55
Supervise database loading
DBA
56
Specify test procedures
DBA
57
Perform logical database design
DBA
58
Develop application programming standards
DBA
59
Establish procedures for backup and recovery
DBA
60
Conduct user training
DBA
61
Backup and Recover Database
DBA
62
Upgrade DBMS
DBA
63
Monitor database
DBA
64
Tune and reorganize databases
DBA
65
Resolve access conflict
DBA
66
Tune and rewrite queries
DBA
67
Enforce standards and procedures
DBA
68
Support Users
DBA
69
Implement change-control procedures
DBA/DA
70
Plan growth and change
DBA/DA
71
Evaluate new technology
DBA/DA
72
a free DBMS source code software that provides the core functionality of a compliant DBMS
Open-source DBMS
73
SQL Data Types
numeric date/time character/string binary
74
statements are used for managing data in database
data manipulation language (DML)
75
sample of DML commands
SELECT, INSERT, UPDATE, and DELETE
76
it retrieves data from database
SELECT statement (SELECT column/s FROM tablename;)
77
it inserts data into a table
INSERT statement (INSERT INTO tablename (parameters) VALUES (parameters);)
78
it updates existing data within a table
UPDATE statement
79
it deletes all records from a database (use where clause to specify deletion)
DELETE statement
80
how to display databases
show databases;
81
it is the process of reorganizing data in a database so that it meets two basic requirements
normalization
82
it happens when you apply for a job and you are tasked to design a database based on Excel files/documents containing data
normalization
83
repetitive data and anomalies
unnormalized database
84
these are mostly plagued with repetitive data and anomalies
normalization
85
relationship between primary key and foreign key
ER diagram
86
it is important for many reasons, but chiefly because it allows databases to take up as little disk space as possible, resulting in increased performance
normalization
87
it is also known as data normalization
normalization
88
data normalization is also known as
normalization
89
it usually involves dividing large tables into smaller (less redundant) tables and defining relationships between them
data normalization
90
who developed the data normalization
E.F. Codd, 1972 (Edgar F. Codd)
91
deleting rows may cause a loss of data that would be needed for future rows
deletion anomaly
92
it exists when certain attributes are lost because of the deletion of other attributes
delete anomaly
93
adding new rows forces the user to create duplicate data
insertion anomaly
94
it occurs when certain attributes cannot be inserted into the database without the presence of other attributes
insert anomaly
95
changing data in a row forces changes to other rows because of duplication
modification anomaly
96
it exists when one or more instances of duplicated data are updated, but not all
update anomaly
97
unique identifier
primary key
98
children of the primary key
non-key attributes (mga hindi pk)
99
attribute to find out values assigned to other attributes in the same row
determinant (this is usually the PK; denoted as capital letters)
100
look to the primary key for reference
dependent (other fields aside from PK; denoted as small letters)
101
it is where the relationships between PK and FK is deemed important
first normal form (1NF)
102
- Identify a unique primary key - Have just one set of values per column - Have just one set of values per cell - Eliminate repeating data
first normal form (1NF)
103
made of > 1 column
composite key
104
non-key that depends on part of the composite key
partial dependency
105
composite PK (2 or more PK)
composite key
106
- Is in 1NF - Eliminate Partial Dependency - Non-Key columns must depend on all keys of the composite key
second normal form (2NF)
107
all non-key attributes must be dependent to
composite key
108
dependent to only of the PKs
partial dependencies
109
non-key attribute that is related or dependent to another non-key attribute
transitive relationship
110
still consider the logic
logical reasoning

2nd year, 2nd Sem (11 decks)

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