LESSON 2 PROPERTIES AND OBJECTIVES OF A DATABASE AND TRADITIONAL FILE PROCESSING

Question 1

It is an activity of gathering and capturing raw data

Answer 1

Input

Question 2

Converting data into useful outputs

Answer 2

Process/ Processing

Question 3

It is a production of useful information, usually in the form of documents or reports.
DATA–> PROCESS –> INFORMATION

Answer 3

Output

Question 4

It is an information from the system that is used to make changes to input or processing activities.

Answer 4

Feedback

Question 5

A-Atomicity
C- Consistency
I- Isolation
D- Durability

Answer 5

PROPERTIES OF A DATABASE

Question 6

In the database ensures that the transactions are indivisible and irreducible where transactions either commit or abort.
If part of the transaction fails, then the entire transaction fails.

Answer 6

Atomicity

Question 7

It is a method of storing and arranging computer files and the information in the file (data).

Answer 7

Traditional File Processing

Question 8

It is a method of storing and arranging computer files and the information in the file (data).

Answer 8

Traditional File Processing

Question 9

Include Manual Systems and also Computer Based File Systems that were linked to particular application programs

Answer 9

Traditional File Processing Systems

Question 10

• A collection of application programs that perform services for the endusers such as the production of reports.
• Each program defines and manages its own data

Answer 10

Traditional File-based Systems

Question 11

It is used to maintain the records and files. All the data was stored in files and it makes it easy to find any information.

Answer 11

Manual File System

Question 12

Three Types of Data Processing Methods

Answer 12

1.Manual Data Processing
2.Mechanical Data Processing
3.Electronic Data Processing

Question 13

It is a data processed manually without using any machine or tool to get the required results. * All the calculations and logical operations are performed manually on the data

Answer 13

Manual Data Processing

Question 14

It is a data processed by using different devices like typewriters, mechanical printers, or other mechanical devices

Answer 14

Mechanical Data Processing

Question 15

It is the modern technique to process data.

Answer 15

Electronic Data Processing (EDP)

Question 16

Data and set of instructions are given to the computer as input and the computer automatically processes the data according to the given set of instructions.

Answer 16

Electronic Data Processing (EDP)

Question 17

It refers to the process of adjusting data to make it organized and easier to read.

Answer 17

Data Manipulation

Question 18

It is a programming language that adjusts data by inserting, deleting, and modifying data in a database such as to cleanse or map the data.

Answer 18

Data Manipulation Language

Question 19

It is a statement allows users to pull a selection from the database to work with.

Answer 19

Select

Question 20

To change data that already exists

Answer 20

Update

Question 21

You can add and move data from one location to another.

Answer 21

Insert

Question 22

To get rid of existing records within a table.

Answer 22

Delete

Question 23

Purpose of Data Manipulation

Answer 23

• Consistent data
• Project data
• Create more value from the data
• Remove or ignore unneeded data

Question 24

It allows the data to be organized, read, and better understood.

Answer 24

Consistent Data

Question 25

It can able to use historical data to project the future and provide more in-depth analysis is paramount for businesses, especially when it comes to finances

Answer 25

Project Data

Question 26

It can able to transform, edit, delete, and insert data into a database means that you can do more with your data.

Answer 26

Create more Value from the Data

Question 27

It is data that is unusable and can interfere with what matters. Unnecessary or inaccurate data should be cleaned and deleted.

Answer 27

Remove or Ignore Unneeded Data

Question 28

It is an organized collection of structured information, or data, typically stored electronically in a computer system.

Answer 28

Database

Question 29

Types of Database

Answer 29

1. Operational Databases 2. End-user Databases 3. Centralized Databases 4. Distributed Databases

Question 30

These databases store data relating to the operations of the enterprise

Answer 30

Operational Databases

Question 31

These databases are shared by users and contain information meant for use of the end-users like managers, at different levels

Answer 31

End-user Databases

Question 32

These databases store the entire information and application programs at a central computing facility

Answer 32

Centralized Databases

Question 33

These databases have contributions from the common databases as well as the data captured from the local operation

Answer 33

Distributed Databases

Question 34

It is a type of database structure and it is a software package for creating and managing databases

Answer 34

Database Management System

Question 35

TWO TYPES OF DATABASE STRUCTURE

Answer 35

1. Flat-file Database 2. Relational Database

Question 36

It also known as single file and stores data in a plain text file, with each line of text typically holding one record.

Answer 36

Flat-file Database

Question 37

* It can be a multi-file relational or structured database. * These databases are more flexible than flat-file structures, and provide functionality for reading, creating, updating, and deleting data

Answer 37

Relational Database

Question 38

Types of Relationship in a Database

Answer 38

One to One One to Many Many to One Many to Many