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
Database Administrator One of the main perpose for having the database management system is to have control of both data or programs accessing that data. The person having li

Fundamentals of Database Management 1. Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? 2. With a necess

What is Oracle databse structure? Oracle database structure: The relational model has three main aspects: Structures: Structures are well-defined objects which store th

What are the advantages and disadvantages of merging an association into a class?  Advantages: i)  Less number of tables ii) Faster performance due to the fewer tables

Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve

Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on

Describe the shadow paging technique.

, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created

(a) Explain briefly the three parts of a relational Model. (b) Contrast the following terms with an appropriate example: (i) stored attribute v/s derived attribute (ii) en

What is an entity relationship model? The entity relationship model is a set of basic objects known as entities and relationship between those objects. An entity is a thing or