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

Describe identifying relationship? Identifying relationship: It is relationship among strong entity and a weak entity it is represented through a doubly outlined diamond in C

Relational Algebra is a set of basic operations used to influence the data in relational model. These operations allow the user to specify basic retrieval request. The result of re

Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both

Do you have experts of the dbms

Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

Define granularity, hierarchy of granularity of locks & multiple granularity locking. Explain the modified two phase locking along with multiple granularity locking. Ans: The s

Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs

What is Distributed system ? Distributed System - A distributed system consists of a number of processing parts in which are interconnected through a computer network and in

There are many simple and complex approaches to implement. These reports are based on some views or certain query. The following number of reports can be built. 1. The averag