Expert answer:answer the discussion questions only
Solved by verified expert:answer the discussion questions only which are: Task 2 a & cTask 3
dbsa_comp1011_fall_17_r_cw1.pdf
Unformatted Attachment Preview
Database System Administration (COMP 1011) – FALL- 17-R – CW1
Individual Assignment
Module: Database Administration (COMP 1011)
Level: 3
Max. Marks: 100(Scaled down to 30)
Duration: 4 weeks
Date of Submission: End of Week No.8 (2-DEC-2017 23:59)
Learning Outcomes
1. Create and maintain a database server
2. Design an enterprise data model that incorporates all of the data used by an organisation’s
business processes
3. Devise and implement database security policies
Analyze Scenario given below and answer the following questions:
Task 1:
Submit a work proposal for this assignment by the end of week 5th, 11-NOV-2017 23:59
which must include:
Understanding of deliverables – a detail description of deliverables
General overview of task 2 and 3 – initial understanding of solution to tasks
(10 marks)
The work proposal must be submitted in a word file through the link available in Moodle.
Task 2:
a. Assume that you are responsible for installing a new DBMS product for the scenario given
below. To undertake this exercise, you must have clear understanding of instance. Discuss the
various modes to shut down and startup the database server.
(20 marks)
Database System Administration (COMP 1011) – FALL- 17-R – CW1
b. As a database administrator perform the following tasks: [Lab demo is required. There will be
no marks without a lab demo. The lab demo schedule will be announce in week #9 ]
(4 x 8 = 32 marks)
i.
ii.
Create separate physical structures for the new schema as per OFA guidelines
Create a Schema with appropriate privileges
iii.
Analyse the following scenario and create database tables with correct
relationships
Create at least two complex Views for the scenario give below.
iv.
c. Discuss cloud database management system.
(20 marks)
Task 3:
Select any oraganisation where the data is sensitive. Discuss the concept of authentication and authorization
in the database. You are required to provide the examples with the appropriate justification.
(18 marks)
Database System Administration (COMP 1011) – FALL- 17-R – CW1
Scenario:
In this assignment you are asked to design and implement a database app for managing and analyzing
University course experiences. Let’s call it the Course Experience App (CEA). The CEA database stores
information about courses offered by the University, some basic information about instructors and
students, and student course experiences. Information about courses consists of the following facts:
course number, the name and the code of the offering department, the general area of study (e.g.
humanities, sciences, arts, business, engineering), a list of topics covered in the course, and a list of skills
acquired upon successful completion of this course. We also store information about prerequisite and
exclusion courses for any given course. Note that a course number is unique only within a specific
department. For each instructor, we store a name, gender, age, and areas of expertise (if applicable). An
instructor can be permanent faculty or a freelancer. If an instructor is faculty, we store the year when they
started their career as a faculty, and whether they are teaching or research faculty. If an instructor is
research faculty, we record a list of their research interests. For each student – identified by a unique user
name – we store basic demographic data such as year and month of birth, gender, and country of birth. In
addition, we store the year and month when this student begun his study at university. Additional
information about students include their professional history outside academia. For each significant job
that the student held in the past or is holding now, we record the job title, Company name (or selfemployed), Company expertise (can be more than one), start and end date of the employment, and a list
of skills used during or acquired on the job. For each skill, we record a level of expertise on a scale of
beginner-intermediate-advanced-professional (2-5). Each time the course is offered we call it an ‘edition’
of the course. For each edition we record the start and end date, the time of day the course was offered
(morning, day, evening), an approximate overall number of students enrolled in this course, and the name
of the course instructor. Each edition of a course can be co-taught by more than one instructor. For the
main part of this database app, we record all course editions taken by a particular student, together with
the final grade (in numeric format – percentage). The student records their experiences after enrolling in
an edition of the course. The experiences consist of the following facts:
Overall satisfaction with the course on a scale from 1 to 5 (5 is the highest).
An overall ranking of the course instructor(s) (5 is the highest).
The list of skills that the student has acquired from this course. For each skill we record 2 self-assessment
values: the rank of a skill before the course and the rank of the same skill upon the course completion –
on a scale 1-zero knowledge, 2-beginner, 3- intermediate, 4-advanced, 5-professional.
Overall interest in the course topics – also 2 values on a 5 point scale – one specifies the interest before
taking the course, and the second – the interest after its completion.
Database System Administration (COMP 1011) – FALL- 17-R – CW1
Assessment Analysis Sheet
Tasks #1
0
1-5
No Submission
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 2
0
1-7
General
overview of
task 2
8-14
Answer is too
vague,
no reading or
literature
support just
assumptions
which are
irrelevant or
illogical
Few points are
relevant.
Set of
requirements
established are
not from case
study. The
process for
evaluating a
DBMS product is
not appropriate
or
Tasks #2.a
or
student has
failed to
understand the
requirements of
the case study
6-10
Adequate
Information
provided
based on
study and
literature
review. Good
set of
requirements
established.
The process
for
evaluating a
DBA is
Adequate
or of good
level
Mark
15-20
Excellent work.
Good
Support of
literature in the
answer. All
requirements
described in well
structure manner
as mentioned in
the case study.
Mark
Database System Administration (COMP 1011) – FALL- 17-R – CW1
Tasks #2.b
NO marks
without lab
demo
Task #2.c
Task #3
bi (0-2-4)
No answer
Or
Physical
Structure
without OFA
guidelines
Or
Physical
Structure with
OFA guidelines
0-5
Weak, major,
Omission, little
understanding
of given tasks,
Not able
to prove
knowledge in
this tasks. Most
of the details
are not
relevant.
No practical
example
0-5
Weak, major,
Omission,
little
understanding
of given tasks,
Not able
to prove
knowledge in
this tasks.
Most of the
details are not
relevant.
bii (0-2-4)
No Separate
Schema
Or
Only A schema
created
Or
Schema created
with appropriate
storage
specification and
Grant command
is used.
6-13
Adequate
knowledge of
key principles
and concepts
and/or
adequate evidence
of the
application of
theory in practice
biii (0-2-4)
4 marks for each
table. 20 marks if
5 tables created
as per the
scenario and with
appropriate
tables, data types
and constraints.
14-20
Excellent knowledge
and
understanding of
principles and
concepts and /or
excellent
knowledge and
understanding of
the application of
theory in practice
6-11
12-18
Adequate
knowledge of
Excellent
knowledge and
key principles
and concepts
and/or
understanding of
principles and
concepts and /or
excellent
knowledge and
understanding of
the application of
theory in practice
adequate
evidence of the
application of
theory in
practice
biv (0-2-4)
2 marks for
each
complex
view. 2
marks will be
deducted if
view is
simple.
Database System Administration (COMP 1011) – FALL- 17-R – CW1
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 & proper References.
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:
First offence of plagiarism
a. A 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. Mark deduction: When the work is resubmitted, the marking will be undertaken according to
the marking criteria. In compliance with this policy, the 25% deduction is then made on the
marks obtained. For example, in an assessment that carries a maximum of 50 marks, suppose a
student were to obtain 30 marks for the resubmitted work, the final marks for that assessment
will be
22.5 (after deducting 25% of the marks actually obtained for the resubmitted work).
Database System Administration (COMP 1011) – FALL- 17-R – CW1
c. Period of resubmission: The student will have to resubmit the work one week from the date he
or she is advised to resubmit. For example, if the formal advice to resubmit was communicated
to the student on a Sunday (latest by 5 pm), the student will have to resubmit the work latest by
next Sunday 5 pm.
d. If the re-submitted work is also detected to be plagiarized, then the work will be awarded a
zero.
e. Resubmission of the work beyond the maximum period of one week will not be accepted and
the work will be awarded a zero.
B. Any further offence of plagiarism
a. If any student is again caught in an act of plagiarism during his/her course of study (either in
the same module, same semester or in any other 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.
Guidelines
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:
1. 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
Database System Administration (COMP 1011) – FALL- 17-R – CW1
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.
2. 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.
3. In both cases (a) and/or (b), the deduction in marks will be applicable for the whole
assessment
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 policy:
Penalty for late submission – 5% of the awarded mark specified for the assessment 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
…
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