Welcome! Log In Create A New Profile

First Semester Exam Q2

Posted by Darkling

Announcements		Last Post
	SoC Curricula	09/30/2017 01:08PM
	Demarcation or scoping of examinations and assessment	02/13/2017 07:59AM
	School of Computing Short Learning Programmes	11/24/2014 08:37AM
	Unisa contact information	07/28/2011 01:28PM

Forums Messages New

Darkling

First Semester Exam Q2
November 15, 2011 11:05AM

Registered: 15 years ago
Posts: 234
Rating: 0

2.1 Not sure what they want here.

The employees table has a Primary key "Employee_ID" and 3 Foreign keys "JOB_ID", "Manager_ID" and "Department_ID".
The "Manager_ID" foreign key is a key to the same Employee table I.E "Employee_ID"

2.2 (A ran this in the Oracle DB interface)

SELECT
EMPLOYEE_ID emp#,
LAST_NAME Employee,
JOB_ID Job,
HIRE_DATE Hire
FROM EMPLOYEES

Any comments?

Reply Quote

Jaxy

Re: First Semester Exam Q2
November 15, 2011 02:53PM

Registered: 14 years ago
Posts: 38
Rating: 0

this one is a practice 1 question. Question 10. SO you are on the right track.

SELECT employee_id "Emp #", last_name "Employee",
job_id "Job", hire_date "Hire Date"
FROM employees;