Tags Database Programming Computer Keyboards The Difference Between

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

0

Subjects>Electronics>Computers

Difference between Flat File Database and Relational Database?

Anonymous

∙ 17y ago

Updated: 10/3/2023

a flat file database allows the user to specify data attriutes for on table at a time, storing those attributes independently of an applications. a relational database take this "flat file" approach several logical step further, allowing the user to specify information about multiple tables and the relationships between those tables, and often allowing much more declaratice control over what rules the data in those tables must obey.

Wiki User

∙ 16y ago

Still curious? Ask our experts.

Chat with our AI personalities

Lao

The path is yours to walk; I am only here to hold up a mirror.

Chat with Lao

Coach

Success isn't just about winning—it's about vision, patience, and playing the long game.

Chat with Coach

Ross

Every question is just a happy little opportunity.

Chat with Ross

More answers

A "flat file" database allows the user to specify data attributes (columns, datatypes, etc) for one table at a time, storing those attributes independantly of an application. dBase III and Paradox were good examples of this kind of database in the CP/M and MS-DOS environments, and the original FileMaker was a good Mac O/S example. A relational database takes this "flat file" approach several logical steps further, allowing the user to specify information about multiple tables and the relationships between those tables, and often allowing much more declarative control over what rules the data in those tables must obey (constraints). Credited to http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci976564,00.html

Wiki User

∙ 17y ago

Add your answer:

Earn +20 pts

Q: Difference between Flat File Database and Relational Database?

Write your answer...

Submit

Still have questions?

imp

Trending Questions

What does E-mail etiquette mean? Knowing the best computer? The accuracy of a computer's output depends on the accuracy of the input? Can you use a kindle while it's charging? What can you do to help Meerkats? When connect switch to switch which cable to use? Where can someone find an authority certificate for their computer? What basic operating system feature does a concurrent server use to handle requests from multiple clients simultaneously? How to connect PS2 controller on a PC? Where can one look up addresses by name? When was The Ultimate Computer created? How many cups make 1 cup cooked noodles? The blank is jenne is composed of adobe bricks? Where can one buy an industrial LCD monitor? Are rats scared of other animals? How do you troubleshoot video adapter card? What type of computer virus is capable of making scary faces pop up randomly on the screen after it has gone grey? How an organization with computer operates and is structured? How do you enhance the images downloaded from YouTube video files for playback in DVD player? What is a periodical publication on a computer network called?

Related Questions

Which term does a user of a relational database use to refer to a file?

A user of a relational database typically refers to a file as a "table." Tables in a relational database store data in rows and columns, following a structured format to allow for efficient data storage and retrieval.

Difference between flat file and database file?

DATABASE FILE - is one that is stored on a server and it is in the format that the database needs to read it. It is stored in the database catalog......

Does the Microsoft Access use a relational or flat-file model?

Access can use a relational model of a database design.

The developer of a relational database refers to a file as an?

In the context of a relational database, a file is commonly referred to as a table. A table is structured in rows and columns to store related data in a database system. Each table represents a specific entity or concept within the database.

What is database in access?

An Access database is a relational database contained in a single file that you can upload to a directory on your Web server. People typically create an Access database file using Microsoft Access or FrontPage.

What is a database in access?

An Access database is a relational database contained in a single file that you can upload to a directory on your Web server. People typically create an Access database file using Microsoft Access or FrontPage.

What is the difference between flat file and relational databases?

Flat file databases store data in a single table or file without any relationships between the data. Relational databases organize and store data in multiple tables that are related to each other using keys, allowing for more complex querying and data manipulation. Relational databases provide greater data integrity, scalability, and flexibility compared to flat file databases.

What is the Difference between a database and a database server?

A database is a file. A database server is a computer that shares that file over a network.

The developer of a relational database refers to a file as?

In the context of a relational database, a file is typically referred to as a table. Tables are used to store structured data in rows and columns, allowing for efficient organization and retrieval of information. Each table represents a distinct entity or concept within the database schema.

Is Quickbooks a relational database?

Sometime in 2011 or 2012 Intuit upgraded QuickBooks, replacing its flat file system with SQL Anywhere from Sybase iAnywhere, allowing QuickBooks to store data in a relational database format.

Methods of allocating disk space?

what is the difference between a file system and a database system?

Difference between database file and flat file in DBMS?

Database file is one that is stored on a server and it is in the format that the database needs to read it. It is also stored in the database catalog. A flat file is one that is dumped from a database to import or export into another database or program. A flat file is fields of data separated by delimiters, which keep the fields separated for export/import.

Still have questions?

imp

Resources

Top Categories

Product

Company

Copyright ©2025 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.