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

a) Which table is the primary table and which table is the secondary table in the one-to-many relationship?
   Customer is secondary table Book Rep is primary table
b) What will happen if you attempt to add a new Book Rep with BR# of 75 to the Book Rep table?
   A new row will be inserted with BR#75
c) What will happen if you attempt to add a new customer with BR# of 85 to the Customer table?
   Error will happen because the foreign key constraint (there is no br# 85 in book rep table)
d) What will happen if you attempt to delete BR# 48 from the Book Rep Table
   BR #48 will be deleted from book rep table
e) What will happen if you attempt to delete BR #65 from the Book Rep table?
   Error will happen because the foreign key constraint (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.