Topic 1: Introduction to Database Systems

Question 1

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

Answer 1

Data

Question 2

These facts are the processed raw data to reveal meaning

Answer 2

Information

Question 3

Examples of Data Processing

Answer 3

• Organizing Data
• Making Forecasts

Question 4

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

Answer 4

Data Management

Question 5

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

Answer 5

Database

Question 6

This data is raw facts of interest to the end user

Answer 6

End-user Data

Question 7

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

Answer 7

Metadata

Question 8

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

Answer 8

Database System (DBMS)

Question 9

Roles of a Database Management System

Answer 9

• it is the intermediary between the user and the database
• it hides the database’s internal complexity

Question 10

Advantages of the DBMS

Answer 10

• data is shared among multiple applications and users
• the many users’ view of data is integrated into an all-encompassing repository

Question 11

Types of Databases (according to the number of users)

Answer 11

• Single-user
• Multiuser

Question 12

Types of Databases (according to the location)

Answer 12

• Centralized databases
• Distributed databases

Question 13

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

Answer 13

• Operational databases
• Data warehouses

Question 14

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

Answer 14

• Unstructured Data
• Structured Data

Question 15

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

Answer 15

Single-user Databases

Question 16

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

Answer 16

Multiuser Databases

Question 17

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

Answer 17

Workgroup Database

Question 18

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

Answer 18

Enterprise database

Question 19

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

Answer 19

Centralized Database

Question 20

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

Answer 20

Distributed Database

Question 21

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

Answer 21

Operational Database

Question 22

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

Answer 22

Data warehouse

Question 23

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

Answer 23

Unstructured Data

Question 24

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

Answer 24

Structured Data

Question 25

Preceeded Databases and DBMSs

Answer 25

File Systems

Question 26

Problems with File Systems

Answer 26

- 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

Question 27

It happens when a file is dependent on its structure

Answer 27

Structural dependence

Question 28

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

Answer 28

Structural Independence

Question 29

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

Answer 29

Data Dependence

Question 30

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

Answer 30

Data Indpendence

Question 31

It is the storage of the same data in different locations

Answer 31

Data Redundancy

Question 32

Uncontrolled Data Redundancy results in

Answer 32

Data Inconsistencies Data anomalies

Question 33

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

Answer 33

Data Inconsistencies

Question 34

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

Answer 34

Data anomalies

Question 35

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

Answer 35

Database Systems

Question 36

Five Major Parts in a Database System

Answer 36

Hardware Software People Procedures Data

Question 37

These are the software needed for Database Systems

Answer 37

Operating System DBMS Software Application Programs and Utility Software

Question 38

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

Answer 38

Operating Systems

Question 39

This software manages the database within the database system

Answer 39

DBMS Software

Question 40

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

Answer 40

Application Programs and Utility Software

Question 41

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

Answer 41

Hardware

Question 42

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

Answer 42

System Administrators

Question 42

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

Answer 42

People

Question 43

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

Answer 43

Database Administrators

Question 44

These people design the database structure

Answer 44

Database Designers

Question 45

These people design and implement the application programs

Answer 45

System Analysts and Programmers

Question 46

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

Answer 46

End Users

Question 47

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

Answer 47

Procedures

Question 48

These refer to the collection of facts stored in the database

Answer 48

Data

Question 49

Key Functions of a DBMS

Answer 49

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

Question 50

Disadvantages of a DBMS

Answer 50

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