DATABASE FUNDAMENTALS
DATABASE CONCEPTS AND STRUCTURES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
flat file
|
|
record
|
|
table
|
|
field
|
|
entity
|
Detailed explanation-1: -A flat-file database is a database stored in a file called a flat file. Records follow a uniform format, and there are no structures for indexing or recognizing relationships between records. The file is simple. A flat file can be a plain text file (e.g. csv, txt or tsv), or a binary file.
Detailed explanation-2: -A flat file is a collection of data stored in a two-dimensional database in which similar yet discrete strings of information are stored as records in a table. The columns of the table represent one dimension of the database, while each row is a separate record.
Detailed explanation-3: -Unlike the relational database, a Flat File Database stores the data in a single plain text file.
Detailed explanation-4: -A flat file database stores data in a plain text file, with each line of text typically holding one record. Delimiters such as commas or tabs separate fields. A flat file database uses a simple structure and, unlike a relational database, cannot contain multiple tables and relations.
Detailed explanation-5: -Flat files typically comprise text files with no markup, representing relational data by separating it with a comma or other delimiter. This distinction makes flat file databases different from relational databases (also known as SQL databases), which typically use multiple tables to store information.