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.