Question

Subject: Database System Design & Management File Structure Problems (Please list references in APA style) Q:...

Subject: Database System Design & Management

File Structure Problems

(Please list references in APA style)

Q: Describe Problems with File System Data Processing. Provide examples if applicable.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

he different problems with the File System Data management Processing are as follows.

1. Problems with file based system: Lengthy Development Times

The first and most important problem with the file based system approach is that even the simplest data-retrieval task requires extensive programming.

With the traditional file environment, programmers had to specify what must be done and how it was to be done. But modern databases use a nonprocedural data manipulation language that allows the user to specify what must be done without specifying how it must be done.

2. Problems with file based data management system: Difficulty of getting quick answers

The another important problem in traditional file environment system is difficulty of getting quick answers because it needs more adhoc queries and more programming for new reports. So, we can’t take the decision very fast.

3. Problems with file based system: Complex system administration

In the old traditional file based system, system administration becomes more difficult as the number of files increases. Even a simple file system with a few files requires creating and maintaining several file management programs because each file must have its own file management programs that allow the user to add, modify, and delete records.

To list the file contents and to generate reports, it needs more reporting programs. This problem is doubled if each department in the organization maintains its data by creating its own files.

4. Problems with file based system: Lack of security and Limited Data Sharing

Another fault of a file based system is a lack of security and limited data sharing.

Data sharing and security are closely related. Sharing data among multiple geographically dispersed users introduces a lot of security risks. In terms of spreadsheet data, while many spreadsheet programs provide basic security options, they are not always used, and even when they are used, they are insufficient for robust data sharing among users.

In terms of the creation of data management and reporting programs, security and data-sharing features are difficult to program so they are normally omitted in a file system environment. Such features include effective password protection, the ability to lock out parts of files or parts of the system itself, and other measures designed to safeguard data confidentiality. Even when an attempt is made to improve system and data security, the security devices tend to be limited in scope and effectiveness.

5. Problems with file based system: Extensive programming

Making changes to an existing file structure in a file based system environment, it needs extensive programming. For example, changing just one field in the original CUSTOMER file would require a program that:

1. Reads a record from the original file.

2. Transforms the original data to conform to the new structure’s storage requirements.

3. Writes the transformed data into the new file structure.

4. Repeats steps 2 to 4 for each record in the original file.

Any small change to a file structure forces modifications in all of the programs that use the data in that file. Modifications are likely to produce errors (bugs), and additional time is spent using a debugging process to find those errors.

6. Problems with file based system: Structural dependence

A file based system exhibits structural dependence, which means that access to a file is dependent on its structure.

For example, adding a customer date-of-birth field to the CUSTOMER, given this change, none of the previous programs will work with the new CUSTOMER file structure. Therefore, all of the file system programs must be modified to conform to the new file structure.

So the file based system application programs are affected by file structure modification, they exhibit structural dependence. If structural independence exists then it is possible to make changes in the file structure without affecting the application program’s ability to access the data.

7. Problems with file based system: Data dependence

Another problem with traditional file based system is, modifications in the characteristics of data, such as changing a field from integer to decimal, require changes in all the programs that access the file.

Because all data access programs are subject to change when any of the file’s data storage characteristics change (that is, changing the data type), the file system is said to exhibit data dependence.

So, If data independence exists then it is possible to make changes in the data storage characteristics without affecting the application program’s ability to access the data.

8. Problems with file based system: Data redundancy

Data redundancy is another important problem in the traditional file processing system.

Data redundancy exists when the same data are stored at different places. The file system’s structure makes it difficult to combine data from multiple sources, and its lack of security renders the file system vulnerable to security breaches. The organizational structure promotes the storage of the same basic data in different locations. The different problems with data redundancy are:

i. Poor data security: Having multiple copies of data increases the chances for a copy of the data to be susceptible to unauthorized access.

ii. Data inconsistency: Data inconsistency exists when different and conflicting versions of the same data appear in different places.

For example, suppose you change an agent’s phone number or address in the AGENT file. If you forget to make Corresponding changes in the CUSTOMER file, the files contain different data for the same agent. Reports will yield inconsistent results that depend on which version of the data is used.

iii. Data anomalies: The dictionary defines anomaly as “an abnormality.” Ideally, a field value change should be made in only a single place. Data redundancy, however, fosters an abnormal condition by forcing field value changes in many different locations. A data anomaly develops when not all of the required changes in the redundant data are made successfully.

Add a comment
Know the answer?
Add Answer to:
Subject: Database System Design & Management File Structure Problems (Please list references in APA style) Q:...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • SUBJECT: INFORMATION TECHNOLOGY, CLASS: ADVANCE DATABASE MANAGEMENT Hello Everyone, I need help on a project for...

    SUBJECT: INFORMATION TECHNOLOGY, CLASS: ADVANCE DATABASE MANAGEMENT Hello Everyone, I need help on a project for my ITD 256 Class. These are the questions I am suppose to answer: Project: The project should include designing a database deals with making a proposal for the database implementation. You can either try to fix an existing problem in your business or create a new database for the new projects or new clients. Please define the objective, scope, and time frame of your...

  • please unique answer, no handwriting, for safeAssign Pilgirism submission.(References should be in APA style) course :...

    please unique answer, no handwriting, for safeAssign Pilgirism submission.(References should be in APA style) course : Interdisciplinary Perspectives in Healthcare PHC214. Textbook: Mosser, G., and Begun, J. W. (2014). Understanding teamwork in health care. New York, NY: McGraw Hill Education. ISBN: 9780071791953 (paperback version; CourseSmart); ISBN: 9780071791960 (e-book) Please answer the following questions thoroughly: Describe the difference between work groups and work teams? List three benefits and three risks associated with work teams?

  • Project 2: Database System Design Background: An department store is currently developing a new database system...

    Project 2: Database System Design Background: An department store is currently developing a new database system to store all of its information. The new system would enable the store to enter data regarding inventory levels, ordering, and so on. Currently, the data for inventory and sales tracking are stored in one file that has the following format: Item List: ItemID, ItemName, Item Description, Price, Cost, Supplier List: SupplierID, SupplierName, Supply order List: SupplyOrderID, ShippingTime, DeliveryDate, Inventory List: InventoryID, QuantityOnHand, Customer...

  • Use resources (APA style) and provide links and citations (in-text) and references. Think of yourself as...

    Use resources (APA style) and provide links and citations (in-text) and references. Think of yourself as both a lawyer and nurse that is reporting to the hospital's CEO.   Structure: Please start Part ci, c ii and beyond, but include a and b as well -- parts must be included. Thanks. a.   Identify the main issue in the case. i.   Phrase the issue of the case in the form of one or two brief statements. b.   What are the facts of the case?...

  • Management Information System

    through studying the IT infrastructure of a relevant information system (IS)/ information technology (IT) used by selecting any organization of your choice locally or internationally The idea is to investigate the selected organization using the main components of IT (Hardware, software, services, data management and networking). Infrastructure Investigation, which is in a selected industry, should be carried out by using articles, websites, books and journal papers and /or interviews. In the report, you are expected to discuss:Executive Summary .     ...

  • Please help me to solve Please, No handwriting COURSE; introduction to database Q- write a query ...

    Please help me to solve Please, No handwriting COURSE; introduction to database Q- write a query SQL by Using the info below A. Normalize the Tables (in 3NF at least) B. Create the Normalized Tables and Populate them with at least 5 Rows C. Write the Wholesale Management System requested Queries & Execute them VERY IMPORTANT Screenshots from MySQL (or any other software you use) of all the tables after queries result. - Database system for a Wholesale Management System...

  • Your project will require you to develop a database design to solve a real-life data management...

    Your project will require you to develop a database design to solve a real-life data management problem. It can be any problem in your work environment or for another organization, for example, a bookstore (think of how Amazon uses databases), a course management system (think of how a university manages courses), a bank (think of how your bank works), and an online auction site (think of how Ebay works). You will develop a database to solve this problem You will...

  • database help 2019S_CPS4921 5921 midterm1t [Compatibility Mode Q Search in Document Home Insert Design Layout References...

    database help 2019S_CPS4921 5921 midterm1t [Compatibility Mode Q Search in Document Home Insert Design Layout References Mailings Review Vievw Times New Ro , 12 , A-A, AS, Paste Heading 1 Heading 2 Heading 4 Heading 5 Styles Pane Normal No IV. Similarity test. (15 points) Given the following medical records, plcase find which two pcrsons have the most similar discase and which two persons have the most dissimilar disease. Please write your analysis steps by steps. |You can set Y(yes)...

  • For this course project, you will use various database management and programming techniques to design and...

    For this course project, you will use various database management and programming techniques to design and develop an online sales and distribution system for a fictitious organization. There are two phases—you will complete the first phase this week and the second phase in W5 Assignment 2. Rationale The focus of the project is to develop your database programming skills. This project will help you get a fair idea of the sales and distribution system in any organization that has a...

  • need help with this homework please 5. Which of the following problems does a database management...

    need help with this homework please 5. Which of the following problems does a database management system seek to solve? (a) Data is too small to fit into an Excel Spreadsheet. (b) Data is too tightly secure in Excel. (c) Excel cannot store characters in our data. (d) When data about a column is updated, it is difficult to do this update in Excel. For problems 6-10, use the table below to answer the remaining questions on the quiz. Customer...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT