Brainscape's Knowledge GenomeTM

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


See full index

SCTS Module 1-2 > Module 1 - 2 > Flashcards

Module 1 - 2 Flashcards

1
Q

Implies familiarity, awareness, and understanding of information as it applies to an environment.

A

Knowledge

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

A shared, integrated computer structure that houses a collection of related data.

A

Database

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

Two types of data within a database

A

The end-user (raw facts) and metadata

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

known as data about data

A

Metadata

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

A process that focuses on data collection, storage, and retrieval.

A

Data Management

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

Data processing (DP) specialist created a computer-based system to 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
7
Q

Used to define and store data

A

Field

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

Access to a file is dependent on it’s own structure

A

Structural Dependence

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

file structure is changed without affecting the applications ability access to data

A

Structural Independence

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

Consist of logically related data stored in a single data repository

A

Data base system

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

Raw facts or facts that have not yet been processed to reveal its meaning to the end user

A

Data

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

The result of processing raw data to reveal its meaning.

A

Information

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

The collection of programs that manages the database structure and controls access to the data stored in the database.

A

Data base management system (DBMS)

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

A collection of related records

A

File

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

accomplished through file folders and filing cabinets

A

Manual File system

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

introduces the spreadsheet programs such as Microsoft excel

A

File system redux

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

has little meaning unless organized in some logical manner

A

Data

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

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

A

Field

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

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

A

Database system environment

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

it refers to all systems physical devices

A

Hardware

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

The operating systems(OS) and DBMS software programs are types of what?

A

Software

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

This component includes all users of the database system

A

People

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

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

A

Procedure

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

It covers the collection of facts stored in the database

A

Data

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

stores the definition of data elements and their relationship

A

Data dictionary management

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

Performance tuning ensure efficient performance

A

Data storage management

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

Data is formatted to conform to logical expectations

A

Data transformation and presentation

28
Q

Enforces user security and data privacy

A

security management

29
Q

First step in designing data base

A

Data modeling

30
Q

The process of creating a specific data model for a determined problem domain

A

Data modeling

31
Q

Category of relationship, link between entity types

A

Relationship Type

32
Q

A data model that describes relationships (1:1, 1:M, and M:N) among entities at the conceptual level with the help of ER diagrams.

A

Entity relationship (ER) model (ERM)

33
Q

A row in a rational table

A

entity instance (entity occurrence)

34
Q

A collection of like entities

A

Entity Set

35
Q

The type of relationship between entities classification include 1:1, 1:M, M:N

A

Connectivity

36
Q

used and is considered to present a more detailed way of representing entities and relationships.

A

Chen notation

37
Q

A representation of the entity relationship diagram (ERD) using a three pronged symbol to represent the “many” sides of the relationship

A

Crows foot notation

38
Q

The set of symbols used to create class diagrams

A

Class diagrams notation

39
Q

association among two or more entities that are used by data models. One entity instance is associated with many instances of the related entity

A

one-to-many relationship (1:M, 1..*)

40
Q

Associations among two or more entities in which one occurrence of an entity is associated with many occurrences of a related entity and one occurrence of the related entity is associated with many occurrences of the first entity.

A

many to many relationship (M-N or ..)

41
Q

A representation, usually graphic, of a complex “real-world” data structure.

A

Data Model

42
Q

Are used in the database design phase of the Database Life Cycle.

A

Data Model

43
Q

Importance of data models

A
  • Facilitate interaction among the designer, the application programmer, and the end user.
  • End-users have different views and needs for data.
  • Data model organizes data for various users.
  • Data model is an abstraction
44
Q

A person, place, thing, concept, or event for which data can be collected and stored. (often corresponds to a table).

A

Entity

45
Q

A characteristic of an entity, object, or relationship type.

A

Attribute

46
Q

Equivalent of fields in file systems

A

Attribute

47
Q

describes an association among entities. (corresponds to PK-FK equivalencies in related tables).

A

Relationship Instance

48
Q

A diagram that depicts an entity relationship model’s entities, attributes, and relations.

A

Entity-relationship Diagram (ERD)

49
Q

one entity instance is associated with only one instance of the related entity.

A

one-to-one relationship (1:1)

50
Q

A restriction placed on the data. Expressed in the form of rules.

A

Constraints

51
Q

A brief, precise, and unambiguous descriptions of policies, procedures, or principles within a specific organization.

A

Business Rules

52
Q

Description of operations to create and enforce actions within an organization’s environment.

A

Business Rules

53
Q

Describe characteristics of data as viewed by the company.

A

Business Rules

54
Q

An early database model whose basic concepts and characteristics formed the basis for subsequent database development.

A

Hierarchical Model

55
Q

This model is based on an upside-down tree structure in which each record is called a segment. The top record is the root segment. Each segment has a 1:M relationship to the segment directly below it.

A

Hierarchical Model

56
Q

the equivalent of a file system’s record type

A

Segment

57
Q

was created to represent complex data relationships more effectively than the hierarchical model, to improve database performance, and to impose a database standard.

A

Network model

58
Q

conceptual organization of entire database as viewed by the DB Admin.

A

Schema

59
Q

Portion of the database seen by the application programs.

A

Subschema

60
Q

defines the environment in which data can be managed and is used to work with the data in the database.

A

Data Manipulation Language (DML)

61
Q

enables the administrator to define the schema components.

A

Data Definition Language (DDL)

62
Q

Developed by E. F. Codd of IBM in 1970, this model is based on mathematical set theory and represents data as independent relations.

A

Relational Model

63
Q

This is a model where each relation (table) is conceptually represented as a two dimensional structure of intersecting rows and columns. The relations are related to each other through the sharing of common entity characteristics (values in columns).

A

Relational Model

64
Q

A logical construct perceived to be a two dimensional structure composed of intersecting rows (entities) and columns (attributes) that represents an entity set in the relational model.

A

Table (relation)

65
Q

Also known as tuple in the relational model.

A

Table Row

SCTS Module 1-2 (1 decks)

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