4 copies of a new book Distributed and Cloud Computing has been added to the lib

Question

4 copies of a new book Distributed and Cloud Computing has been added to the library. The price is $50.00 for each copy. Write a SQL statement that Adds the information to the book relation. Assume that bookid is automatically maintained by the system.

book bookid title Introduction of Algorithms rice total copies 84.66 Database System Concepts74.99 Stochastic Calculus for Financ41.02 Stochastic Calculus for Finance II 55.22 course title Algorithms DB Organization Advanced DB Organization Math Finance I Math Finance II faculty enroll studentid courseid student studentid facultyid name gpa Tom 3.3 John3.8 Mary 3.0 Kris 3.6 Alex3.5 James 70000 Sarah 60000 ay 80000 Rache 70000 Pau85000 book_ checkout bookid studentid 2017-08-29 2017-09-02 2017-09-07

Explanation / Answer

We can update the given information by using INSERT INTO commad in sql as follows:
INSERT INTO book VALUES (5,'Distributed and Cloud Computing', 50.00,4);

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---

---

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