Define entity integrity. What are the two requirements to ensure entity integrity?
Entity integrity is the condition in which each row (entity instance) in the table has its own unique identity. To ensure entity integrity, the primary key has two requirements:
(1) all of the values in the primary key must be unique.
(2) no key attribute in the primary key can contain a null.
You might also like to view...
Auditors need to consider fraud arising from misappropriation of assets and fraudulent financial reporting
a. True b. False Indicate whether the statement is true or false
A state insurance commission requires an insurance company to prepare its financial statements in accordance with Statutory Accounting Principles. This situation may prevent an auditor from issuing a special report on the financial statements as the Statutory Accounting Principles are not a recognized alternative comprehensive basis
a. True b. False Indicate whether the statement is true or false
A contract to pay for lawn care services costing $1,500 would have to be in writing or in proper electronic form to be enforceable
a. True b. False Indicate whether the statement is true or false
The setup cost to make a carpet is $20 per setup. The holding cost is $2.00 per yard per year, and the annual demand is 12,000 yards. The manufacturing facility operates 300 days, and 120 yards of the carpet are produced per day. Given this information, what is total annual carrying cost?
a. $600 b. $500 c. $400 d. $300