Please See attached assignment paper and follow the guidelines strictly before you bids !Please Submit a work proposal for this assignment on 1 April 2019
assignment___database_systems_administration.pdf
Unformatted Attachment Preview
DBSA-COMP 1011 – SPRING – 19- CW1-ALL
Individual Assignment – SPRING 2019
Module: DATABASE SYSTEMS ADMINISTRATION (COMP 1011)
Level: 6
Duration: 4 weeks
Max. Marks:
100 (Scaled down to 30%)
Work Proposal Submission :- April 03rd 2019 (Week No.5)
Assignment Submission:- 24th April 2019 (Week No.8 )
Instructions:
You should upload your assignment by the time and date mentioned above to the MOODLE under
Assignment link.
You need to provide the solution to ALL questions.
Evaluation Criteria
Detailed evaluation criteria has been given in evaluation grid at the end of the document.
Lab demonstration and written viva. There will be no marks without written Viva . The written Viva
is to measure originality of your work. ZERO marks will be awarded to the student if she / he is
absent for VIVA. During presentation, you may asked to write SQL queries for checking the originality
of the student work.
Guidelines
Follow the guidelines mentioned below for your assignment:
Assignment documents must be submitted through Moodle and it will undergo
plagiarism detection test through turnitin ( a plagiarism detection tool).
Handwritten assignments / hard copy will not be accepted.
Use Page Number & References should be academic quality from quality sources and
Harvard Reference Notation should be used.
1|Page
COMP1011(QP)
DBSA-COMP 1011 – SPRING – 19- CW1-ALL
Assignment should have a Title Page. Title Page should contain the following
information.
Assignment Name
Section Name
Student name
Student ID Number
Faculty Name
The Table of Contents Should have, each deliverable task number, content, page
number
Assignment should be typed in your own words using Times New Roman font size 12.
Heading should be with Font Size 14, Bold, Underline
Plagiarism Policy:
As per MEC policy, any form of violation of academic integrity will invite severe penalty. Plagiarised
documents, in part or in whole, submitted by the students will be subject to this 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.
If the re-submitted work is also found to be plagiarized, then the assessment will be awarded a
zero mark
d. Re-submission of the work beyond the maximum period of one week will not be accepted and
the assessment will be awarded a zero mark.
e. 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 re-register the module
f. 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
2|Page
COMP1011(QP)
DBSA-COMP 1011 – SPRING – 19- CW1-ALL
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 resubmit 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), the student 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), the student shall be expelled from the College
Types/Variations of cases of Plagiarism and associated actions
A. Type 1: In case plagiarism is detected in any component or part submission (submitted at
different times) of one assessment (assignment), the deduction in marks will be
applicable for the whole assessment (assignment), even if only the component or part
submission alone needs to be resubmitted.
B. Type 2: In case plagiarism is detected in a group assessment, all students of the group will
be considered as having committed an act of plagiarism irrespective of whether
plagiarism is on account of the act of all or a few or only one member. The policy will then
be applied to all students.
C. Type 3: Combination of Type 1 and Type 2: In case plagiarism is detected in any
component or part submission (submitted at different times) of a group assessment
(assignment), the deduction in marks will be applicable for the whole assessment
(assignment), even if only the component or part submission alone needs to be
resubmitted. All students of the group would be considered as having committed an act
of plagiarism irrespective of whether plagiarism is on account of the act of all or a few or
only one member. The policy will then be applied to all the students of the group.
D. Type 4: Variation of Type 1 and Type 2: In cases where the assessment consists of
components or part submissions that could be a group assessment component (e.g. group
assignment) and an individual assessment component (e.g. individual reflection), the
following will be applicable:
3|Page
COMP1011(QP)
DBSA-COMP 1011 – SPRING – 19- CW1-ALL
a. If plagiarism is detected in the group assessment component, all students of the
group will be considered as having committed an act of plagiarism, irrespective
of whether plagiarism is on account of the act of all or a few or only one member.
The policy will then be applied to all students of the group. In such cases the group
assessment component will be resubmitted as per the policy.
b. If plagiarism is detected in the individual assessment component, the individual
assessment component will be resubmitted as per the policy. The policy will then
be applied to that student alone.
c. In both cases (a) and/or (b), the deduction in marks will be applicable for the
whole assessment (assignment).
Rules & Regulations
If any part of assignment is found copied from the other then marks will be deducted accordingly.
Assignments with 3 or more identical topics will be awarded 0 Marks.
Late Submission Policy
The recommended practice at MEC is to set the cutoff time to 23:59 on the due date for all
assessment submissions. As per the Assessment Policy at MEC, for any late submissions, a penalty
of deduction of 5% of the marks obtained for the resubmitted work will be imposed for each
working day following the last date of submission till the date of actual submission. Assessment
documents submitted beyond a period of one week after the last date of submission will not be
accepted and will be awarded a zero for that assessment. In cases where the submission has been
delayed due to extenuating circumstances, the student may be permitted to submit the work
without imposing the late submission policy stated above. The extended period of submission will
be one week from the original last date of submission. In such cases, the student is expected to
submit the supporting certificates on or before the original last date of submission of the
assessment and the decision of extension rests with faculty responsible for the assessment .The
late submission policy shall be applied if the student fails to submit the work within one week of
the original last date of submission.
Students may contact their teachers for clarification on specific details of the submission time if
required.
Research Ethics and Biosafety Policy
To protect and respect the rights, dignity, health, safety, and privacy of research subjects involved
including the welfare of animals and the integrity of environment, all student projects are
expected to be undertaken as per the MEC Research Ethics and Biosafety Policy. Accordingly the
following shall apply.
4|Page
COMP1011(QP)
DBSA-COMP 1011 – SPRING – 19- CW1-ALL
Research and other enterprise activities shall be conducted by maintaining the high ethical
standards consistent with national and international standards and conventions.
Any research at MEC that is categorized as high-risk research shall be subject to review and
approval by the Research Ethics and Biosafety Committee.
Research activities involving collection of human or animal tissues and manipulation of microbial,
animal or plant cells shall be subject to review and approval by the Research Ethics and Biosafety
Committee.
Participants involved in research must be informed about the purpose of research and intended
uses of research findings. Written consent must be obtained from people involved prior to the
commencement of research.
Data obtained from participants must be treated with high confidence and should be used only
for the intended purpose of research.
Research supervisors must take necessary steps to ensure research integrity and quality of their
students’ research.
Assessment Grading Criteria
Refer section “Assessment Grading Criteria” in Module Information Guide.
5|Page
COMP1011(QP)
DBSA-COMP 1011 – SPRING – 19- CW1-ALL
This assignment will assess the following learning outcomes:
Learning Outcomes
1. Create and maintain a Database System
2. Design an enterprise data model that incorporates all of the data used by an organization’s
business processes
3. Devise and implement database security policies
Analyze the following SCENARIO and answer the following questions:
Assume that, we have the following application that simulate soccer teams, the games they
play, and the players in each team. In the design, we want to reflect the following:
We have a set of teams, each team has an ID (unique identifier), name, main stadium,
and to which city this team belongs.
Each team has many players, and each player belongs to one team. Each player has a
number (unique identifier), name, DoB, start year, and shirt number that he uses.
Teams play matches, in each match there is a host team and a guest team. The match
takes place in the stadium of the host team.
For each match we need to keep track of the following:
The date on which the game is played.
The final result of the match.
The players participated in the match. For each player, how many goals he scored,
whether or not he took yellow card, and whether or not he took red card.
During the match, one player may substitute another player. We want to capture this
substitution and the time at which it took place.
Each match has exactly three referees. For each referee we have an ID (unique identifier),
Name, DoB, years of experience. One referee is the main referee and the other two are
Assistant referee.
6|Page
COMP1011(QP)
DBSA-COMP 1011 – SPRING – 19- CW1-ALL
Task 1
Work Proposal:
Submit a work proposal for this assignment on or before of 5th Week i.e. Wednesday, 03rd April
2019 which must include:
Understanding of deliverables – a detail description of deliverables
General overview of task 2 – initial understanding of solution to tasks 2, 3 and 4 .
(10 marks)
The work proposal must be submitted in a word file through the link available in Moodle.
Task 2:
Discuss about the architecture of ORACLE Transaction processing Server System.
(20 marks)
[Your research must covers Architecture of TPS, TPS in distributed system, Model of TPS
Transaction Manager etc….]
Task 3:
As a database administrator perform the following tasks for the scenario given above: [Lab demo
is required. There will be NO MARKS without a lab demo. The lab demo schedule will be
announced in week #9]
(5+5+20+10+ 10= 50 marks)
i.
ii.
iii.
iv.
v.
7|Page
Create separate physical structures for the new schema as per OFA guidelines
[Create and rename the table space]
Create a Schema with appropriate privileges.
Identify the tables from above scenario and create database tables with correct
relationships and constraints.
Create two indexes for any two tables you created above.
Create two sequences and the use it for insert data into any two different tables.
COMP1011(QP)
DBSA-COMP 1011 – SPRING – 19- CW1-ALL
Task 4:
“Information security, privacy, and protection of corporate assets and data are of critical importance
to every business”
“
In the view of above statement choose an organization in Sultanate of Oman where customer data is
critical for them and ensuring secure data transactions.
You answer should cover the following:
a) Write the introduction and business of the organization.
b) Access controls on tables, views, Synonyms or rows, Administering user privileges, roles,
profiles and limitations of resources.
c) Secure External Password Store.
(5 +10+5 = 20 Marks)
You are required to use appropriate literature review and use of many library resources to complete this
assignment. You will achieve maximum marks for using correct Citation and CU-Harvard
Referencing Style in your assignment.
8|Page
COMP1011(QP)
DBSA-COMP 1011 – SPRING – 19- CW1-ALL
Assessment Analysis Sheet
Student ID: ……………………………………….. Student Name: ………………………………………………
Work
0
1-5
6-10
Proposal
No Submission
or
Tasks #1
student has failed to
understand the requirements of
the case study
Little understanding of
deliverables – a detail
description of deliverables
Understanding of deliverables – a detail
description of deliverables
General overview of task 1,2& 3
General overview of task 2
and 3
0
1-8
9-16
17 – 20
Irrelevant or no
concept.
Only one instance
Architecture is provided
with few mistakes.
Only two instance
Architecture
provided with little
discussion. (4 marks
each for a mode)
All instance Architecture
mentioned and discussed in
detail; demonstrating the
knowledge.
Tasks #2
(4 marks each for a
mode)
(No marks without a lab demonstration)
Tasks #3
Marks
Marks
Or fail to demonstrate/prove his/ her own work
i
ii
iii
iv
1-3
4-5
No answer
Physical Structure without OFA
guidelines
Physical Structure with OFA guidelines
0
1-3
4-5
No Separate Schema
Only A schema created
Schema created with appropriate storage
specification and Grant command is used.
9|Page
Marks
Marks
0
1-20
No answer
4 marks for each table with appropriate constraint created as per the scenario. (2 marks
each for table creation without constraint. 2 mark each for constraint.)
Marks
0
1-5
6-10
No answer
Only one index created with
mistakes
Created two indexes properly with clear
evidence for using the same view to select
data.
0
1-5
6-10
No answer
Only one sequence created with
minor errors.
TWO Sequences created and provided
evidence for data insert.
.
v
Marks
0
COMP1011(QP)
DBSA-COMP 1011 – SPRING – 19- CW1-ALL
Task #4
Task 4.a.
0
Weak, major, Omission,
little understanding of
given tasks, Not able to
prove knowledge in this
tasks. Most of the details
are not relevant.
0-1
Weak explanation of back
ground of the organization
selected.
2-4
Good Attempt
5
Marks
Demonstrate adequate
knowledge of organization
with proper explanation
of Organization selected.
Or Information provided
is not real.
0
Task 4.b.
Task 4.c.
Weak, major, Omission,
little understanding of
given tasks, Not able to
prove knowledge in this
tasks. Most of the details
are not relevant.
Adequate knowledge of key
principles and concepts
and/or adequate evidence of
the application of theory in
practice
4-8
9-10
Good attempt. Good
knowledge or key
principles and concepts
and/or good knowledge
of the application of
theory in practice
Excellent knowledge and
understanding of
principles and concepts
and /or excellent
knowledge and
understanding of the
application of theory in
practice
Or Information provided
is not real.
Adequate very basic concept,
Not enough efforts in data
collection, all data is not real
0
0-1
2-4
5
Weak, major, Omission,
little understanding of
given tasks, Not able to
prove knowledge in this
tasks. Most of the details
are not relevant.
Adequate knowledge of key
principles and concepts
and/or adequate evidence of
the application of theory in
practice
Good attempt. Good
knowledge or key
principles and concepts
and/or good knowledge
of the application of
theory in practice
Excellent knowledge and
understanding of
principles and concepts
and /or excellent
knowledge and
understanding of the
application of theory in
practice
Or Information provided
is not real.
Date:Name of Faculty:Signature:-
1-3
Adequate very basic concept,
Not enough efforts in data
collection, all data is not real
Total Marks
Penalty
Final Marks
Feedback:
10 | P a g e
COMP1011(QP)
…
Purchase answer to see full
attachment
