Select Page

kindly make sure the answer not copy and paste and also ASAP I got the answer any quest ask me plz
assignment_3_f_questions.docx
assignment_3_f_questions.docx
Unformatted Attachment Preview
College of Computing and Informatics
Assignment 3
[Total Mark for this Assignment is 5]
Student Details:
Name: ###
ID: ###
CRN: ###
Instructions:

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on
Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero make will be given if you try to bypass the SafeAssing (e.g. misspell words, remove spaces between
words, hide characters, use different character sets or languages other than English or any kind of
manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented, marks may be reduced for poor presentation.
This includes filling your information on the cover page.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by
the question.
Late submission will result in ZERO marks being awarded.
The work should be your own, copying from students or other resources will result in ZERO marks.
Question One
Pg. 01
Learning
Outcome(s):
Question One
LO 3 explain the
Consider the following two tables:
2 Marks
concepts and
processes
involved in
database
development.
Table – EmployeeInformations
EmpId
Name
ManagerId
DateOfJoining
EmpId
Project
Salary
121
P1
8000
321
P2
1000
421
P1
12000
121
Ali
321
01/31/2014
321
Raed
986
01/30/2015
421
Table – EmployeeSalary
Khaled 876
27/11/2016
1. Write a SQL query to find the names of all employees having salary greater
than or equal to 5000 and less than or equal 10000?
Pg. 02
Question One
2. Write a SQL query to find all employees from the ” EmployeeInformations ”
table, sorted by the ” ManagerId ” column:
3. Write a SQL query to find the average salary of all employees
4. Write a SQL query to find all employee records from EmployeeInformations
table who have a salary record in EmployeeSalary table.
Question Two
Pg. 03
Learning
Outcome(s):
LO 3 explain the
concepts and
processes
involved in
database
development.
1 Mark
Question Two
What do you mean by A view in SQL language? Give an example?
Question Three
Pg. 04
Learning
Outcome(s):
2 Marks
Question Three
LO 6 create a
database
application to
store and
retrieve data.
Explain the role of SQL authorization mechanisms that allow to differentiate among
the users of the database as far as the type of access they are permitted on various data
values in the database?
College of Computing and Informatics
Assignment 3
[Total Mark for this Assignment is 5]
Student Details:
Name: ###
ID: ###
CRN: ###
Instructions:

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on
Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero make will be given if you try to bypass the SafeAssing (e.g. misspell words, remove spaces between
words, hide characters, use different character sets or languages other than English or any kind of
manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented, marks may be reduced for poor presentation.
This includes filling your information on the cover page.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by
the question.
Late submission will result in ZERO marks being awarded.
The work should be your own, copying from students or other resources will result in ZERO marks.
Question One
Pg. 01
Learning
Outcome(s):
Question One
LO 3 explain the
Consider the following two tables:
2 Marks
concepts and
processes
involved in
database
development.
Table – EmployeeInformations
EmpId
Name
ManagerId
DateOfJoining
EmpId
Project
Salary
121
P1
8000
321
P2
1000
421
P1
12000
121
Ali
321
01/31/2014
321
Raed
986
01/30/2015
421
Table – EmployeeSalary
Khaled 876
27/11/2016
1. Write a SQL query to find the names of all employees having salary greater
than or equal to 5000 and less than or equal 10000?
Pg. 02
Question One
2. Write a SQL query to find all employees from the ” EmployeeInformations ”
table, sorted by the ” ManagerId ” column:
3. Write a SQL query to find the average salary of all employees
4. Write a SQL query to find all employee records from EmployeeInformations
table who have a salary record in EmployeeSalary table.
Question Two
Pg. 03
Learning
Outcome(s):
LO 3 explain the
concepts and
processes
involved in
database
development.
1 Mark
Question Two
What do you mean by A view in SQL language? Give an example?
Question Three
Pg. 04
Learning
Outcome(s):
2 Marks
Question Three
LO 6 create a
database
application to
store and
retrieve data.
Explain the role of SQL authorization mechanisms that allow to differentiate among
the users of the database as far as the type of access they are permitted on various data
values in the database?