Respuesta :

LearnGrow
A relational database is a digital database. It is collection of data items organized in tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. There are several advantages of using a relational database over a spreadsheet or flat file to store data. Some of them are:
- No multiple record changes are needed
- The storage is more efficient storage
- It is simpler to delete or modify details.
- Complex queries can be carried out.
- Better security. 
WeAreHelping

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.

Further Explanation

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.

Learn more

definition of relational database https://brainly.com/question/4255855

definition of flat-file database https://brainly.com/question/4255855

definition of database https://brainly.com/question/4255855

definition of DBMS https://brainly.com/question/4255855

Details

Grade: College

Subject: Computers and technology

keywords: relational database, flat-file database, database, DBMS

Otras preguntas