Compute natural join and outer join, Database Management System

Assignment Help:

For the relations R and S given below:

R                      S

A

B

C

1

4

7

2

5

8

3

6

9

Compute

 (i) ΠA,C(R) (ii) σB=2(S)

 (iii) natural join (iv) outer join

A

C

1

3

4

6

7

9

(ii)

B

C

D

2

3

10

2

3

11

(iii)

A

B

C

D

1

2

3

10

1

2

3

11

(iv) Assuming left outer join

A

B

C

D

1

2

3

10

1

2

3

11

4

5

6

NULL

7

8

9

NULL


Related Discussions:- Compute natural join and outer join

What three major types of actions includes databases, What three major type...

What three major types of actions includes databases? Briefly discuss these The three major types of actions including databases are: (i) Defining: It includes specifyin

In case of entity integrity the primary key may be declared, In case of ent...

In case of entity integrity, the primary key may be declared? In a case of entity integrity primary key may be not Null.

Whta is the advantage of the database management approach, Whta is the adva...

Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.

Designing a Human Resources Database LASA1, Scenario: You are a freelance ...

Scenario: You are a freelance database designer who has just been contacted by a small software development company named Altair Software. The president of the company has asked

Relational algebraic operators, Problem Explain at least five relationa...

Problem Explain at least five relational algebraic operators with a suitable example. Note: All the above descriptions should be done by taking at least two examples from ou

What is foreign key, What is foreign key? A relation schema r1 derived ...

What is foreign key? A relation schema r1 derived from an ER schema may contain among its attributes the primary key of another relation schema r2.this attribute is known as a

Database Models, Benefits and Limitations od Data Models?

Benefits and Limitations od Data Models?

What is null, What is NULL? Simply NULL means not in value.

What is NULL? Simply NULL means not in value.

Assigning responsibility for operation, Assigning Responsibility for Operat...

Assigning Responsibility for Operation Many operations might have obvious target objects, but some of these operations could be used at numerous places in an algorithm, by one

Design a gennalization and specialization hierarchy for an a, Design a genn...

Design a gennalization and specialization hierarchy for an automobile sales company

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd