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

question 28

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)Both A and B are correct

---

Definitions:

Hydromechanical Transmission

A transmission system that combines hydraulic and mechanical components to transfer power from the engine to the wheels.

Inhibitor Valve

A type of valve designed to regulate or stop fluid flow under specific conditions to protect systems from damage or to control processes.

Planetary Gearsets

A system of gears consisting of one or more outer gears (planet gears) revolving around a central (sun) gear.

Allison Transmission

A brand name for a series of automatic transmissions for commercial vehicles, known for durability and reliability.