Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

2nd Edition

1597499471, 978-1597499477

More Books

Students also viewed these Databases questions