Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Free Preparation Discussions
MENU
Adobe Exam AD0-E318 Topic 1 Question 12 Discussion
Actual exam question for
Adobe's
AD0-E318 exam
Question #: 12
Topic #: 1
[All AD0-E318 Questions]
Topic #: 1
In the database diagram, a company has tables orders products Recipient items.
* Recipient is linked to Orders as 1-N
* Products to Orders as N-N
Recipient ID, Email Full Name, Customer ID Orders: Orders ID, Recipient ID, Product ID, Date of purchase items: Product ID, order ID, item ID products Product ID, Name, Status, Creation Date.
Which columns act as both primary and forgive keys?
Suggested Answer:
A
The Product ID column acts as the primary key for the Products table and as a foreign key for the Orders table. The Order ID column acts as the primary key for the Orders table and as a foreign key for the Items table. The Customer ID, Product ID, and Item ID columns do not act as primary or foreign keys.
Currently there are no comments in this discussion, be the first to comment!