How to Handle Missing Data in a Database?
One way to deal with missing data in a database is to:
Ignoring: During analysis, ignoring rows with missing values.
Imputing is the process of substituting a default value, mean, median, or value obtained from additional data for missing variables.
Elimination: Taking out rows or columns that contain a significant number of missing values.
Using Placeholders: Using a particular placeholder to indicate missing values
| Is This Answer Correct ? | 0 Yes | 0 No |
What is meant by system analysis?
What is a database report?
What is the most popular database?
what are the two integrity rules used in DBMS?
Explain the difference between a primary key and a unique key?
What is sonicmq?
What is default value database?
What is cursor and where do you use them?
Explain armstrong rules? How they are complete and/or sound?
What is 2nf in dbms?
How can I access my database remotely?
Explain primary key and composite key.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)