Brainscape's Knowledge GenomeTM

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


See full index

2nd Year- 2nd Sem > Advance Database System > Flashcards

Advance Database System Flashcards

1
Q

Process of describing the data, relationships between the data, and the constraints on the data.

A

Conceptual Database Design

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

Iterative and progressive process of creating a specific data model
for a determined problem domain

A

Data modeling

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

Simple representations of complex real-world data structures

A

Data models

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

Abstraction of a real-world object or event

A

Model

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

focuses on how the database structure 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
6
Q

clearly defined
area within the real-world environment, with a well-defined scope and boundaries that will be
systematically addressed.

A

problem domain

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

represents a particular type of object in the real world, which means an entity
is “distinguishable”—that is, each entity occurrence is unique and distinct

A

entity

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

A characteristic of an entity.

A

attribute

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

describes an association among entities

A

relationship

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

a restriction placed on the data.

A

constraint

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

a brief, precise, and unambiguous description
of a policy, procedure, or principle within a specific organization

A

business rule

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

use data models to communicate with programmers and end
users.

A

Database designers

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

an abstraction of a complex real-world data environment.

A

data model

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

used to identify and define the basic modeling
components within a specific real-world environment.

A

Business rules

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

Raw facts. Not yet been processed to reveal the meaning.

A

Data

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

Produced by processing data. Reveals the meaning of data.

A

Information

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

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

A

Metadata

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

Collection of programs. Manages the database
structure.

A

Database management system (DBMS)

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

serves as the intermediary between the user and the database.

A

DBMS

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

Supports one user at a time

A

Single-user database

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

Supports multiple users at the same time

A

Multiuser database

26
Q

Data is located at a single site.

A

Centralized database

27
Q

Data is distributed across different sites.

A

Distributed database

28
Q

Created and maintained using cloud data services (internet powered),
such as Microsoft Azure or Amazon AWS, that provide defined performance measures
for the database.

A

Cloud database

29
Q

Contains a wide variety of data used in multiple
disciplines.

A

General-purpose databases

30
Q

Contains data focused on specific subject areas.

A

Discipline-specific databases

31
Q

Designed to support a company’s day-to-day operations. It is
also known as an online transaction processing (OLTP) database, transactional
database, or production database

A

Operational database

32
Q

Stores historical data and business metrics used exclusively for
tactical or strategic decision making.

A

Analytical database

33
Q

It is a specialized database that stores data in a format
optimized for decision support.

A

Data warehouse

34
Q

It is a set of tools that work together to provide an advanced data analysis environment for retrieving, processing, and
modeling data from the data warehouse.

A

Online analytical processing (OLAP):

35
Q

In recent times, this area of database application has grown in importance and usage, to the point that it has evolved into its own
discipline:

A

Business intelligence

36
Q

It is a data that exists in its original (raw) state—that is, in the format in which it was collected

A

Unstructured data

37
Q

It is the result of formatting unstructured data to facilitate
storage, use, and generation of information.

A

Structured data

38
Q

refers to the activities that focus on the design of the database structure that
will be used to store and manage end-user data.

A

Database design

39
Q

Raw facts, such as telephone number, birth date, customer name, year-to-
date (YTD) sales value.

A

Data

40
Q

A character or group of characters (alphabetic or numeric) that has a
specific meaning

A

Field

41
Q

A logically connected set of one or more fields that describes a person,
place, or thing.

A

Record

42
Q

A collection of related records.

A

File

43
Q

This anomaly happens when changes are made to a file with
redundant data, and all other related data are not updated properly

A

Update Anomalies

44
Q

This anomaly happens when inserting vital data into the
database is not possible because other data is not already there.

A

Insert Anomalies

45
Q

This anomaly happens when the deletion of unwanted
information causes desired information to be deleted as well.

A

Delete Anomalies

46
Q

refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.

A

database system

47
Q

database system five major parts

A

hardware, software, people, procedures, and data.

48
Q

refers to all of the system’s physical devices.

A

Hardware.

49
Q

Three types of software

A

Operating system software
DBMS software
Application programs and utility software

50
Q

This component includes all users of the database system.

A

People

51
Q

the instructions and rules that govern the design and use of
the database system.

A

Procedures

52
Q

Stores definitions of the data elements and their relationships

A

Data dictionary

53
Q

Ensures efficient performance of the database in terms
of storage and access speed

A

Performance tuning

54
Q

Transforms entered data to conform to required data structures

A

Data transformation and presentation

55
Q

Enforces user security and data privacy.

A

Security management

56
Q

Sophisticated algorithms ensure that multiple users can access the database concurrently without compromising its integrity

A

Multiuser access control

57
Q

Enables recovery of the database after a failure

A

Backup and recovery management

58
Q

Minimizes redundancy and maximizes consistency

A

Data integrity management

59
Q

Lets the user specify what must be done without having to
specify how

A

Query language

60
Q

De facto query language and data access standard supported by the majority of DBMS vendors

A

Structured Query Language (SQL)

61
Q

Accept end-user requests via multiple, different network environments

A

Database communication interfaces

2nd Year- 2nd Sem (6 decks)

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