Relational databases have a more logical structure related to how they are stored.
Application programs to access relational databases are easy to create and develop compared to using flat-file databases.
<h2>Further Explanation
</h2>
The database is a collection of data that are stored systematically in a computer that can be processed or manipulated using software (application programs) to produce information. Defining a database includes specifications in the form of data types, data structures and also restrictions on the data which is then stored.
The database is a very important aspect of the information system because it functions as a data storage repository for further processing. The database is important because it can organize data, avoid duplication of data, avoid unclear relationships between data and complicated updates.
DBMS is a software system that enables database users to maintain, control and access data practically and efficiently. In other words, all access to the database will be handled by the DBMS. This DBMS becomes the layer that connects the database with the application program to ensure that the database remains consistently organized and can be easily accessed.
Division of databases according to type, databases can be divided into:
- Flat-file databases are ideal for small data and can be changed easily. A flat-file database is composed of a group of strings in one or more files that can be parsed to get the information stored. Flat-file databases are suitable for storing lists of data that are simple and in small amounts. Flat-file databases will be very complicated when used to store data with complex structures even though it is also possible for that.
- Relational databases have a more logical structure related to how they are stored. The word "relational" comes from the fact that the tables in the relational database are linked to each other. A relational database uses a set of two-dimensional tables, each table arranged in rows (tuples) and columns (attributes). To create a relationship between two or more tables, a key (key attribute) is used, the primary key in one table and a foreign key in another table. At present, relational databases are the first choice because of their advantages. Application programs to access relational databases are easier to create and develop compared to using flat-file databases.
<h2>
Learn more
</h2>
definition of relational database brainly.com/question/4255855
definition of flat-file database brainly.com/question/4255855
definition of database brainly.com/question/4255855
definition of DBMS brainly.com/question/4255855
<h2>
Details
</h2>
Grade: College
Subject: Computers and technology
keywords: relational database, flat-file database, database, DBMS
