View the step-by-step solution to:

# . o Cours . STAT10 - DATA SCIE X a lab 6b.pdf X D ECONOMICS 10A 0' i if?

PLEASE ANSWER THE pictures. the questions in the pictures. thank you!

. o Cours . STAT10 - DATA SCIE X a lab 6b.pdf X D ECONOMICS 10A 0' i if? https://gauchospace.ucsb.edu/courses/pluginfile.php/‘I962221/mod_resource/content/O/Iab%206b.pdf ﬁ' 8) O Homework Help - Q&amp;A from Oi x I lab 6b.pdf LAB 6b (2 exercises)
Continuing the work you completed in lab 6a. 5. Two more required relations are DEPARTMENT and EMPLOVEE_EXTENSION.
Atuple of DEPARTMENT represents a unique identiﬁerfor department number and unique name for
each of the three departments. Each manager also has a unique identifier. REQUIREMENT 2
Atuple of DEPARTMENT represents a unique identiﬁerfor department number and unique name for
each of the three departments. Each manager also has a unique identifier. DEPARTMENT
DEPT_N0 DNAME | MANAGER
D1 ACCOUNTS | E1
Dz STORES | E2
03 SALES | E5 REQUIREMENT 3
Atuple of EMPLOYEE_EXTENSION represents the unique identifier of an employee, the employee’s
office number and he employee's phone extension. EMPLOYEE_EXTENSION
EMPLOYEE_|D OFFICE EXTENSION E1 R101 811
E1 R102 813
E2 R10 111
E3 R35 123
E5 R35 123 a) Identify the relation defined by the following relational algebra expression. PROJECT EMPLOYEE_EXTENSION ON EXTENSION b) What is the primary key of the relation EMPLOYEE_EXTENSION

. o Cours . STAT1O - DATA SClE X a lab 6b.pdf X D ECONOMICS 10A 0' i if? https://gauchospace.ucsb.edu/courses/pluginﬁle.php/‘I962221/mod_resource/content/O/Iab%206b.pdf ﬁ' 8/ O Homework Help - Q&amp;A from Oi x I lab 6b.pdf 6.
As work progresses, new relations are added to the proposed database as follows:
CUSTOMER CUST_NO m ADDRESS m
m SALES_ORDER
ORDER_NO DATE CUST_NO 01 11/11/17 C1
_—— a) Write a relational algebra expression that will add a new order to the relation SALES_0RDER. The
order number is 011, the SALES_ORDER data is 12/12/17 and the customer number is C2 b) What is the result of the following relational algebra expression?
JOIN SALES_ORDER AND CUSTOMER
c) What is the result of the following query? SJOIN SALES_ORDER AND CUSTOMER END [ABS WEEK 6

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents
• ### -

Question & Answers

Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

Ask a Question