answer the discussion questions only

User Generated

fhzv1

Programming

Description

answer the discussion questions only which are:

Task 2 a & c

Task 3


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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

COMPLETE. Download the FINAL paper below. Let me know if there is something you may need rectified.

Running head: INDIVIDUAL ASSIGNMENT

Module: Database Administration
Name
Instructor
Course
Date

1

INDIVIDUAL ASSIGNMENT

2

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.
The use of the databases has been of great importance to various organizations especially this
time that most of the organizations are migrating from the analog way of doing things to digital
systems (Flammini, 2011). Databases are used in different companies and organizations, and an
example is its use in institutions like in the scenario given. From database emerges the database
management system which is an application software that used to create and manage the
databases of an organization well. It provides the programmers as well as the end users with a
systematic way through which data can be created, updated, retrieved and managed. DBMS
usually serves as an interface between the databases and the application programs or the end
users, and for this reason, some functions are necessary such as starting up and shutting down the
database server.
These are very necessary for the processes of interacting with the database servers. To add,
there exist various modes that to shut down and startup database servers.
When a person or an administrator start up a databas...


Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags