WEEK 4 -ECET450 PRACTISE EXCERCISE ASSIGNMENT

profilescience prodigy
 (Not rated)
 (Not rated)
Chat
Home>Homework Answsers>Computer Science homework help

Student Name:__________________          Date:_________

ECET450 Practice Exercise #4

 

 

FOR QUESTIONS 1-10: Given the following table named DEPT,

 

DEPTNO

DNAME

LOC

10
20
30
40

ACCOUNTING
RESEARCH
SALES
OPERATIONS

NEW YORK
DALLAS
CHICAGO
BOSTON

 

Write an SQL script for the following returned data:

 

1.

LOC

BOSTON

 

ANSWER:

 

 

 

 

 

2.

DNAME

SALES
OPERATIONS

 

ANSWER:

 

 

 

 

 

3.

DNAME

ACCOUNTING
RESEARCH
SALES
OPERATIONS

 

ANSWER:

 

 

 

 

 

 

 

 

 

4.

DNAME

LOC

RESEARCH
SALES
OPERATIONS

DALLAS
CHICAGO
BOSTON

 

ANSWER:

 

 

 

 

 

 

 

 

5.

DEPT NO

DNAME

LOC

10
20
30

ACCOUNTING
RESEARCH
SALES

NEW YORK
DALLAS
CHICAGO

 

ANSWER:

 

 

 

 

 

 

 

 

 

6.

DNAME

LOC

RESEARCH
SALES
OPERATIONS

DALLAS
CHICAGO
BOSTON

 

ANSWER:

 

 

 

 

 

 

 

 

7.

Great Seafood

BOSTON

 

ANSWER:

 

 

 

 

 

 

 

 

 

 

8.

LOC

NEW YORK
CHICAGO

 

ANSWER:

 

 

 

 

 

 

 

 

 

9.

DEPTNO

DNAME

LOC

40
30
20
10

OPERATIONS
SALES
RESEARCH
ACCOUNTING

BOSTON
CHICAGO
DALLAS
NEW YORK

 

ANSWER:

 

 

 

 

 

 

 

 

 

10.

DNAME

OPERATIONS
RESEARCH
ACCOUNTING

 

ANSWER:

 

 

    • 12 years ago
    Report issue
    Week 4: ECET450 - Practise excercise
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      ecet450_week_4_practise_assignment.docx