For Exercises27 and 28, suppose that an additional attribute called R with a dom

Question

For Exercises27 and 28, suppose that an additional attribute called R with a domain of integers between 0 and 100 is added to the Writes relation, The new Writes table Because the domain of RovaltyPercent is numerical, arithmetic comparisons can be done on a given RoyaltyPercent value. Write an SQL query to give the author s name, the title and ISBN of the book, and the royalty percent for all authors with a royalty percent of less than 100. Write the results of the query. What database integrity errors would be caused by attempting each of the following actions?

Explanation / Answer

28.The above table is not having any primary key or any reference field informations.With this assumption

a) will be added to the writes table without any error.

Because with available information on the writes table as name,ISBN and Royality Percent columns seems not any primary key information and there is no reference table relation with the writes table.

b) Shows data conversion error like Royality Percent cannot be converted varchar to int. As per question the domin of Royality percent is numerical value.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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