Describe the problems that may occur when integrating relations

What will be an ideal response?


Four problems may arise: synonyms, homonyms, dependencies between nonkeys, and class/subclass relationships. Synonyms are when two or more attributes may have different names but the same meaning, as when they describe the same characteristic of an entity. In other situations, a single attribute name, called a homonym, may have more than one meaning or describe more than one characteristic. For Dependencies between Nonkeys when two 3NF relations are merged to form a single relation, dependencies between nonkeys may result. Class/Subclass relationships may be hidden in user views or relations.

Business

You might also like to view...

Explain how linkages between relational tables are accomplished

Business

One way to reduce dependency and thus maintain more autonomy is to ______.

A. rewrite the mission statement B. use a single source of revenue C. diversify the sources of revenue D. lobby for more government assistance

Business

Treasury stock is? ________

A) decreases the number of shares issued
B) increases the number of shares issued
C) increases the number of shares outstanding
D) decreases the number of shares outstanding

Business

Use the following income statement and information about selected current assets and current liabilities for Kimberline Industries to calculate the net cash provided or used by operating activities using the indirect method.KIMBERLINE INDUSTRIESIncome StatementFor Year Ended December 31Sales?  $280,000Cost of goods sold?   124,000Gross profit from sales?  $156,000Operating expenses:??  Salaries and wages expense  $35,000?  Depreciation expense  11,000?  Rent expense  27,200?  Interest expense    3,900    77,100Income from operations?  $78,900Loss on sale of land?    4,700Net income?  $74,200Increases and decreases of current asset and current liability accounts, all of which relate to operating activities, are as

follows:?  ChangeAccounts receivable increase  $3,600Merchandise inventory decrease  1,700Accounts payable increase  1,100Salaries and wages payable decrease  2,600 What will be an ideal response?

Business