Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Essentially, you have to compute the answers manually. Make a word document and for each answer insert a table with the right number of rows
Essentially, you have to compute the answers manually. Make a word document and for each answer insert a table with the right number of rows and columns and enter the necessary headings and the data in the table boxes. Any duplicate column names must be qualified by prepending their table_names.It's easy to add columns or rows as needed by right clicking after you block a column or row.
Assignment 3B 1. We have two tables PC and Employee. Keep PC as the left one and Employee as the right one. Show hand calculated/tabulated results for these operations as tables in a word document, without using Oracle or any other query engine. a. Show a product of the two b. Show a join of the two. c. Show a left outer join of the two. What does it represent? d. Show a right outer join of the two. What does it represent? e. Draw set diagram circles showing EMP# from each set that are common and the ones that are not common but exclusive to one set or the other. PC PC# Model Make Emp# 29 X500 HP 111 38 GP550 HP 118 32 Mini202 Sony 111 24 DX3900 Dell Employee Emp# Ename Dept Tel# 111 Tim MKT 9121 115 Kim FIN 9321 118 Jane FIN 9432 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started