Outline the traditional problems associated with the flatfile model that are resolved by the database model.

Expert Solution

FLAT FILE VS DATABASE MODEL

The problems with flat files that are resolved by Database technology include:

Data Storage --- Flat files result in considerable data redundancy and storage problems

Data Updating -- When users keep separate files, all changes must be made separately for each user. This adds significantly to the task and the cost of data management.

Currency of Information -- If update information is not properly disseminated, the change will not be reflected in some users’ data, resulting in decisions based on outdated information.

Task-Data Dependency -- The user’s information set is constrained by the data that he or she possesses and controls

Flat Files Limit Data Integration -- The flat-file approach is a single-view model. Files are structured, formatted, and arranged to suit the specific needs of the owner or primary user of the data.

Junaid answered 10 months ago

* when to use a database instead of a flat file * What the primary characteristics...

* when to use a database instead of a flat file * What the primary characteristics of a structured database Use Rows (records)and Columns (Fields) to store records * What is the difference between non-structured and semi-structured data * What is the key structures in a relational database * what is the differences between a primary key and a foreign key a table in a database must have 1 primary key and can have several foreign keys * Know the...

Explain the similarity and difference between the data update and information currency problems associated with flat files.

Use Excel to develop a regression model for the Hospital Database (using the “Excel Databases.xls” file...

Use Excel to develop a regression model for the Hospital Database (using the “Excel Databases.xls” file on Blackboard) to predict the number of Personnel by the number of Births. Perform a test of the overall model, what is the value of the test statistic? Write your answer as a number, round your answer to 2 decimal places. SUMMARY OUTPUT Regression Statistics Multiple R 0.697463374 R Square 0.486455158 Adjusted R Square 0.483861497 Standard Error 590.2581194 Observations 200 ANOVA df SS MS...

to critically analyze some of the problems associated with basing depreciation expenses on cost model and...

to critically analyze some of the problems associated with basing depreciation expenses on cost model and detrimental impact of fair value based revaluation model.

Database design is the process of producing a detailed data model of database. This data model...

Database design is the process of producing a detailed data model of database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database. (Wikipedia). Using a diagram/chart software, elaborate a database design Requirements: Define your database objective Explain your database's type of table relationship Explain and design your database elements and datatypes (tables, fields, etc,)....

Flat affect and catatonia are symptoms most closely associated with

Flat affect and catatonia are symptoms most closely associated with 1. obsessive-compulsive disorder. 2. antisocial personality disorder. 3. schizophrenia. 4. bipolar disorder.

According to the following article? What types of structural problems need to be resolved when the...

According to the following article? What types of structural problems need to be resolved when the two organizations are merged? Both A and B are two large sales companies, and B was acquired by Company A due to poor management. Both companies have a similar organizational structure - function-based design.However, after the acquisition of the new company, it suddenly increased a lot of shops and employees.After the completion of the acquisition of the new company, get an increase of many...

The Coase Theorem argues that: Externality problems will always be resolved via negotiation and will never...

The Coase Theorem argues that: Externality problems will always be resolved via negotiation and will never require government intervention to correct. Externality problems will never be resolved via negotiation but will often require government intervention to correct. Externality problems will sometimes be resolved via negotiation and will always require government intervention to correct. When many individuals are involved, externality problems will be corrected without government intervention.

(C++) Write a program to read from a grade database (data.txt). The database (text file) has...

(C++) Write a program to read from a grade database (data.txt). The database (text file) has students names, and grades for 10 quizzes.Use the given function prototypes to write the functions. Have main call your functions. The arrays should be declared in main() and passed to the functions as parameters. This is an exercise in parallel arrays, int and char 2 dim arrays. Function prototypes: int readData(ifstream &iFile, int scores[][10], char names[][30]); This functions takes the file stream parameter inFile...

three problems associated with pregnant adolescents.

Question