While there are many varieties of databases, the relational database model is the model utilised in common systems such as Oracle, MySQL, MS SQL Server and MS Access. As such, it is imperative to understand, recognise, and interpret relations within these databases. That said, consider the following relational database instructions:

Employees

Name	Email_address	Location
John	<..n@abxz.com	5
Mary	<..h@abxz.com	3
Philip	<..x@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 = Department.Floor_#

In this Hand-In Assignment, you will decipher the presented database instructions, and determine relation RESULT.

To prepare for this Assignment:

• Review your Weekly Learning Resources with a focus on relational databases.
• Analyse the given database instructions.
• Analyse each of the relations within the given database instructions.
• Reflect on the relation RESULT after executing all database instructions.

To complete this Assignment:

Submit a document with your interpretation of the posed problem and address the following:

• In terms of the relations shown in the given database instructions, identify the appearance of the relation RESULT after executing each of the instructions.
• Show and explain how you reached your conclusion.

 

 

2017/2/13 Week 11 Individual Assignment Week 11 Individual Assignment
[Individual Hand­In] Relations
Print Page While there are many varieties of databases, the relational database model is the model utilised in common
systems such as Oracle, MySQL, MS SQL Server and MS Access. As such, it is imperative to understand,
recognise, and interpret relations within these databases. That said, consider the following relational database
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 = Department.Floor_#
In this Hand­In Assignment, you will decipher the presented database instructions, and determine relation
RESULT.
To prepare for this Assignment:
Review your Weekly Learning Resources with a focus on relational databases.
Analyse the given database instructions.
Analyse each of the relations within the given database instructions.
Reflect on the relation RESULT after executing all database instructions.
To complete this Assignment:
Submit a document with your interpretation of the posed problem and address the following:
In terms of the relations shown in the given database instructions, identify the appearance of the relation
RESULT after executing each of the instructions.
https://elearning.uol.ohecampus.com/webapps/blackboard/content/listContent.jsp?course_id=_1628385_1&content_id=_8621925_1 1/2 2017/2/13 Week 11 Individual Assignment Show and explain how you reached your conclusion.
By Wednesday, combine the documents from all the questions that your instructor selected for this
week into one single file and upload using the Turnitin submission link. To submit your Individual Assignment, click the link below for Week 11 Individual
Assignment. https://elearning.uol.ohecampus.com/webapps/blackboard/content/listContent.jsp?course_id=_1628385_1&content_id=_8621925_1 2/2

Attachments:

• 1493785068-Week 11 Individual Assignment CKIT-5011612012pdf