Brainscape's Knowledge GenomeTM

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


See full index

CE 165 : DATABASE MANAGEMENT SYSTEM > CHAPTER 1 MODULE > Flashcards

CHAPTER 1 MODULE Flashcards

1
Q

raw, unprocessed facts

A

DATA

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

processed data to make a“meaningful context”

A

INFORMATION

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

collected/ collection of related data

A

DATABASE

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

complete description of database / The database definifiton

A

META-DATA

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

duplication of data or storing of the same information in more than one place.

A

REDUNDANCY/ DATA REDUNDANCY

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

all data are stored in one place to reduce redundancy.

A

SINGLE REPOSITORY

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

4 PROBLEMS THAT IS CAUSED BY REDUNDANCY

A

1.Redundant Storage
2.Update Anomalies
3.Insertion Anomalies
4.Deletion Anomalies

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

-a system to manage a database use to create, maintain, and access database “storing” and “retrieval” of data
- set of programs that allows users to create and maintain the database.

A

DATABASE MANAGEMENT SYSTEM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q
  • part of the program that actually stores and retrieves data.
A

DATABASE ENGINE

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

4 functionalities

A
  1. Define
  2. Construct
  3. Manipulate
  4. Share
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

specifying the data type, structure, constraints for the data to be stored.

A

DEFINE

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

process of storing the data on some storage medium

A

CONSTRUCT

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

Querying the database to retrieve specific data, updating database and generating reports

A

MANIPULATE

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

a statement requesting the retrieval of info.

A

QUERY

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

allows multiple users and programs to access the database concurrently.

A

SHARE

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

PROPERTIES OF DATABASE

A
  1. A database represents some aspects of the real world (miniworld).
    2.A database is a logically coherent (should be related) collection of data with some inherent meaning.
  2. A database is designed, built, and populated with data for a specific purpose.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

write the queries or programs

A

USERS/ PROGRAMMERS

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

process the queries or programs

A

DBMS SOFTWARE

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

CHARACTERISTICS OF DBMS

A

1.Self describing Nature of DBMS
2.Insulation between Programs and Data, & Data Abstraction
3.Support of Multiple Views of the Data
4.Sharing of Data and Multi-user Transaction Processing

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

2.Insulation between Programs and Data, & Data Abstraction

if there is a change in the structure of data, then the program changes too.

A

Traditional File Processing

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

Insulation between Programs and Data, & Data Abstraction

no need to change the program if there is a change in the structure of data (data program independence) —characteristic is “Data Abstraction”

A

DBMS Approach

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

Sharing of Data and Multi-user Transaction Processing

no multiple user, isolation

A

Concurrency Control

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

can only be answered by a yes or no and it must happen in its entity or not at all

A

Atomicity

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

2 types of Database Users

A
  1. Actors on the Scene
  2. Workers behind the Scene
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Who belongs to Actors on the scene?

A

1.Database Administrators
2.Database Designers
3.End Users

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

Who belongs to workers behind the scene?

A

Software Engineers
System Designers and Implementers
Tool Developers
Operators and Maintenance Personnel

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

whose jobs involve the day to day use of large database.

A

ACTORS ON THE SCENE

28
Q

(Primary Resource)

A

Database

29
Q

DBMS & Related Software

A

(Secondary Resource)

30
Q

RESPONSIBILITIES of Database Administrators:

A

a)Administering primary and secondary resources.
b)Give access to users/ authorizing access to the database
c)Coordinating and Monitoring the use of database
d)Accountable when there is breach of security and when there is poor system response time.
e)Acquiring software and hardware resources as needed.

31
Q

a)Identify the data to be stored in the database.
b)Choosing appropriate structure to represent and store data.
c)Communicating with end-users in order to know their requirements (database design)

A

Responsibilities of database designers

32
Q

Require access to the database: querying ,Updating Generating reports

A

End Users

33
Q

Categories of End Users

A
  1. Casual
  2. Naive/ parametric
  3. Sophisticated
  4. Stand-Alone
34
Q

access the database occasionally

A

Casual End Users

35
Q

constantly querying and updating the database

A

Naive/Parametric End Users

36
Q

standard types of queries and updates

A

canned transactions

37
Q

Engineers, scientists, business, analysts, and others who thoroughly familiarize themselves with the facilities of DBMS

A

Sophisticated End Users

38
Q

maintain personal database using ready made program packages

A

Stand-Alone End Users

39
Q

Determine the requirements of end users in order to develop specifications

A

System Analysts

40
Q

Implement the specifications as programs to test, debug, document and maintain

A

Application Programmers

41
Q

whose job is to maintain the database, not interested about the database itself.

A

WORKERS BEHIND THE SCENE

42
Q

system analyst and application programmers

A

Software Engineers

43
Q

design and implement DBMS modules and interface as a package.

A

System Designers and Implementer

44
Q

design and implement tools

A

Tool Developers

45
Q

To facilitate the database system design and use

A

Tool :Software Packages

46
Q

responsible for the actual running and maintenance of the software.

A

Operators and Maintenance Personnel

47
Q

ADVANTAGES OF DBMS

A

1.Compactness
2.Controlling Redundancy
3.Restricting Unauthorized Access
4.Providing Persistent Storage for Program Objects
5.Providing Storage Structures for Efficient Query Processing
6.Providing Backup and Recovery
7.Providing Multiple User Interface
8.Representing Complex Relationship Among Data
9.Enforcing Integrity Constraints

48
Q

ADVANTAGES.

data are stored in a single repository

A

Compactness

49
Q

wastage of storage and its inconsistency

A

Traditional File System

50
Q

Controlling Redundancy

A

Traditional File System
DBMS Approach

51
Q
  • for security and authorization subsystem
  • work of database administrators
A

Restricting Unauthorized Access

52
Q

Providing Persistent Storage for Program Objects (AD)

Programs terminate _ Values of program Variables_ Discarded

A

TRADITIONAL

53
Q

Program terminate_ Values of program variable_ Not discarded (stores object permanently) _ Persistent

A

DBMS Approach

54
Q

responsible for efficient query and execution

A

Providing Storage Structures for Efficient Query Processing and Optimization Module

55
Q

-When there is system failure
-Capable of doing recovery

A

Providing Backup and Recovery

56
Q

4 Multiple User Interface

A
  1. Query Language
  2. Programming Language
  3. Forms
  4. Menu Driven Interface
57
Q

Interface for casual end users.

A

Query Language

58
Q

Interface for app programmer

A

Programming Language

59
Q

Interface for naive/parametric

A

Forms

60
Q

interface for stand alone

A

Menu-Driven Interface

61
Q

simplest data constraints such as data types by the database designers.

A

Enforcing Integrity Constraints

62
Q

DISADVANTAGES OF DBMS

A

1.Increased Complexity
2.Greater Impact of Failure
3.More Difficult Recovery
4.Large File Size

63
Q

you need to master facilities

A

Increased Complexity

63
Q

you need to master facilities

A

Increased Complexity

64
Q

you need to master facilities

A

Increased Complexity

65
Q

the more users of the DBMS, the greater the tendency for the system to fail

A

More Difficult Recovery

66
Q

Data are stored in a “single repository” that requires a larger storage Space

A

4.Large File Size

CE 165 : DATABASE MANAGEMENT SYSTEM (5 decks)

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