Exam (elaborations)
DBMS Study Set – Complete With Solutions (Rated A+)
- Course
- Institution
DBMS Study Set – Complete With Solutions (Rated A+)
[Show more]
Content preview
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)
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller LeCrae. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
76747 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now