All categories

4 years ago

What is one advantage of using a relational database over a spreadsheet or flat file to store data?

2 answers:

8 0

A relational database<span> 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 </span>database<span> tables. There are several advantages of using a relational database over a spreadsheet or flat file to store data. Some of them are:
</span><span>- No multiple record changes are needed
- The storage is more efficient storage
- It is simpler to delete or modify details.<span>
</span></span>- Complex queries can be carried out<span>.
</span>- Better security.

Paraphin [41]4 years ago

6 0

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

You might be interested in

Ou have an application running on Oracle Cloud Infrastructure. You identified that the read and write operations are slowing you

Otrada [13]

Answer:

Options A and C.

Explanation:

In Oracle Cloud Infrastructure the two options which allows you to increase disk performance are;

1. Terminate the compute instance preserving the boot volume. Create a new compute instance using a VM Dense IO shape using the boot volume preserved.

2. Create a backup of the boot volume. Create a new compute instance a VM Dense IO shape and restore the backup.

3 0

3 years ago

Comments should be written in what type of language

jeyben [28]

Comment should always be answered in the prospective language the question is asked.

8 0

3 years ago

How can you say that a computer is a versatile machine?

Jobisdone [24]

Answer:

A computer is a versatile machine because is used for many purposes,a modern day computer can run multiple data at once making a fast and efficient machine very durable and effective for our use in all areas of life.

8 0

4 years ago

With the _______ network topology, reliability is the major advantage while high cost is the disadvantage.

WINSTONCH [101]

<span>With the mesh network topology, reliability is the major advantage while high cost is the disadvantage.
Because of its reliability advantage mesh topology is used in backbone networks, because of the redundancy the failure of one node in the network does not result in failure of the entire network. However lot of cabling is required and the cost and maintenance requirements are high.

</span>

7 0

3 years ago

If one employee is assigned to a project and each project has only one employee working on it, there is a(n) ____ relationship b

Len [333]

Answer:

One-to-one is the answer because there is one project and one employee working on one project.

5 0

3 years ago