Brainscape's Knowledge GenomeTM

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


See full index

CCS 5 - Fundamentals of Information Management > Topic 1: Introduction to Database Systems > Flashcards

Topic 1: Introduction to Database Systems Flashcards

1
Q

These refer to unprocessed facts that has not been designed to be useful for the user

A

Data

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

These facts are the processed raw data to reveal meaning

A

Information

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

Examples of Data Processing

A
  • Organizing Data
  • Making Forecasts
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

This is the discipline on the proper generation, storage and retrieval of Data

A

Data Management

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

This is a shared, integrated Computer structure that stores a collection of end-user data and Metadata

A

Database

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

This data is raw facts of interest to the end user

A

End-user Data

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

This kind of data is, data about data where the end-user data is integrated and managed.

A

Metadata

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

This is a collection of programs that manages the database structure and controls access to the data stored in the database`

A

Database System (DBMS)

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

Roles of a Database Management System

A
  • it is the intermediary between the user and the database
  • it hides the database’s internal complexity
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Advantages of the DBMS

A
  • data is shared among multiple applications and users
  • the many users’ view of data is integrated into an all-encompassing repository
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Types of Databases (according to the number of users)

A
  • Single-user
  • Multiuser
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Types of Databases (according to the location)

A
  • Centralized databases
  • Distributed databases
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Types of Databases (based on expected type and extent of use)

A
  • Operational databases
  • Data warehouses
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Types of Databases (based on how the degree to which the data are structured)

A
  • Unstructured Data
  • Structured Data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

This is a type of database according to the number of users that supports only one user at a time

A

Single-user Databases

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

This type of database according to the number of users supports multiple users at the same time

A

Multiuser Databases

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

This is a type of Multiuser Database that allows less than 50 users or a specific department to access it

A

Workgroup Database

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

This is a type of multiuser database wherein more than 50 users and the entire organization can use it

A

Enterprise database

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

It is a type of Database according to location wherein it is stored in a single location

A

Centralized Database

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

It is the type of Database according to location wherein it is distributed across several different sites

A

Distributed Database

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

This type of database according to its extent of supports a company’s day-to-day operation

A

Operational Database

22
Q

This is a database according to the extent of its use that is used to storing data to generate information required to make tactical or strategic decisions

A

Data warehouse

23
Q

This is a type of classified to the degree which the data are structured where in the data exists in its original state when it was collected

A

Unstructured Data

24
Q

This is a type of database based on the degree which the data is structured where the data is now formatted to facilitate storage, use and generation of information

A

Structured Data

25
Q

Preceeded Databases and DBMSs

A

File Systems

26
Q

Problems with File Systems

A
  • Simple Retrieval requires extensive programming
  • does not support ad hoc queries
  • difficulty in changing the structure
  • the many the files the more difficult it is for system administration
  • security is lacking, often omitted
27
Q

It happens when a file is dependent on its structure

A

Structural dependence

28
Q

It happens when it is possible to make changes in the file structure without affecting the application program’s ability to access the data

A

Structural Independence

29
Q

This occurs when program in systems that access the data are modified because of the change of the file’s storage characteristics

A

Data Dependence

30
Q

This happens when it is possible to make changes in the data storage characteristics without affecting the application program’s ability to access the data

A

Data Indpendence

31
Q

It is the storage of the same data in different locations

A

Data Redundancy

32
Q

Uncontrolled Data Redundancy results in

A

Data Inconsistencies
Data anomalies

33
Q

This happens when different and conflicting versions of the same data appear in different places

A

Data Inconsistencies

34
Q

This happens when there is an abnormal condition because users are forced to do field value changes in many different locations

A

Data anomalies

35
Q

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

A

Database Systems

36
Q

Five Major Parts in a Database System

A

Hardware
Software
People
Procedures
Data

37
Q

These are the software needed for Database Systems

A

Operating System
DBMS Software
Application Programs and Utility Software

38
Q

These are software that manages all hardware components and makes it possible for all other software to run on the computers

A

Operating Systems

39
Q

This software manages the database within the database system

A

DBMS Software

40
Q

These are software to access and manipulate data in the DBMS and to manage the computer environment in which data access and manipulation take place

A

Application Programs and Utility Software

41
Q

This is a component in a Database System that refers to all of the system’s physical devices

A

Hardware

42
Q

These are the people that oversee the database system’s general operations

A

System Administrators

42
Q

This is component in a Database System that refers to all users of the Database System

A

People

43
Q

These are the people that manage the DBMS and ensure that the database is functioning properly

A

Database Administrators

44
Q

These people design the database structure

A

Database Designers

45
Q

These people design and implement the application programs

A

System Analysts and Programmers

46
Q

These are the people that use the application programs to run the organization’s daily operations

A

End Users

47
Q

This is a component in a Database System wherein it refers to the instructions and rules that govern the design and use of the database system

A

Procedures

48
Q

These refer to the collection of facts stored in the database

A

Data

49
Q

Key Functions of a DBMS

A

Data Dictionary Management
Data Storage Management
Security Management
Multiuser Access Control
Backup and Recovery Management
Data Integrity Management
Database Communication Interfaces

50
Q

Disadvantages of a DBMS

A
  • Increased Costs
  • Management Complexity
  • Maintaining Currency
  • Vendor Dependence
  • Frequent Upgrade/Replacement Cycles

CCS 5 - Fundamentals of Information Management (7 decks)

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