ADBA (COMP 0343)-SPRING-17-CW2-ML COMP 0343 Page 1 of 6 SPRING 2017 Individual Assignment No. 2 and Presentation Advanced Database Administration (COMP 0343) Last Date of Submission of Assignment and Presentation Slides: 27-May-2017 (12th Week) Date of Presentation: 27-May-2017 Total Marks: 100 (Scale down to 25) Note: Perform all tasks. Tasks Objectives: 1. Manage client-server connections using RDBMS Net Services 2. Evaluate requirements and select appropriate parameters to ensure effective storage management in a database system 3. Manage Redo log information of a database Marks Deliverables Answer the following questions with respect to advanced database administration. Task # 1 Submit a work proposal for this assignment by the end of week 9th i.e. 6th May, 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.  Resources identified The work proposal must be submitted in a word file through the link available in Moodle. 10 Task # 2 a) Consider you are working as a Database Administrator for ABQ Infotech Co. ABQ Infotech Co. has recently designed and developed a database application for a certain organization. You have been assigned the job to load external data from the existing legacy system to the newly developed system. Discuss the necessary steps required to perform this operation. You must include different data types in data file of legacy system e.g. Number, Varchar, Date etc. in the legacy system data. Your solution must also include the necessary commands and screenshots to load data from variable length and fixed length data file. You may consider any two database management system software’s of your choice. 25 ADBA (COMP 0343)-SPRING-17-CW2-ML COMP 0343 Page 2 of 6 This task must be demonstrated in College Database Lab in Week 12th as part of viva. b) Consider you are working as a DBA for a certain organization. How you would configure the redo log files of the database application systems in the networking environment. Discuss all strategies related with configuration and management of redo log files. Your solution must include the necessary commands with screenshots. 25 Task # 3 Prepare for a presentation in Week#12 on “Advanced Data Types and New Applications”. The presentation must cover one of the following topics:  Temporal data  Spatial and Geographic data Note:  You must upload the presentation slides as a separate file in Moodle.  You may include up to 12-15 slides in the presentation document  Duration of presentation is 15 minutes. 40 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. • Oral examination: 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 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 can be provided if needed 100 Guidelines Follow the guidelines mentioned below for your assignment: ADBA (COMP 0343)-SPRING-17-CW2-ML COMP 0343 Page 3 of 6  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). 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. ADBA (COMP 0343)-SPRING-17-CW2-ML COMP 0343 Page 4 of 6 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 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. ADBA (COMP 0343)-SPRING-17-CW2-ML COMP 0343 Page 5 of 6 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 ADBA (COMP 0343)-SPRING-17-CW2-ML COMP 0343 Page 6 of 6 Spring 2017 Student ID:___________ Student Name:________________________________ Assessment Sheet – Basic Assignment Analysis Deliverables Aspects 0-2.5 3- 6 6.5-10 Delivera bles Task 1 Storage management Incorrect / poor / Weak analysis Fair / good concepts. Very Good/Clear understanding of the concepts Deliverables Aspects 0-10 11- 20 21-25 Marks Task 2a Storage management Incorrect / poor / Weak analysis Fair / good concepts. Very Good/Clear understanding of the concepts Deliverables Aspects 0-10 11-17 18-25 Marks Task 2b Manage Redo Log Files in networking environment. Incomplete / poor /basic analysis Fair/good concepts are clear Complete answer with commands Deliverables Aspects Presentation Max Marks Marks Task 3 Storage management Contents 0-20 Structure 0-20 Total Marks Penalty Final Marks