Question

Which of the following data integrity rules ensures that a field contains a value if it...

Which of the following data integrity rules ensures that a field contains a value if it is required?

Data format

Range

Consistency

Completeness

Homework Answers

Answer #1

Correct Answer:

Option (2) Range is the correct answer because under the range the field contains a value. The range can be calculated by using the formula that is the larger value minus smaller value. For example if there are 8,9 ,7 ,11, 15,20 , then range is 20 - 8 is 11.

Incorrect Answers:

Option (1) Data format is an incorrect answer because under this data can be arranged in suitable form as per business requirement.There are variouse data formats are available.

Option (3) Consistency is an incorrect answer because data used in format must be consistent and it data is inconsistent then decisions may get false results.

Option (4) Completenes is an incorrect answer because the data which is gathered and collected should be complete is all aspect.

So correct answer is an option (2) or Range

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Revisit Shneiderman’s 8 Golden Rules and answer the following questions. Which rules still apply? Which rules...
Revisit Shneiderman’s 8 Golden Rules and answer the following questions. Which rules still apply? Which rules apply but require modification? Do any rules no longer apply? Do we need new rules for Mobile Apps?
Define the EvenNumber class for representing an even number. The class contains: A data field value...
Define the EvenNumber class for representing an even number. The class contains: A data field value of the int type that represents the integer value stored in the object. A no-arg constructor that creates an EvenNumber object for the value 0. A constructor that constructs an EvenNumber object with the specified value. A function named getValue() to return an int value for this object. A function named getNext() to return an EvenNumber object that represents the next even number after...
Which of the following investment rules does NOT use the time value of money concept? Select...
Which of the following investment rules does NOT use the time value of money concept? Select one: a. Internal rate of return b.The payback period c.Profitability index d. Net present value
Which of the following is true about Excel tables? They are created from rectangular data ranges....
Which of the following is true about Excel tables? They are created from rectangular data ranges. The user can add a totals row. The header includes filter buttons. The table is automatically formatted. All of the choices are true. Which of the following is a characteristic of a pivot table? It summarizes data in a range, table, or external data source. It can include multidimensional summaries by designating row and column categories. Users can format the numbers in the Values...
Design a Java class named Polygon that contains:  A private int data field named numSides...
Design a Java class named Polygon that contains:  A private int data field named numSides that defines the number of sides of the polygon. The default value should be 4.  A private double data field named sideLength that defines the length of each side. The default value should be 5.0.  A private double data field named xCoord that defines the x-coordinate of the center of the polygon. The default value should be 0.0.  A private double...
which of the following capital budgeting rules does not use the time value of money concept?...
which of the following capital budgeting rules does not use the time value of money concept? a) NPV b) IRR c) the discounted payback period d) the profitability index E) the payback period Please explain why Thank you
Alice has constructed a document. Bob needs to verify the document's integrity. Which of the following...
Alice has constructed a document. Bob needs to verify the document's integrity. Which of the following data items must they share? Select all that apply. Group of answer choices h) A one-way hash value encrypted with Bob's private key c) Bob's private key e) A randomly generated key encrypted with Alice's public key f) A randomly generated key encrypted with Bob's public key d) Alice's private key a) Alice's public key b) Bob's public key g) A one-way hash value...
Examine the Employees table. Note that the data in the Title field contains redundant values and...
Examine the Employees table. Note that the data in the Title field contains redundant values and therefore is a candidate for a one-field lookup table. Use your Access Query Design View or SQL skills to create a lookup table named Titles with the unique values in the Title field of the Employees table. List the steps you performed to create the lookup table.
You are given an extract of one field from a database. The field has the value...
You are given an extract of one field from a database. The field has the value “11815 N. Diamond Dr.” Which type of data is contained in this field? structured data unstructured data semi-structured data None of the above
1.) Which of the following statements is false? a. Distribution transparency allows a distributed database to...
1.) Which of the following statements is false? a. Distribution transparency allows a distributed database to be treated as a single physical database. b. Transaction transparency allows a transaction to update data at more than one network site. c. Failure transparency ensures that the system will continue to operate in the event of a node or network failure. d. Performance transparency allows the system to perform as if it were a centralized DBMS. e. Heterogeneity transparency allows the integration of...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT