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?
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
According to Lee (2004) Which of the following would NOT be consistent with his JIT rules...
According to Lee (2004) Which of the following would NOT be consistent with his JIT rules of thumb? A. Do not develop collaborative relationships with suppliers and customers in order to make it easier to assert power in the channel. B. Provide continious data on changes in suplpy and demand. C. Ensure the logistics systems can react to unexpected needs. D. All the above are consistent with Lees recommended Rules of Thumb
1. Which of the following is the standard for determining whether to terminate an employee based...
1. Which of the following is the standard for determining whether to terminate an employee based on the severity of the employee's violation of rules or company policy? A.Employment at will B.Internal employee relations C. Just cause D.Discipline E.Hot stove rule 2.What is the name of the process for facilitating employee departures from the company that ensures that all required forms are completed and company property is returned? A.Downsizing B.Offboarding C.Transfer D.Demotion E.Postexit questionnaire