Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL BRANCH bid B01 B02 EMPLOYEES bname Olympia Seattle eid Ename E1 Bill Gates E2Steve Jobs E3 Ted Codd E4 Michael Salary did mid City

SQL

image text in transcribed

BRANCH bid B01 B02 EMPLOYEES bname Olympia Seattle eid Ename E1 Bill Gates E2Steve Jobs E3 Ted Codd E4 Michael Salary did mid City Redmond 90 Palo Alto80 New York70 Berkeley 60 D1 null D2 null D2 E2 D2 E3 DEPARTMENTS Did D1 D2 D4 Dname Engineering Security Marketing bid B01 B02 B01 Stonebreaker E5 Alan Kay E6 Adelle Palo Alto 60 San Jose 60 D1 E1 D2 D2 Goldber 9) All possible combinations of the name of employees with the departments without relating the employees to the departments (2 points). SELECT 10) Name of Employees who work in Olympia branch (6 points) SELECT FROM FROM WHERE

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

Informix Database Administrators Survival Guide

Authors: Joe Lumbley

1st Edition

0131243144, 978-0131243149

More Books

Students also viewed these Databases questions