Question

D:- Answer the following questions. (2×5=10)
1:- Difine a chart. Name any 5 types of charts.

2:- Distinguish between a bar chart and a column chart.

3:- How many types of DBMS and what are they?

4:- Write short notes on RDBMS.

5:- What is absolute reference?.

All the best ​

Answer 1

Answer:

The Pie Chart

A Pie Chart displays one series of data. A data series is a row or column of numbers used for charting. In the worksheet below, we have outlined a single data series. If we had selected multiple series for the Pie Chart, Excel would ignore all but the first.

Example of a single data series in an Excel worksheet

Single Data Series

Excel uses the row heading (series identifier) for the chart title and displays the data as proportional slices of a pie (1st image below). One can customize the design of the pie chart so either numeric values or their percentages display on top of the slices of pie.

The Column Chart

The Column Chart effectively compares a single set of data points, but it shines when comparing multiple series. Outlined in red, the image below shows the three data series we're charting. Notice that we do not include the totals in our data series.

worksheet image showing multiple data series of Flowers, Shrubs, and Trees

Multiple Data Series

Because Excel uses a different color for each data series, it's easy to see how a single series changes over time, or compare multiple series over a given time period. The Clustered Column Chart is especially popular.

Clustered column chart

The Line Chart

picture of a line chart with markers

The Line Chart is especially effective in displaying trends. The vertical axis (Y-axis) always displays numeric values and the horizontal axis (X-axis) displays time or other category.

The first image shows the Line with Markers chart of our single data series. Markers—the circles, squares, triangles, or other shapes which mark the data points—are optional, and Excel displays a unique marker in shape and/or color for each data series.

Answer 2

Explanation:

1.Types of Charts

The four most common are probably line graphs, bar graphs and histograms, pie charts, and Cartesian graphs. They are generally used for, and are best for, quite different things. You would use: Bar graphs to show numbers that are independent of each other.

2.Bar Charts vs Column Charts

The only difference is that the bar chart is presented horizontally (with values on the x axis and categories on the y axis) while the column chart is represented vertically (with values on the y axis and categories on the x axis).

3.Four types of database management systems

hierarchical database systems. network database systems. object-oriented database systems.

4.An RDBMS is a type of database management system (DBMS) that stores data in a row-based table structure which connects related data elements. An RDBMS includes functions that maintain the security, accuracy, integrity and consistency of the data. This is different than the file storage used in a DBMS.

5.When relative cell references are copied to more than one row or column, they change depending on their position, which is useful for performing the same calculation in each row or column. In contrast, the definition of absolute cell reference is one that does not change when it's moved, copied or filled.

follow me

thanks my answer dear friend