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
A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of Ame

In this programming assignment, you will develop a simple database of student records. Here are the requirements: 1) A student record contains a name and a number. We assume tha

What is deadlock? Neither of the transaction can ever proceed with its normal implementation. This situation is known as deadlock.

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

XYZ is a large chain of home entertainment rental over 100 stores distributed over all states in Australia. XYZ lends entertainment products such as movies, TV shows and games on v

what are the main characteristics of database

For this application, we will consider IBM DB2 catalog data (i.e., metadata) for IBM's enterprise-class servers running the z/OS (formerly OS/390 or MVS) operating system.  One of

Let consider the given partial relation EMP. Let us make some sub-queries for them EMPNO ENAME JOB SAL DEPTNO 7566

Increases efficiency : Data is stored close to most often used site, therefore retrieval would be faster. Also, data that is not required by local applications is not stored, there

What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the