Explain the meaning of cardinality as it relates to database design
What will be an ideal response?
Cardinality refers to the number of records allowed in a related table. A business, for example might have a rule that each customer can have no more than three emails listed. So the Email entity would have a maximum cardinality of three. DBMSs, however, do not generally have the relational tools to enforce these cardinality limits. At most they can specify that at least one record is required. To enforce cardinality rules usually requires the use of triggers or other programming.
You might also like to view...
Carter's assets on December 31, 2007 are:
Carter Company compiled the following financial information as of December 31, 2007: Revenues..........................$140,000 Common stock ....................30,000 Equipment ...........................40,000 Expenses .............................125,000 Cash ......................................35,000 Dividends ..............................10,000 Supplies ...................................5,000 Accounts payable ...................20,000 Accounts receivable ...............15,000 Retained earnings, 1/1/07 ......75,000 a. $235,000 b. $170,000 c. $ 80,000 d. $ 95,000
A real estate license may be suspended or revoked for
A) specifying a definite termination date in a listing contract. B) failing to properly account for the license holder's business expenses. C) publishing an advertisement that may create a misleading impression. D) including "owner/agent" in an advertisement to sell the license holder's own home.