Second Handout

Question 1

It means repository of data information

Answer 1

Cylinder

Question 2

It means process

Answer 2

Rectangle

Question 3

It is an organized collection of data

Answer 3

Database

Question 4

It is permanent repository of data and information.

Answer 4

Database

Question 5

Siya lang ang pwedeng magdelete.

Answer 5

Database administrator

Question 6

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

Answer 6

Electronic Form

Question 7

Group of programs to manage database.

Answer 7

Database Management System (DBMS)

Question 8

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

Answer 8

DBMS

Question 9

Market leader for general purpose database systems.

Answer 9

Oracle

Question 10

Front End

Answer 10

INTERFACE

Ex. MS Visual Basic

Question 11

Back End

Answer 11

Source Code

Ex. MS ACCESS

Question 12

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

Answer 12

Database administrator

Question 13

3 Roles/Functions of a database administrator

Answer 13

• Installation of new software
• Data analysis
• Security Administration

Question 14

Requirements for a database administrator.

Answer 14

Bachelors degree in computer-related course.

Question 15

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

Answer 15

Meaningful way

Question 16

Temporary repository of data and information.

Answer 16

Table

Question 17

Foundation of database and database structure.

Answer 17

Table

Question 18

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

Answer 18

Bit

Question 19

Eight bits.

Answer 19

Byte

Question 20

Basic building block of information.

Answer 20

Character

Each byte represents a character

Question 21

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

Answer 21

Field

Question 22

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

Answer 22

Camel Case

Question 23

4 rules for naming a field.

Answer 23

1. Must begin with letter
2. Descriptive
3. Shorter the better
4. Special characters not allowed

Question 24

A collection of related data fields.

Answer 24

Record

Question 25

A collection of related records.

Answer 25

File

Question 26

A collection of integrated and related files.

Answer 26

Database

Question 27

Hierarchy of Data

Answer 27

1. Bit 2. Byte 3. Field 4. Record 5. File 6. Database

Question 28

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

Answer 28

Entity

Question 29

It is also known as TABLE.

Answer 29

Entity

Question 30

Characteristic/s of an entity.

Answer 30

Attribute

Question 31

Value of an attribute

Answer 31

Data item

Question 32

- Field or set of fields in a record that is used to identify the record. - It is a unique identifier

Answer 32

Primary Key (PK)

Question 33

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

Answer 33

Traditional approach

Question 34

It is also known as manual approach.

Answer 34

Traditional approach

Question 35

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

Answer 35

Centralized approach

Question 36

Also known as Network approach.

Answer 36

Centralized approach

Question 37

- Sequential Access - Non-permanent - Several locations

Answer 37

Traditional approach

Question 38

- Direct access - Permanent Medium - One location

Answer 38

Database approach

Question 39

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

Answer 39

Content Logical Structure Access Physical Organizations

Question 40

Building a database requires two types of designs.

Answer 40

Logical design and Physical design

Question 41

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

Answer 41

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

Question 42

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

Answer 42

Physical ``` C - Columns R - Rows F - Field K - Key D - Domain ```

Question 43

A diagram of data entities and their relationship.

Answer 43

Data Model

Question 44

3 poor data models

Answer 44

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

Question 45

Showing the relation between entities.

Answer 45

Relationship

Question 46

3 kinds of relationship

Answer 46

1. One-one relationship 2. One-many relationship 3. Many-many relationship

Question 47

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

Answer 47

Entity-Relationship Diagram (ERD)

Question 48

ANSI

Answer 48

American National Standard Institute

Question 49

It is the standard setter

Answer 49

ANSI

Question 50

Entity

Answer 50

Box/Rectangle

Question 51

Attribute

Answer 51

Oval

Question 52

Relationship

Answer 52

Diamond/Crow's foot

Question 53

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

Answer 53

Relational Model

Question 54

Each row represents a __________.

Answer 54

Record (Tuple)

Question 55

Columns of the table represents __________.

Answer 55

Attributes/Fields

Question 56

The allowable values for data attributes.

Answer 56

Domain

Question 57

It is also known as the field size.

Answer 57

Domain

Question 58

Selecting

Answer 58

Rows

Question 59

Projecting

Answer 59

Columns

Question 60

Joining

Answer 60

Combine

Question 61

Linking

Answer 61

Link

Question 62

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

Answer 62

Flat file

Question 63

One person can use the database at a time.

Answer 63

Single user

Question 64

4 types of Flat File

Answer 64

- MS Excel - MS Word - MS OneNote - EverNote

Question 65

3 types of Single User

Answer 65

1. MS Access 2. FileMaker Pro 3. MS InfoPath

Question 66

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

Answer 66

Multiple user

Question 67

3 types of multiple user

Answer 67

1. Oracle 2. Sybase 3. IBM DB2

Question 68

Description of the entire database.

Answer 68

Schema

Question 69

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

Answer 69

--------

Question 70

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

Answer 70

Database Definition Language (DDL)

Question 71

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

Answer 71

Database Definition Language (DDL)

Question 72

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

Answer 72

Data dictionary

Question 73

It organize data and information

Answer 73

Filing cabinet