DBMS Study Set – Complete With Solutions (Rated A+)
File-Based System Right Ans - A collection of application programs that
perform services for the end-users such as the production of reports.
File-Based System Right Ans - It is considered as the predecessor of
database system.
File-Based System Right Ans - Each program defines and manages its own
data.
File-Based System Right Ans - File system was an early attempt to
computerize the manual filing system.
File-Based System Right Ans - File Systems may use a storage device such
as a hard disk or CD-ROM.
File-Based System Right Ans - A file system is a method for storing and
organizing computer files and the data to make it easy to find and access.
Characteristics of File Processing System Right Ans - It is group of files
storing data of an organization.
Characteristics of File Processing System Right Ans - Files are designed by
using application programs written in programming languages such as
COBOL, C, C++, etc....
Characteristics of File Processing System Right Ans - Each file contained
and processed information for one specific function like accounting or
inventory.
Characteristics of File Processing System Right Ans - Each file is called flat
file.
Characteristics of File Processing System Right Ans - Each file is
independent from one another.
Flat file Right Ans - A flat file is a file containing records that have no
structured interrelationship
, Problems: Traditional approach Right Ans - Data Security
Problems: Traditional approach Right Ans - Data Redundancy
Problems: Traditional approach Right Ans - Data Isolation
Problems: Traditional approach Right Ans - Program/ Data Dependence
Problems: Traditional approach Right Ans - Concurrent Access Anomalies
Data Security Right Ans - The data as maintained in flat files is easily
accessible and therefore not secure.
Data Redundancy Right Ans - Often the same information is duplicated in
two or more files.
Data Redundancy Right Ans - It may lead to inconsistency
Data Isolation Right Ans - Data isolation means that all the related data is
not available in one file.
Data Isolation Right Ans - Generally, the data scattered in various files, and
the files may be in different formats, therefore writing new application
programs to retrieve the appropriate data is difficult.
Program/ Data Dependence Right Ans - Example: Banking system
Program/ Data Dependence Right Ans - Find out the customer's name,
address & postal area
Obtain the list of customers and extract the needed info Manually.
Or Ask a system programmer to write the necessary application program.
Concurrent Access Anomalies Right Ans - Many systems allow multiple
users to update the data simultaneously. In such environment, interaction of
concurrent updates may result in inconsistent data.
Example: Bank account (P10,000)
File-Based System Right Ans - A collection of application programs that
perform services for the end-users such as the production of reports.
File-Based System Right Ans - It is considered as the predecessor of
database system.
File-Based System Right Ans - Each program defines and manages its own
data.
File-Based System Right Ans - File system was an early attempt to
computerize the manual filing system.
File-Based System Right Ans - File Systems may use a storage device such
as a hard disk or CD-ROM.
File-Based System Right Ans - A file system is a method for storing and
organizing computer files and the data to make it easy to find and access.
Characteristics of File Processing System Right Ans - It is group of files
storing data of an organization.
Characteristics of File Processing System Right Ans - Files are designed by
using application programs written in programming languages such as
COBOL, C, C++, etc....
Characteristics of File Processing System Right Ans - Each file contained
and processed information for one specific function like accounting or
inventory.
Characteristics of File Processing System Right Ans - Each file is called flat
file.
Characteristics of File Processing System Right Ans - Each file is
independent from one another.
Flat file Right Ans - A flat file is a file containing records that have no
structured interrelationship
, Problems: Traditional approach Right Ans - Data Security
Problems: Traditional approach Right Ans - Data Redundancy
Problems: Traditional approach Right Ans - Data Isolation
Problems: Traditional approach Right Ans - Program/ Data Dependence
Problems: Traditional approach Right Ans - Concurrent Access Anomalies
Data Security Right Ans - The data as maintained in flat files is easily
accessible and therefore not secure.
Data Redundancy Right Ans - Often the same information is duplicated in
two or more files.
Data Redundancy Right Ans - It may lead to inconsistency
Data Isolation Right Ans - Data isolation means that all the related data is
not available in one file.
Data Isolation Right Ans - Generally, the data scattered in various files, and
the files may be in different formats, therefore writing new application
programs to retrieve the appropriate data is difficult.
Program/ Data Dependence Right Ans - Example: Banking system
Program/ Data Dependence Right Ans - Find out the customer's name,
address & postal area
Obtain the list of customers and extract the needed info Manually.
Or Ask a system programmer to write the necessary application program.
Concurrent Access Anomalies Right Ans - Many systems allow multiple
users to update the data simultaneously. In such environment, interaction of
concurrent updates may result in inconsistent data.
Example: Bank account (P10,000)
