When Transforming an ID-Dependent E-R Data Model Relationship into a Relational

question 49

Multiple Choice

When transforming an ID-dependent E-R data model relationship into a relational database design,the referential integrity constraints should allow ________.

• A)parent updates to cascade
• B)child updates to cascade
• C)child deletes to cascade
• D)A and B
• E)A,B,and C

---

Definitions:

Market Inefficiencies

These are situations where the current price of a security does not fully reflect all available information, potentially allowing investors to earn above-average returns.

Ask Price

The minimum price a seller is willing to accept for an asset or security.

Sell

The act of transferring ownership of a security or asset from a seller to a buyer in exchange for cash or other forms of payment.

Security

A financial instrument representing an ownership position in a publicly-traded corporation (stock), a creditor relationship with a governmental body or a corporation (bond), or rights to ownership as represented by an option.