a) Which table is the primary table and which table is the secondary table in th

Question

a) Which table is the primary table and which table is the secondary table in the one-to-many relationship?

b) What will happen if you attempt to add a new Book Rep with BR# of 75 to the Book Rep table?

c) What will happen if you attempt to add a new customer with BR# of 85 to the Customer table?

d) What will happen if you attempt to delete BR# 48 from the Book Rep Table

e) What will happen if you attempt to delete BR #65 from the Book Rep table?

a) Which table is the primary table and which table is the secondary table in the one-to-many relationship? b) What will happen if you attempt to add a new Book Rep with BR# of 75 to the Book Rep table? c) What will happen if you attempt to add a new customer with BR# of 85 to the Customer table? d) What will happen if you attempt to delete BR# 48 from the Book Rep Table e) What will happen if you attempt to delete BR #65 from the Book Rep table?

Explanation / Answer

1.Customer is secondary table Book Rep is primary table
2.A new row will be inserted with BR#75
3 .there is no br# 85 in book rep table
4. BR #48 will be deleted from book rep table
5. eror will happen there are customer records with BB #65.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.