Data Process In Database

Data Pre-Processing

• Data Cleaning
• Remove duplicate records / duplicate data rows / duplicate data entries.
• Fix error data entry and inconsistent data entry format.
• Handle missing values.
• Data Transformation
• Standardizing and normalizing data, e.g. units of measure.
• Data Reduction
• Reducing the size or complexity of data while preserving its essential information.
• Data Integration
• Harmonizing data, to eliminating discrepancies and inconsistencies from a common set of format standards and definitions.
• Merging data.

Create And Add Data To Database Table

• Use A Database.
• Create A Data Dictionary.
• Review And Implementing Database Schema, DFD (Data Flow Dictionary), ERD (Entity Relationship Diagram).
• Add Each Data To Database.
• Use The Comment Section In SQL File To Add Notes If Needed.
• Add An Attachment File Or Blob File Or Binary Data, If Needed And Your Database Management Is Supported.
• Add The Table Field.
• Enforce Rules And Constraint.

Show Data Process From Database Table

• Open A Table
• Search For A Data.
• Filter The Data List.
• Show Or Hide A Field Column.
• Display The Data From Joined Table.

Bibliography

http://ub.ac.id/ ( university )

https://www.datatopolicy.org/