​Structure of the ORDERITEMS Table

question 125

Multiple Choice

​Structure of the ORDERITEMS table

-Based on the structure of the ORDERITEMS table,which of the following commands will make certain that the ISBN entered actually exists in the ISBN column of the BOOKS table?​

• A) ALTER TABLE orderitems ADD FOREIGN KEY isbn REFERENCES BOOKS TABLE (isbn);
• B) ALTER TABLE orderitems MODIFY FOREIGN KEY (isbn)REFERENCES books(isbn);
• C) ALTER TABLE orderitems CREATE FOREIGN KEY (isbn)REFERENCES books(isbn);
• D) ​ALTER TABLE orderitems ADD FOREIGN KEY (isbn)REFERENCES books(isbn);

---

Definitions:

Oral Stage

The first stage in Freud's psychosexual development, occurring in the first year of life, where pleasure is centered on oral activities such as sucking and biting.

Anal Stage

In psychoanalytic theory, the second stage of psychosexual development, occurring from about 18 months to three years of age, where the focus of pleasure is on controlling bladder and bowel movements.

Oedipal Stage

A phase in Freudian psychosexual development when a child feels a desire for the opposite-sex parent and jealousy towards the same-sex parent.

Freud

Sigmund Freud was an Austrian neurologist and the founder of psychoanalysis, a clinical method for treating psychopathology through dialogue between a patient and a psychoanalyst.