Purchase Solution

The Appearance of the Relation Result

Not what you're looking for?

Ask Custom Question

See the attachment.

Relations

In terms of the relations shown below, what is the appearance of the relation RESULT after executing each of these instructions?
Employees

Name Email_address Location
John John.john @ abxz.com 5
Mary m.smith @ abxz.com 3
Philip philipx @ abxz.com 5

Department

Manager_Name Floor_#
Karen 4
David 5

a. RESULT <- PROJECT Location from Employees
b. RESULT <- SELECT from Employees where Location = 5
c. RESULT <- PROJECT Floor_# from Department
d. RESULT <- JOIN Employees and Department where
Employees.Location = Departement.Floor_#

Check attachment for correct tables.

Attachments
Purchase this Solution

Solution Summary

The solution discusses the appearance of the relation result.

Solution Preview

There seems to be an error in the SQL code above. I have never seen the PROJECT statement in SQL, nor can I find it in any of the SQL references online (see end of posting). I will make an assumption about what PROJECT means, but if I am incorrect, I would be happy to update the posting with the correct use of the statement.

For this posting, I am assuming that PROJECT returns the column of data (also called the field) of the table. The SELECT returns the rows of data (also called records) from the table. Finally, the JOIN statement combines the two tables to create one table.

The results are as follows:

a. RESULT <- PROJECT Location from Employees
Following the assumption above, the ...

Purchase this Solution


Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C# variables and classes

This quiz contains questions about C# classes and variables.