Question

When using a relational database what makes data formatting so important and critical to the functions of a table?  Discuss some examples you can think of (e.g. why would multiple date formats potentially cause issues)?

Answer 1

A relational database is a collection of tables, each of which is assigned a unique name each table consists of attributes and usually stores a large set of tuples. Each tuples in a relational table represents an object identified by a unique key and described by a set of attribute values.

Data mining have 6 technique:

1.Data cleaning

2.Data integration

3.Data transformation

4.Data reduction

5.Data discretizion

6.Conceptual hierarchy

1)Data cleaning:

The data cleaning technique is used to fil a missing value, smoothing noisy data, correcting, finding outlayers.

2)Data integration:

Data integration means merging the data from multiple sources into a cohent store like data warehousing

3)Data transformation:

Data transformation we consdidate or transform data to form appropriate to data

4)Data reduction:

It is a technique that is applied to obtain reduced representation of the data set.

5)Data discrization'

Discrization can be used to reduce number of values of attribute of a continuous attribute, by dividing the range of attribute.

6)Conceptual hierarchy:

Conceptual hierarchy is used to reduce data by collecting and replacing lower level values concepts with higher level.

Conceptual

-