Expert answer:Database Security (COMP 0336A)
Solved by verified expert:Read the case study
dbs_comp_0336a_fall_17_r_cw1.pdf
Unformatted Attachment Preview
DBS-COMP 0336A-Fall-17-R-CW1
Individual Assignment Fall 2017
Module Name/Code: Database Security (COMP 0336A)
Hand out Date: Week-3
Level: 3
Work Proposal submission due date: 04/11/2017 23:59 Hrs
Final Submission due date: 25/11/2017 23.59 Hrs
Total Marks: 100
This assignment will assess the following learning outcomes:
Learning Outcomes
1. Evaluate techniques used to ensure security in a database-oriented
information system.
2. Manage user access and user profiles within a complex DBMS
3. Conduct database audits
Skills Acquired
Analysis, Technical
Critical Thinking, Problem Solving,
Application
Critical Thinking, Analysis
Instruction to students:
You have to perform all tasks.
You have to answer all questions with respect to Database Security concepts.
You are required to use appropriate literature review and use of library resources to complete this assignment.
You have to use correct citation and CU Referencing style in your assignment.
Task 1: Turnitin based submission of Work Proposal
Submit a work proposal for this assignment on or before 23:59 Hours, on November 04, 2017, which
must include:
Understanding of deliverables – a detail description of deliverables.
General overview of the given tasks – (task-2 to task-5) – initial understanding of solution to all tasks
with timeline to complete them and identification of literature resources.
(10 marks)
COMP 0336A
Page 1 of 8
DBS-COMP 0336A-Fall-17-R-CW1
Task 2:
Choose a banking organization or a department of a banking organization (for example, the bank where
you have an account or the bank you are working with, or bank where a relative/friend is working) that
uses an automated/computer-based Information System. Perform the following:
a. Write a brief description of the chosen organization/department which includes a short narration
of their automated system.
(10 Marks)
b. Read the article “A Review report on Security Threats on Database” by S Singh and R Kumar.
Recognize and deliberate the four (4) database security threats that your chosen bank may
encounter and justify your answer. If you are the Database Administrator (DBA) of the bank, what
steps you are going to do to avoid the threats you have identified?
(20 marks)
Note: Your answer should be in your own words and should be limited to 3 pages.
Task 3:
a. Carry out a critical literature review of the aims and significance of database auditing and bring
out a comparative chart of the identified findings from different resources (at least 3 sources).
(20 Marks)
b. In the chosen banking organization in Task 2 above, highlight the importance of conducting
database audit. Give proper justifications with appropriate citations.
(10 Marks)
Task 4: Assume that you are the DBA of the banking organization which you have selected in Task 2
above. One responsibility of DBA is to manage the user access and user profiles. Perform the
following tasks by writing the proper SQL statements:
a. Identify and create at least three (3) different roles and provide proper justification for all
the three identified roles.
(6 marks)
b. Create at least two (2) profiles with different parameters that can be applicable to the
chosen organization in Task-2 and justify the requirement of profiles.
COMP 0336A
(6 marks)
Page 2 of 8
DBS-COMP 0336A-Fall-17-R-CW1
c. Create at least six (6) users and assign appropriate profiles from the profiles that as you
have created above.
(6 marks)
d. Grant the appropriate roles from the three created roles to the users that have been
created above.
(6 marks)
e. Critically analyze the role of default and temporary tablespaces while creating users.
(6 Marks)
Note: Your answers should be in MS Word format and you have to provide the screenshots of the
commands that you have executed in Oracle or any other database environment in the appendix.
Evaluation Criteria:
You would be evaluated on the following:
• Originality of answer, i.e. writing in your own words with some amount of referenced material.
• Oral examination: Your Assignment marks are based on the VIVA which will be conducted upon
submission of assignment. The VIVA will be based on the tasks given in the assignment. ZERO
mark will be awarded to the student if she / he is absent for VIVA.
• Correct information analysis and presentation in document form.
• Adequate referencing and citation provided.
• Examples can/must be provided.
Guidelines
Follow the guidelines mentioned below for your assignment.
Assignment should be typed and uploaded to Moodle and will undergo plagiarism
detection test through Turnitin (a plagiarism detection tool)
Handwritten assignments will not be accepted.
Assignment should have a Title Page. Title Page should contain the following information.
COMP 0336A
Assignment Name
Page 3 of 8
DBS-COMP 0336A-Fall-17-R-CW1
Class
Student name
Student ID
It should have Table of Contents
Use page numbers
Assignment should be typed in your own words using Times New Roman font size 12.
Heading should be with Font Size 14, Bold, Underline
Use Diagrams and Examples to explain your topic.
Copy paste from the Internet is strictly not acceptable.
Reference should be included in the last page as follows
Author name, Book Title, Publisher, Year in case of books
In case of web site references type the full path of the web page with referenced
date
In case of magazines/ periodicals type article name, magazine name, Issue Number
and date
Rules & Regulations
The purpose of assignment is to do some research work; so you can consult books in Library or
use internet or computer magazines or any other source.
Plagiarism Policy
A. First offence of plagiarism
a. If a student is caught first time in an act of plagiarism during his/her course of study in any
assignment other than project work, the student will be allowed to re-submit the assignment
once, within a maximum period of one week. However, a penalty of deduction of 25% of the
marks obtained for the resubmitted work will be imposed.
b. Period of re-submission: The student will have to re-submit the work one week from the date
he or she is advised to re-submit.
COMP 0336A
Page 4 of 8
DBS-COMP 0336A-Fall-17-R-CW1
c. If the re-submitted work is also detected to be plagiarized, then the work will be awarded a
zero.
d. Re-submission of the work beyond the maximum period of one week will not be accepted
and the work will be awarded a zero.
e. If the student fails the module and has a proven case of academic integrity violation in this
module , the student is required to reregister the module
f. If plagiarism is detected in Project work (Project 1, Project Planning and Project Design and
Implementation) the above clauses (a,b,c,d) do not apply and the work will be summarily
rejected. In these cases the student will be awarded a fail (F) grade and is required to reregister the module
B. Second offence of plagiarism
a. If any student is caught second time in an act of plagiarism during his/her course of study (in
a subsequent semester), the student will directly be awarded zero for the work in which
plagiarism is detected. In such cases, the student will not be allowed to re-submit the work.
b. If the student fails the module and has a proven case of academic integrity violation in this
module, the student is required to re-register the module.
C. Third Offence of plagiarism
If any student is caught for the third time in an act of plagiarism during his/her course of study
(in a subsequent semester), the student will be penalized with a fail in the module and shall be
required to re-register the module.
D. Fourth Offence of plagiarism
If any student is caught for the fourth time in an act of plagiarism during his/her course of study
(in a subsequent semester), he shall be suspended from the College for a period of one semester.
E. Fifth offence of plagiarism
If any student is caught for the fifth time in an act of plagiarism during his/her course of study (in
a subsequent semester), he shall be expelled from the College.
COMP 0336A
Page 5 of 8
DBS-COMP 0336A-Fall-17-R-CW1
F. Amount of similar material
a. The total amount of similar material in any form of student work from all sources put together
should not exceed 30% (including direct quotations).
b. The total amount of quoted material (direct quotations) in any form of student work from all
sources put together should not exceed 10%.
c. The total amount of similar material in any form of student work from a single source should
not exceed 7 percent. However, cases having a similarity of less than 7 percent in such cases
may still be investigated by the faculty depending on the seriousness of the case.
d. If faculty member find enough merit in the case of a student work with a similarity (with a
single source) of more than 7 percent as not a case of plagiarism, the faculty member should
provide detailed comments/remarks to justify the case.
Late Submission
Penalty for late submission – 5% of the maximum mark specified for each component of the assessment
(if there are multiple components of an assignment such as work proposal and main assignment where
the date of submission is different for each component) will be deducted for each working day.
Assessment documents submitted beyond a period of one week after the last date of submission will
not be accepted and will be marked as zero for that assessment.
Note: Must follow assignments instructions.
Feedback to students: Written Feedback in Moodle will be provided for Work Proposal and the Main
Assignment within 7 days from the last date of submission.
COMP 0336A
Page 6 of 8
DBS-COMP 0336A-Fall-17-R-CW1
Assessment Sheet
Database Security (COMP 0336A) Fall 2017
Student ID:
Student Name:
Task 1
0
1-4
5-8
9-10
Mark
Work Proposal
No submission
Weak/incomplete
Proposal
Good proposal but weak
literature identification
Good Proposal
covering all the
required aspects.
Penalty for Late Submission: ( 5% per day on the obtained marks)
Obtained Marks after deducting penalty:
Task 2 (a)
0
1-4
5-8
9-10
Choosing a banking
organization and its
description.
No submission
Weak/incomplete
description
Average/ Fair description
Good description
Task 2 (b)
0
1-8
9-18
19-20
Identifying the four
database threats for
the chosen banking
organization
No Submission
Incorrect top four
threats however, some
description exist
Task 3 (a) :
0
1-8
9-18
19-20
Research on Aims and
Significance of
Database Auditing
No Submission
Weak/incomplete
description
Good description but lacks
literature underpinning
Good description with
literature
underpinning.
Task 3 (b)
0
1-4
5-8
9-10
Importance of
Auditing in chosen
banking organization
No
Submission
Weak/incomplete
description
Average/Fair description
Good Description
Task 4 (a)
0
1-3
4-5
6
Creating Roles and
defining purpose of
each role.
No Submission
Errors in SQL
commands and
purpose not defined
Task 4(b)
0
1-3
4-5
6
Creating 2 profiles and
defining their purpose
No Submission
Errors in SQL
commands and
purpose not defined
No errors in SQL, however
purpose not appropriate
Profiles created and
purpose for each
profile defined
COMP 0336A
Mark
Mark
Correctly identified top-4
Correct Identification,
threats for the chosen
with literature
organization with
underpinning
description but Lacks
literature underpinning.
Mark
Mark
No errors in SQL, however All three roles created
purpose not appropriate and purpose defined
Mark
Page 7 of 8
DBS-COMP 0336A-Fall-17-R-CW1
Task 4(c)
0
1-3
4-5
6
Mark
Creating Six Users and
Assigning appropriate
profiles
No Submission
Errors in SQL
commands and
created profiles not
assigned
No errors in SQL, created
profiles not assigned to all
users
All users created and
created profiles
assigned to all users.
Task 4 (d)
0
1-3
4-5
6
Granting the three
created roles to users
created
No Submission
Errors in SQL
commands and
created roles not
assigned
Task 4 (e)
0
1-3
4-5
6
Role of default and
temporary
tablespaces while
creating users
No Submission
Weak/incomplete
description
Average/ Fair description
Good description with
examples.
Mark
All users created and
No errors in SQL, created
created roles assigned
roles not assigned to all
to all users
users.
appropriately.
Mark
Marks obtained for Task-2 to Task-4:
Penalty for late submission of Task-2 to Task-4: ( 5% per day on the obtained marks)
Marks obtained for Task-2 to Task-4 after deducting penalty:
Final Marks obtained for the assignment – Task-1 to Task-4:
Comments for Work Proposal:
Comments for Main Assignment:
Signature of the Teacher
COMP 0336A
Page 8 of 8
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades