The Appearance of the Relation Result
Not what you're looking for?
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.
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.