) Total Marks100 Note Perform all the tasks. Tasks Ob

) Total Marks:100 Note: Perform all the tasks. Tasks Objectives: 1. Manage database instances 2. Manage database storage 3. Design and evaluate database architectures Marks Task # 1 Submit a work proposal for this assignment by the week 8th i.e. 29th APR, 2017 (11:59 pm) which must include: Understanding of deliverables – a detail description of deliverables General overview ofproposed plan – initial understanding of solution for the task-2 to task-3. Identify the topic of presentation from the list oftopics given in task- 3. Resources identified The work proposal must be submitted in a word file through the link available inMoodle. 10 Task # 2 One of the required task of a Database Administrator is to establish the database connection between the client and the server. 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 tosave in the database server. Your solution must also include the necessary commands and the screenshots at both the client and the database server. b) Discuss in your own words, the database functionality tasks carried out by the database server in a client/server database environment. 40+15 Task # 3 Prepare for a presentation in Week 11 for all the learning outcomes of this module. 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 35 Evaluation Criteria: There will be no markswithout 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 the tasks given in the assignment. ZERO marks will beawarded to the student if she / he is absent for VIVA. COMP 0336 Page 2 of 7 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. Guidelines 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 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 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. 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 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 Assessment Sheet – Basic Assignment Analysis Student ID and Name: Deliverables Aspects 0-10 Marks Task 1 Submission of work proposal Objectives of the Assignmentclearly identified: poor/ fair / clear Initial understanding of Tasks -2 and Task-3: poor/fair/clear Resources identified: poor/fair/clear Deliverables Aspects 0-19 20-34 35-55 Mark Task 2 Design & evaluate the database architectures; manage database storage Poor/weak/incomplete steps and analysis Partially Successful installation of software utility and fair analysis of output. Very good /successful analysis of utility report and analysis of output Deliverables Aspects 0-10 11-19 20-35 Mark Task 3 Manage database storage & instances Poor / plagiarized / weak contents and structure of presentation; content mostly incomplete; efforts done for presentation / conceptual skills are not adequate. Limited / partial contents and structure of presentation; efforts done for presentation/ conceptual skills are adequate/fair. Good / Very good / excellent contents and structure; effrots done for presentation / conceptual skills are good/very good/excellent. TotalMarks Penalty Final Marks Detailed Comments / Feedback: Signature of the faculty: