Designing the fields in the data base, Database Management System

Designing the fields in the data base

The following are the considerations one has to remain in mind while designing the fields in the data base.

  • Coding, compression, encryption
  • Choosing data type
  • Controlling data integrity
  • Default value

         -     Range control

         -     Null value control

         -     Referential integrity

  • Handling missing data

        -       Trigger a report listing missing values

        -      Substitute an estimate of the missing value

        -      In programs, ignore missing data unless the value is significant.

 

 

Posted Date: 3/7/2013 6:04:42 AM | Location : United States







Related Discussions:- Designing the fields in the data base, Assignment Help, Ask Question on Designing the fields in the data base, Get Answer, Expert's Help, Designing the fields in the data base Discussions

Write discussion on Designing the fields in the data base
Your posts are moderated
Related Questions
What is ICR? A. ICR (Intelligent Character Recognition) is a technology that gives scanning and imaging systems the ability to identify images of hand-printed or script charact

SELECT Statement This statement is used for retrieving information from the databases. It can be coupled with many clauses. Let us talk about these clauses in more detail:

Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))

Explain query execution plan? - Optimizer available in SQL Server optimizes code to be effectively executed. - A query execution plan demonstrates how this optimizer would r

Data Warehousing & Mining 1. What is the concept of knowledge discovery in database? 2. Describe the following types of Multidimensional Data Models. • Stars, Snowflakes and

Discuss deferred update technique of recovery.  What are the advantages?  Ans:  The deferred update methods do not physically update the database on disk till after a transact

Law Associates is a large legal practice based in Sydney.  You have been asked to design a data model for the practice based upon the following specification: The practice emplo

I have 10+ yrs exp in oracle Sql ,Pl/SQl,Forms ,Reports. I am expert in assignements & Online tutoring so i want to join you. Please guide me. Thanks Brajesh Shukla +91 9899641535

Which of the operations constitute a basic set of operations for manipulating relational data? Relational algebra operations constitute a basic set of operations for manipulati

Determine the advantage of object-orientation Finally, object-orientation has advantage of continuity throughout analysis, persistent representation and design implementation.