Lesson 1.1: File Processing Systems and Database Systems

Question 1

It is a collection of application programs that perform services for the end-users

Answer 1

File Based Systems

Question 2

Examples of File Based System

Answer 2

Production of Reports

Question 3

It is a collection of files and programs that access/modify files

Answer 3

File Processing System

Question 4

Disadvantages of File System Approach

Answer 4

Program-data dependence
Duplication of data
Limited data sharing
Lengthy development times
Excessive program maintenance
Data redundancy and inconsistency
Multiple file formats, duplication of information in different files
Difficulty in accessing data
Need to write a new program to carry out each new task
Data isolation - multiple files and formats
Integrity problems and constraints (e.g. account balance > 0) become part of program code
Hard to add new constraints or change existing ones

Question 5

It is a valuable corporate resource which needs adequate, accurate, and consistent security controls.

Answer 5

Data

Question 6

The centralized control of data means that for many applications the data is available, and thereby facilitate what?

Answer 6

Quicker development

Question 7

In the file system approach, data will no be related by application progams, but by the structure defined in the file system.

Answer 7

False. Data will no longer be related by application programs in database approach, as the structure is defined by the database.

Question 8

Benefits of the Database Approach

Answer 8

Data can be shared
Redundancy can be reduced
Inconsistency can be avoided
Transaction support can be provided
Integrity can be maintained
Security can be enforced
Conflicting requirements can be balanced
Standards can be enforced

Question 9

It is a term where data is stored independently of the programs

Answer 9

Program-data independence

Question 10

Two kinds of data independence

Answer 10

Physical and Logical

Question 11

applications implemented in older systems tend to be what?

Answer 11

data-dependent

Question 12

in database approach, the same data can now be viewed in different layout (different views)

Answer 12

True, since different applications require different views of the data, it is necessary that there is a central database so the need to copy the data from one application to another is eliminated, thus this achieves program-data independence.

Question 13

Advantages of DBMS (from the video)

Answer 13

Smaller size
Attributes
Concurrency
Security (role-based)
Lesser redundancy/duplicates