QUESTION 20 Given the tables shown in Figure 4.8 on Page 132 of the textbook. As
ID: 3727711 • Letter: Q
Question
QUESTION 20 Given the tables shown in Figure 4.8 on Page 132 of the textbook. Assume the department table contains the following tuples: dept_name Biology Comp. Sci Electrical Engineering Taylor 85000 building budget Watson 90000 Taylor 100000 We want to create a new course belongs to Physics department. What should we do? O A insert into department values (Physics, Watson', 70000) B insert into course values (PHY-101, Physics I', 'Physics', 4); C. insert into course values (PHY-10 1·Physics l, Physics', 4); D.insert into department values (Physics, Watson', 70000) insert into course values (PHY-101, Physics I', "Physics', 4) Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save All AnsweExplanation / Answer
//Note:- if you have any query then comment below.please upvote.
Answer:- option A is correct;
insert into department values('Physics','Waston',70000);
here department is table name and the physics is course name and, Watson and 70000 is other data of the table department.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.