A database is used instead of a spreadsheet when ________.

Computers and Technology

1 answer:

Ierofanga [76]3 years ago

5 0

Answer:

C. Lists involve data with multiple themes

Explanation:

First of all, it will be beneficial to explain all the concepts involved.

A spreadsheet is an electronic ledger in which data is arranged in rows and columns of a grid and can be manipulated and used in calculations.

A database can be defined as a structured set of data held in a computer, especially one that is accessible in various ways.

A theme in data storage refers to the subject matter or topic that categorizes various data sets.

A spreadsheet can be used to store and analyse simple data sets as shown in the options A, B and D. However for option C, a database must be used if it needs to be done accurately.

A data base is more robust than a spreadsheet and can accommodate a lot more diversities in the data sets.

Spreadsheets are built to simplify data analysis, and have their candid limitations - they cannot assure data integrity or consistency when dealing with data of various subject matters.

Lists that involve data with multiple themes can be easily handled with data bases, because data bases specialize in collecting raw data in a tabular form which cannot be formatted. This helps sort out the data into their various themes.

The tables on a database can be programmed to accept a particular theme of data, and nothing else. however, this cannot be done with spreadsheets, as the cells accept the data first before it is formatted to the data type it is. Thus databases help ensure consistency and integrity of the data when dealing with data of multiple themes

You might be interested in

A slide show is another name for a PowerPoint presentation. a. True b. False

ruslelena [56]

It is true because a powepoint is a projecter

8 0

3 years ago

Read 2 more answers

2. In many jurisdictions a small deposit is added to containers to encourage people to recycle them. In one particular jurisdict

RUDIKE [14]

Answer:

Here is the Python program:

small_container = int(input("Enter the number of small containers you recycled?"))

large_container = int(input("Enter the number of large containers you recycled?"))

refund = (small_container * 0.10) + (large_container * 0.25)

print("The total refund for returning the containers is $" + "{0:.2f}".format(float(refund)))

Explanation:

The program first prompts the user to enter the number of small containers. The input value is stored in an integer type variable small_container. The input is basically an integer value.

The program then prompts the user to enter the number of large containers. The input value is stored in an integer type variable large_container. The input is basically an integer value.

refund = (small_container * 0.10) + (large_container * 0.25) This statement computers the refund that will be recieved for returning the small and larger containers. The small containers holding one litre or less have a $0.10 deposit so the number of small containers is multiplied by 0.10. The large containers holding more than one litre have a $0.25 deposit so the number of large containers is multiplied by 0.25. Now both of these calculated deposits of containers of each side are added to return the refund that will be received for returning these containers. This whole computation is stored in refund variable.

print("The total refund for returning the containers is $" + "{0:.2f}".format(float(refund))) This print statement displays the refund in the format given in the question. The output includes a $ sign and displays exactly two decimal places by using {0:.2f} where .2f means 2 decimal places after the decimal point. Then the output is represented in floating point number using. format(float) is used to specify the output type as float to display a floating point refund value up to 2 decimal places.