StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

How a Specification for a Field Will Be Determined - Assignment Example

Cite this document
Summary
The assignment "How a Specification for a Field Will Be Determined" states that the specifications of a field are decided on the basis of its use and function in Relational Databases Management Systems (RDBMS). “Field specifications help establish and enforce field-level integrity”…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER92.7% of users find it useful
How a Specification for a Field Will Be Determined
Read Text Preview

Extract of sample "How a Specification for a Field Will Be Determined"

Nazneen (2009) explains, “Field type depicts the data type of the field”. For example, a relationship may not be established or may not function correctly if we have selected Number as a field type for the primary key attribute and Text field type is selected for the foreign key attribute. 3. Why are field values coded or compressed? A coded field represents a corresponding value stored in a separate relation. Coded fields serve several different purposes, which depends on their implementation.

Usually coded fields are introduced to save time and space in RDBMS. For example, we have a code_employee_type attribute in a relation. This field will be populated depending on the selection of a combo box item, named as an employee category on a data entry form. 4. What means are available to control the integrity of fields? The integrity of the field ensures the entry of predefined data types and formats in an attribute. A user is bound to enter data incorrect data type and format while entering using Data Entry Form.

There are several tools available, which restricts incorrect data entry or in some cases, users can only select from the available list of items/values in a List, Combo, Radio or Checkbox control, etc. 5. How can possible missing field values be handled? Blank or missing fields are those fields where a record does not contain any data. Missing fields can be avoided by introducing compulsory data entry controls, but it is often impossible or undesirable because of user convenience and usability considerations.

Missing fields can be populated on-the-fly by default values or in some cases by using auto-increment specifications. 6. Why might normalize relations not translate into efficient physical records? Normalized tables usually do not translate into efficient physical records because normalization decomposes larger tables into smaller ones and the query generates a record based on the unique field in all related tables. Hernandez observes the fact and states, “The physical order of the record or field in a table is completely immaterial and each record in a table is identified by a field that contains a unique value” (2003).

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(How a Specification for a Field Will Be Determined Assignment - 1, n.d.)
How a Specification for a Field Will Be Determined Assignment - 1. Retrieved from https://studentshare.org/information-technology/1575163-schema
(How a Specification for a Field Will Be Determined Assignment - 1)
How a Specification for a Field Will Be Determined Assignment - 1. https://studentshare.org/information-technology/1575163-schema.
“How a Specification for a Field Will Be Determined Assignment - 1”, n.d. https://studentshare.org/information-technology/1575163-schema.
  • Cited: 0 times

CHECK THESE SAMPLES OF How a Specification for a Field Will Be Determined

Portfolio Project Part 5

Exact materials handled by accountants usually vary depending on size of the organization and the specification of a particular accountant (Bragg and Roehl-Anderson, 2011).... However, the requirements and specification of this job usually vary on specification and nation (ACCA…, 2007).... Therefore, with different financial needs of different companies, the training accountant will be trained in different firms to have knowledge on how to handle different firms depending on size and financial needs....
4 Pages (1000 words) Essay

Lifting Device Using Renewable Sources of Power

The author of the present term paper "Lifting Device Using Renewable Sources of Power" underlines that agriculture being a dominant occupation among developing nations require the usage of water which may be available either as flowing over land or groundwater.... hellip; Reportedly, most of the areas wherein flowing water becomes a scarcity, farmers are forced to utilize water available underground....
6 Pages (1500 words) Term Paper

Person Specifications Employed in the Recruitment Process

It is to be determined what each task requires in terms of knowledge, skills and personal qualities and how those skills, knowledge and personal knowledge could be acquired.... The paper 'Person Specifications Employed in the Recruitment Process" discusses that a Person specification is easy to design and is derived from the job description and describes the knowledge, skills and attributes that are needed to perform the job.... In this paper we will try to understand the term 'person specifications and competency framework', how it works in the context of recruitment and the relative strengths and weakness of person specification and competency framework in the recruitment process....
8 Pages (2000 words) Research Paper

Personal Specifications and Competency Frameworks in HRM

a specification of the range of contexts in which competence is to be demonstrated is not, however, a substitute for an assessment of competence which reflects the influence of the organizational climate/environment on an individual's actions/behavior (Wood and Payne, 1998).... Second, those strong occupational sector-specific criteria are also to the fore, and third, that some considerable individuation occurring either through organization-determined or individual needs would also be present in any actual job description that applies to a particular manager in a particular organization (Wood and Payne, 1998)....
10 Pages (2500 words) Research Paper

Also related to Electronic Engineering

EMI or Electromagnetic interference is a naturally occurring phenomenon when the electromagnetic field of one particle or device interrupts, hinders or corrupts the electromagnetic field of another particle or device by coming into proximity with it.... A successful system should be able to perform well and must be reliable for a good period of time....
3 Pages (750 words) Essay

The Change in Management Accounting Technique

Research in management accounting has recently taken an up-scale as the scholars and practitioners in this field have realized the importance of the study to various companies, businesses and learning institutions.... It is also a fact that, an accounting system which is well… It is a fact that management accounting has a lot of importance to companies, however, experts in this field have reported that management accounting has changed more slowly than enough to It is for this reason that many researchers are now working towards the process of management accounting change....
9 Pages (2250 words) Essay

Design Process, Stages and Its Benefits

Product design specification, as the name suggests, is a specification of what is needed but not the specification of the product itself.... The "Design Process, Stages and Its Benefits" paper analyzes Concept Design as an aspect of product design specification into great detail.... It is imperative to note that product design specification is one of the important elements of managing the life cycle of a product since it is the first boundary in product development....
10 Pages (2500 words) Research Paper

Designing the Closed-Circuit Television System for Gold Storage Facility

The paper that follows illustrates how the CCTV systems will be installed to monitor a gold storage facility.... … The paper "Designing the CCTV System for Gold Storage Facility" is a good example of a term paper on design and technology.... In recent years, CCTV has increasingly gained importance in the UK....
11 Pages (2750 words) Term Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us