Brainscape's Knowledge GenomeTM

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


See full index

Jeck reviewer > dbms > Flashcards

dbms Flashcards

1
Q

➢ Are factual information such as
measurements or statistics about
objects and concepts. We use it for
discussions or as a part of a
calculation.

A

Data

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

➢ Is an organized collection of data,
typically stored in electronic
format. It allows you to input,
organize and retrieve data quickly.

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
  • It is representation of some aspect of
    the real world.
  • Is logical, coherent and internally
    consistent.
  • Is designed, built and populated with
    data for specific purpose.
A

Properties of Database

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

➢ Is a collection of programs that
enables users to create and
maintain databases and control all
access to them.

A

Database Management System

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

➢ Is a programming language used
by all relational databases to
query, manipulate and define data
and to provide access control.

A

SQL Database

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

➢ Is a database designed to allow for
scalable data storage that can
handle. Compared to other
databases, NoSQL databases don’t
use tabular relationships

A

NoSQL Database

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

Programming Apps:

A

▪ mongoDB
▪ redis
▪ Cassandra

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

➢ Were used during 1970s-1990s.
This is a type of database system
that stores data in a single file or
table.
➢ Are basically text files, where
every line contains one records
and fields either have fixed
lengths or are separated with
commas, whitespaces and tabs.

A

Flat Files

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

➢ Were used in during the same era
stored data hierarchically arranged
manner.
o One-to-many Relationship

A

Hierarchical Database Systems

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

➢ Were introduced by Charles
Bachmann.
➢ Unlike hierarchical database
model, this database allows
multiple parent and child
relationships.

A

Network Databases

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

➢ In this database system, data is
stored in tables. The columns of
the table hold attributes of the
data. Each record usually has a
value for each attribute, making it
easy to establish the relationships
between data points

A

Relational Database System

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

➢ Unlike relational databases,
object-oriented databases work in
the framework of real
programming languages like Java
and C++, for example.

A

Object-oriented databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q
  • represents a realworld object such an
    employee or a project.
A

Entity

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

– represents an
o association among entities.

A

Relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q
  • Represents
    data as
    relations, or
    tables.
A

Relational Data
Models

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q
  • Represents
    data as record
    types.
A

Network Data Models

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q
  • Represents as
    a hierarchical
    tree structure
A

Hierarchical Data
Models

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

o Is a framework for
organizing, storing and
managing data.

A

Data Structures

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

– typically work with
predefined queries and
switchboard commands, but also
use query languages to access
stored data.

A

Users

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

concerned with data security and
integrity preventing unauthorized
access, providing backup and
recovery, audit trails, maintaining
the database and supporting user
needs.

A

Database Administrators –

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

A DBMS can support several
related information systems that
provide input to, and require
specific data form the DBMS.

A

Related Information Systems –

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

controls database operations,
including storing, retrieving,
updating and deleting data.

A

Data Manipulation Language –

23
Q

– the complete definition
of database, including
descriptions of all fields, tables,
and relationships

A

Schema

24
Q

– is
also known as a data library or
data archive. This is a general
term to refer to a data set isolated
to be mined for data reporting and
analysis.

A

Physical Data Repository

25
Q

– is person, place, thing or
event for which data is collected and
maintained.

A

Entity

26
Q

– contains a set of
related records that store data about a
specific entity

A

Table or file

27
Q

– also called an attribute, is a
single characteristic or fact about
entity

A

Field

28
Q

– also called tuple (rhymes
with couple), is a set of related fields
that describes once instance, or
occurrence, of an entity, such as one
customer, one order or one product.

A

Record

29
Q

– a field or
combination of fields that
uniquely and minimally
identifies particular member of
an entity

A

. Primary Key

30
Q

– Any field
that could serve as a primary
key

A

Candidate Key

31
Q

– A common field
that exists in more than one
table and can be used to form a
relationship, or link, between
the tables

A

Foreign Key

32
Q

– A field or
combination of fields that can
be used to access or retrieve
records.

A

Secondary Key

33
Q

– a set of rules
that avoids data inconsistency and
quality problems.

A

Referential Integrity

34
Q

– abbreviated 1:1, exists
when exactly one of the second
entity occurs for each instance of the
first entity.

A

One-to-one

35
Q

– abbreviated 1:M,
exists when one occurrence of the
first entity can relate to many
instances of the second entity, but
each instance of the second entity
can associate with only one instance
of the first entity.

A

One-to-many

36
Q

– abbreviated M:N,
exists when one instance of the first
entity can relate to many instances if
the second entity, and one instance of
the second entity can relate to many
instances of the first entity.

A

Many-to-many

37
Q

➢ Describes the numeric
relationship between two entities
and shows how instances of one
entity relate to instances of
another entity.

A

Cardinality

38
Q
  • is the process of
    creating table designs by
    assigning specific fields or
    attributes to each table in
    database.
    o It involves applying set of
    rules that can help you
    identify and correct inherent
    problems and complexities in
    your table designs.
A

Normalization

39
Q

o Starts with the name of the
table, followed by a
parenthetical expression that
contains the field names
separated by commas

A

Standard Notation Format

40
Q

o Is a set of one or more fields
that can occur any number of
times in a single record, with
each occurrence having
different values.

A

Repeating Group

41
Q

– an integrated
of collected data that can include
seemingly unrelated information, no
matter where it is stored in the
company.

A

Data Warehousing

42
Q

– looks for meaningful
data patterns and relationships in
large amounts of data.

A

. Data Mining

43
Q

– refers to data that
a user can view, understand, and
access, regardless of how or where
that information actually is organized
or stored

A

Logical Storage

44
Q

– is strictly
hardware-related because it involves
the process of reading and writing
binary data to physical media such as
a hard drive, CD-ROM, or networkbased storage device.

A

Physical Storage

45
Q

➢ A data model in which the data is
organized in relations (tables).
This is the model implemented in
most modern database
management systems.

A

Relational Model

46
Q

➢ Pertaining to or constituting a
relationship between nodes in a
tree data structure in which parent
is one step closer to the root (that
is, one level higher) than the
child.

A

Parent/child Relationship

47
Q

➢ Is a collection of related data
stored in centralized location or
repository.
➢ Typically hosted and managed
using a relational database
management system (RDBMS)

A

Relational Database

48
Q

➢ Is a graphical representation of a
database design.

A

Entity-Relationship Diagram

49
Q

– is the
process of designing
databases.

A

Data modelling

50
Q

– establishes
entities, attributes and relationships.

A

Conceptual Design

51
Q

– defines the
structure of data elements and
establishes relationship among data
elements.
o It adds a layer of detail to the
conceptual design by
defining the columns of data
that need to be included with
each entity

A

Logical Design

52
Q

– describes
database-specific implementation
details and provides a blueprint for
the relational database.
o Includes additional details
about each column within an
entity.

A

Physical Design

53
Q

Combines data into a single table to
remove external relationships and
dependencies. Though this approach can
speed up SQL queries, it also very often
results in redundant or duplicated data
throughout the database.

A

Denormalization

Jeck reviewer (16 decks)

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