answersLogoWhite

0

In database management, a flat file is one that holds all the information in a single table.

By contrast, a relational database has two or more tables having a defined relationship to each other.

A flat file is not related to any other table.

Examples

Flat file

You could keep details of a DVD collection in a flat file. Some of the fields might be:

title

date purchased

length

year issued

Relational database

A retail business might have a database with three tables:

products [one record for each type of item for sale]

customers

products&customers [each sale constitutes a record in this table. The table is related (linked) to each of the other two tables]

Tables and files

"Table" is a database term, "file" a computer term. Some database management programs make each table into a separate file. Others store all the tables in a single file.

User Avatar

Wiki User

16y ago

What else can I help you with?

Continue Learning about Engineering

What is a flat file in metal workshop?

A hand file where both surfaces are flat. Used to file down metal where the surface requires a flat finish. Other files in the work shop are curved concave, curved convex ,triangular and square. Each used to specific shape filing.


What are the row and column separations in Flat Files?

In a flat file, the most common separation between columns will be either a comma or a tab. You could theoretically use anything you wanted, so long as you read it in knowing this. Rows in a flat file are separated with newline characters. (In other words, each row is a line in the text file.)


Text files and binary files are considered to be WHAT files?

different files


What is meaning of word persistence in java?

Persistence is the term used to refer to the situation where the objects data is stored even after the object is destroyed or the application is closed. Persistence is implemented using Serialization where the data of the object is serialized into flat files and stored into the system. These files can be de-serialized to form the objects by using de-serialization.


How does an engineers file work?

An engineer's file is a hand tool used to shape, smooth, or finish materials like metal or wood. It consists of a hardened steel bar with a series of ridges or teeth cut into its surface, allowing for material removal through abrasion. Files come in various shapes and sizes, each designed for specific applications, such as flat, round, or half-round. The effectiveness of a file depends on its coarseness, with coarser files removing material faster, while finer files provide a smoother finish.

Related Questions

How do use flat files?

Flat files are used to store data in a simple, structured format, typically as plain text or CSV files. They can be read and manipulated by various programming languages and tools, making them ideal for data interchange and storage. To use flat files, you typically open the file for reading or writing, parse the data as needed, and then process it according to your application’s requirements. Flat files are often utilized for data import/export, logging, or as a lightweight database alternative.


Where can you purchase Safco Flat Files?

Safco Flat Files can be quite expensive, and shipping can cost a lot if you order online. You can purchase a cheap one at Global Industries, or a very expensive one at Rakuten.


Where would one shop for flat files for storing artwork?

There are a number of places from which flat files for storing artwork can be purchased. Dick Blick, Supaprice and Amazon are three of these. Cheaper deals may also be found at eBay.


Which file system will stores all files at same level?

flat file system


Describe the various types of file that are available and the cut of files for different applications.?

Files come in various types, including flat files, CSV files, XML files, JSON files, and binary files, each serving different purposes. Flat files and CSV files are often used for simple data storage and transfer, while XML and JSON files are preferred for structured data interchange, especially in web applications. The cut of files varies, with options like bastard cut (coarse), single cut (medium), double cut (fine), and needle files for precision work, each suited for specific applications in shaping or smoothing materials. Choosing the right type and cut of file is crucial for achieving desired results in tasks such as metalworking, woodworking, or data management.


Where can you purchase a flat file?

Flat files can be purchased from many different retailers and websites. One could try websites such as: Global Industrial, I Buy Office Supply and School Furniture of Canada.


What is the difference between flat file and DBMS?

A flat file is a simple file containing data without any structured format, while a Database Management System (DBMS) is a software system that manages databases by organizing, storing, and retrieving data. A DBMS allows for more organized and efficient data management, supports relationships between data, and provides features like security and data integrity that are not available with flat files.


What advantages do databases have over flat files?

1. files are can easily get damaged for e.g by water or fire and etc but a data base cant so easily get damaged you can find delete or edit files on the data base easily while if you hv a big file it is hard


What are bastard half rounded files?

A Half Round Bastard File is a tool designed for use on concave, convex and flat surfaces.


What is a flat file in metal workshop?

A hand file where both surfaces are flat. Used to file down metal where the surface requires a flat finish. Other files in the work shop are curved concave, curved convex ,triangular and square. Each used to specific shape filing.


What are the various types of hand files?

Hand files come in several types, each designed for specific tasks. The main categories include flat files, round files, half-round files, square files, and triangular files, each varying in shape and size to accommodate different contours and surfaces. Additionally, files can be categorized by their cut, such as single-cut or double-cut, which affects the coarseness and finish of the material being worked on. These tools are commonly used in woodworking, metalworking, and various crafts for shaping, smoothing, and finishing surfaces.


Minecraft seed generators for flat areas?

You cannot get a seed currently that will make all of the Minecraft world flat, although there is a way to do that. Simply go on the internet and find a flat land world. You have to put it in your Minecraft files and then you can play of a completely flat world.