Database Administration (COMP 0336)-FALL-17-CW2(ASSMNT)-QP FALL 2017 Individual Assignment and Presentation Database Administration (COMP 0336) Last Date of Submission: 23-DEC-2017, 11:55 pm (11th Week) Date of Presentation and Viva: 12th Week (Date and time shall be announced by the Module Instructors for their respective sessions) Total Marks: 100 Note: Perform all the tasks. Tasks Objectives: Marks 1. Manage database instances 2. Manage database storage 3. Design and evaluate database architectures Task # 1 Submit a work proposal for this assignment by the end of week 8th i.e. 2nd 10 Dec, 2017 (11:55 pm) which must include:  Understanding of deliverables – a detail description of deliverables  General overview of proposed plan - initial understanding of solution for the task-2 to task-3.  Identify the topic of presentation from the list of topics given in task3.  Resources identified The work proposal must be submitted in a word file through the link available in Moodle. Task # 2 One of the required task of a Database Administrator is to establish the 30 database connection between the client and the server. COMP 0336 Page 1 of 7 Database Administration (COMP 0336)-FALL-17-CW2(ASSMNT)-QP a) In view of the above statement, briefly explain the steps involved in establishing a database connection between a client and a database server. You have to create any sample table on database server and insert the records from the client to save in the database server. Your solution must also include the necessary commands and the screenshots at both the cient and the database server. b) Discuss in your own words, the database functionality tasks carried 10 out by the database server in a client/server database environment. Task # 3 Prepare for a presentation in Week 12 for any one of the following topics:  Big data – concepts, oppurtunities and challenges  Redo log mechanism and configuration  Designing a database for optimal query performance  Lock-based protocols 50 Note:  You must upload the presentation slides as a separate file in Moodle  You may include up to 8-10 slides in the presentation document  Duration of presentation is 10 minutes Evaluation Criteria: There will be no marks without a viva. Viva will be used as a means to measure the originality of your work. You would be evaluated on the following:  Originality of answer, i.e. writing in your own words with some amount of referenced material.  Viva: Your Assignment marks are based on the VIVA which will be conducted upon submission of assignment. The VIVA will be based on COMP 0336 Page 2 of 7 Database Administration (COMP 0336)-FALL-17-CW2(ASSMNT)-QP the tasks given in the assignment. ZERO marks 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 and diagrams can be provided if needed.  Zero marks will be awarded for task-3 without presentation. 100 Guidelines Follow the guidelines mentioned below for your assignment:  Assignment 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 Note: DO NOT DIRECTLY COPY/PASTE FROM INTERNET/BOOKS! DO NOT COPY FROM ONE ANOTHER! PRODUCE YOUR OWN ASSIGNMENT SOLUTION REPORT. The work submitted must be your own and must not be based on inputs from others. Your assignments shall be submitted to COMP 0336 Page 3 of 7 Database Administration (COMP 0336)-FALL-17-CW2(ASSMNT)-QP electronic databases to identify plagiarism. If assignment is found to be plagiarised, action will be initiated. Please refer to MEC policy on plagiarism (given below). Plagiarism Policy: DO NOT DIRECTLY COPY/PASTE FROM INTERNET/BOOKS! DO NOT COPY FROM ONE ANOTHER! PRODUCE YOUR OWN ASSIGNMENT SOLUTION REPORT. The work submitted must be your own and must not be based on inputs from others. Your assignments shall be submitted to electronic databases to identify plagiarism. If assignment is found to be plagiarised, action will be initiated. Please refer to MEC policy on plagiarism the Student Handbook for more details: Clarification on 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.) 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). 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 COMP 0336 Page 4 of 7 Database Administration (COMP 0336)-FALL-17-CW2(ASSMNT)-QP awarded zero for the work in which plagiarism is detected. In such cases, the student will not be allowed to re-submit the work. C. 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 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 (assignment). D. 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. COMP 0336 Page 5 of 7 Database Administration (COMP 0336)-FALL-17-CW2(ASSMNT)-QP 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 obtained 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 the assessment. (Reference: Module Information Guide) Rules & Regulations  If any topic or diagram of an assignment is found copied from the other then marks will be deducted from both assignments.  Assignments with 3 or more identical topics will be awarded 0 Marks. Assessment Grading Criteria Refer section “Assessment Grading Criteria” in Module Information Guide. This assessment shall assess the following learning outcomes: 1. Manage database instances 2. Manage database storage 3. Design and evaluate database architectures COMP 0336 Page 6 of 7 Database Administration (COMP 0336)-FALL-17-CW2(ASSMNT)-QP Assessment Sheet – Basic Assignment Analysis Student ID and Name: Deliverables Aspects Task 1 Submission of work proposal Deliverables Task 2 Aspects Design & evaluate the database architectures; manage database storage Aspects Manage database storage & instances Deliverables Task 3 Detailed Comments / Feedback: 0-10 Marks  Objectives of the Assignment clearly identified: poor/ fair / clear  Initial understanding of Tasks -2 and Task-3: poor/fair/clear  Resources identified: poor/fair/clear 0-10 11-25 26-40 Poor/weak/incomplete Partially Very good steps and analysis Successful /successful installation of analysis of software utility utility report and fair analysis and analysis of of output. output 0-15 Poor / plagiarized / weak contents and structure of presentation; content mostly incomplete; efforts done for presentation / conceptual skills are not adequate. 16-30 Limited / partial contents and structure of presentation; efforts done for presentation/ conceptual skills are adequate/fair. 31-50 Good / Very good / excellent contents and structure; effrots done for presentation / conceptual skills are good/very good/excellent. Mark Mark Total Marks Penalty Final Marks Signature of the faculty: COMP 0336 Page 7 of 7
Purchase answer to see full attachment