Question 1: What is table name A?
Question 2: What is column name B?
Question 3: What is column name C?
Question 4: What is view column name D?
Question 5: What is value E?

Transcribed Image Text:

Refer to the following base table, view definition, and view table. Department Code DepartmentName ART Art Department COMP ENG HIST MATH Budget Actual 85000 80000 Computer Science Department 72000 79000 English Department 35000 35000 History Department 102000 98000 Math Department 60000 70000 CREATE VIEW AccountView AS SELECT Code, DepartmentName, (Budget FROM Department; AccountView Code Department Name ART Art Department COMP Computer Science Department ENG English Department History Department HIST MATH Math Department Actual) AS Difference Difference 5000 -7000 0 4000 -10000 Refer to the following base table, view definition, and view table. Department Code DepartmentName ART Art Department COMP ENG HIST MATH Budget Actual 85000 80000 Computer Science Department 72000 79000 English Department 35000 35000 History Department 102000 98000 Math Department 60000 70000 CREATE VIEW AccountView AS SELECT Code, DepartmentName, (Budget FROM Department; AccountView Code Department Name ART Art Department COMP Computer Science Department ENG English Department History Department HIST MATH Math Department Actual) AS Difference Difference 5000 -7000 0 4000 -10000

Answer rating: 100% (QA)

Question 1 What is table name A Table name A is Department Questio... View the full answer