Brainscape's Knowledge GenomeTM

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


See full index

complec > Second Handout > Flashcards

Second Handout Flashcards

1
Q

It means repository of data information

A

Cylinder

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

It means process

A

Rectangle

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

It is an organized collection of data

A

Database

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

It is permanent repository of data and information.

A

Database

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

Siya lang ang pwedeng magdelete.

A

Database administrator

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

Database systems process and organize large amount of data in __________.

A

Electronic Form

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

Group of programs to manage database.

A

Database Management System (DBMS)

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

Provides an interface between database and the user of the database and other application programs.

A

DBMS

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

Market leader for general purpose database systems.

A

Oracle

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

Front End

A

INTERFACE

Ex. MS Visual Basic

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

Back End

A

Source Code

Ex. MS ACCESS

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

Skilled IS professional who directs all activities related to an organization’s database.

A

Database administrator

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

3 Roles/Functions of a database administrator

A
  • Installation of new software
  • Data analysis
  • Security Administration
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Requirements for a database administrator.

A

Bachelors degree in computer-related course.

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

For data to be transformed into useful informstion, it must first be organized in a ___________.

A

Meaningful way

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

Temporary repository of data and information.

A

Table

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

Foundation of database and database structure.

A

Table

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

A circuit that is either on or off, smallest unit of data storage.

A

Bit

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

Eight bits.

A

Byte

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

Basic building block of information.

A

Character

Each byte represents a character

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

Typically a name, number or combination of characters that describes an aspect of a business object or activity.

A

Field

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

A practice of writing compound words or phrases such that each next word or abbreviations begins with a capital letter.

A

Camel Case

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

4 rules for naming a field.

A
  1. Must begin with letter
  2. Descriptive
  3. Shorter the better
  4. Special characters not allowed
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

A collection of related data fields.

A

Record

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

A collection of related records.

A

File

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

A collection of integrated and related files.

A

Database

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

Hierarchy of Data

A
  1. Bit
  2. Byte
  3. Field
  4. Record
  5. File
  6. Database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

A generalized class of people, places, or things (objects) for which data is collected, stored and maintained.

A

Entity

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

It is also known as TABLE.

A

Entity

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

Characteristic/s of an entity.

A

Attribute

31
Q

Value of an attribute

A

Data item

32
Q
  • Field or set of fields in a record that is used to identify the record.
  • It is a unique identifier
A

Primary Key (PK)

33
Q

Separate data files are created for each application. Results in data redundancy.

A

Traditional approach

34
Q

It is also known as manual approach.

A

Traditional approach

35
Q

Pool of related data is shared by multiple applications. Reduced data redundancy.

A

Centralized approach

36
Q

Also known as Network approach.

A

Centralized approach

37
Q
  • Sequential Access
  • Non-permanent
  • Several locations
A

Traditional approach

38
Q
  • Direct access
  • Permanent Medium
  • One location
A

Database approach

39
Q

When building a database, what are the four things to consider?

A

Content
Logical Structure
Access
Physical Organizations

40
Q

Building a database requires two types of designs.

A

Logical design and Physical design

41
Q

Abstract model of how data should be structured and arranged to meet an organization’s information needs.

A

Logical design

E - Entity (Table)
A - Attribute
R - Relationship

42
Q

Fine tunes the logical database design for performance and cost considerations.

A

Physical

C - Columns
R - Rows
F - Field
K - Key
D - Domain
43
Q

A diagram of data entities and their relationship.

A

Data Model

44
Q

3 poor data models

A
  1. Difficulty in searching
  2. Inaccuracy
  3. Redundancy (duplication of record)
45
Q

Showing the relation between entities.

A

Relationship

46
Q

3 kinds of relationship

A
  1. One-one relationship
  2. One-many relationship
  3. Many-many relationship
47
Q

Data models that use basic graphical symbols to show the organization of & relationship between data.

A

Entity-Relationship Diagram (ERD)

48
Q

ANSI

A

American National Standard Institute

49
Q

It is the standard setter

A

ANSI

50
Q

Entity

A

Box/Rectangle

51
Q

Attribute

A

Oval

52
Q

Relationship

A

Diamond/Crow’s foot

53
Q

All data elements are placed in two-dimensional tables (relations) which are the logical equivalent of files (E.F. Codd)

A

Relational Model

54
Q

Each row represents a __________.

A

Record (Tuple)

55
Q

Columns of the table represents __________.

A

Attributes/Fields

56
Q

The allowable values for data attributes.

A

Domain

57
Q

It is also known as the field size.

A

Domain

58
Q

Selecting

A

Rows

59
Q

Projecting

A

Columns

60
Q

Joining

A

Combine

61
Q

Linking

A

Link

62
Q

Simple database program whose records have no relationship to one another.

A

Flat file

63
Q

One person can use the database at a time.

A

Single user

64
Q

4 types of Flat File

A
  • MS Excel
  • MS Word
  • MS OneNote
  • EverNote
65
Q

3 types of Single User

A
  1. MS Access
  2. FileMaker Pro
  3. MS InfoPath
66
Q

Allows dozens or hundreds of people to access the same database system at the same time.

A

Multiple user

67
Q

3 types of multiple user

A
  1. Oracle
  2. Sybase
  3. IBM DB2
68
Q

Description of the entire database.

A

Schema

69
Q

Large database systems typicall py use schemas to define the tables and other database features associated with a person or user.

A
70
Q

Collection of instructions/commands that define and describe data and data relationship in a database.

A

Database Definition Language (DDL)

71
Q

It allows database creator to describe the data and the data relationship that are to be contained in the schema.

A

Database Definition Language (DDL)

72
Q

A detailed description of all the data used in the database.

A

Data dictionary

73
Q

It organize data and information

A

Filing cabinet

complec (2 decks)

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