Individual Assignment Database Administration (COMP 0336) Last Date of Submission: 26-NOV-2016, 11:55 pm (7th Week) Total Marks: 100 Note: Then will scaled down to 20 Note: Perform all the tasks. Task s Objectives: 1. Create and maintain a database server 2. Manage database instances 3. Manage database storage Marks Task # 1 Submit a work proposal for this assignment by the end of week 4th i.e. 5 nd Nov, 2016 (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 Arabian Beats is a company that organizes musical events in Sultanate of Oman. The company maintains information about its member music bands and the recording they have made. Each music band (A music band is defined by its registration number, name, location and rating) has at least one and possibly many musicians (A musician is defined by his identity number, name and the instrument he plays). A musician belongs to exactly one music band. A musician has exactly one university degree (A degree has a number, name and degree certificate has name of the degree awarding university). A degree is awarded to more than one musician. The music band has more than one composition to their credit (A composition has composition id, name and rating). A 20+35 particular composition is recorded exactly by a music band. Each composition is directed by a music director (Music director has identification number, name and address). A music director may not direct any composition or may direct more than one composition. A music director has exactly one university degree. In view of the given scenario discuss the following: a) As DBA discuss how would you Monitor database performance for Arabian Beats. b) As a database administrator perform the following tasks: [Lab demo is required to manage instance for the above scenario. There will be no marks without a lab demo. The lab demo schedule will be announce in week #8] 1. Create appropriate tablespace for the above scenario as per OFA. (5 Marks) 2. Create a Schema with appropriate privileges and use the above created (1i)tablespace as default table space.(5Marks) 3. Create appropriate tables for the above ER-Diagram by identifying and adding foreign keys to the required entities as per the scenario.(10 Marks) 4. Create at least four views of which two should be complex views.(5 Marks) 5. Create two indexes.(5 Marks) 6. Create two synonyms. (5 Marks) Note:  Include the necessary screenshots in the solution. Task # 3 The web link to a research paper related with database security is given below: Baccam S., "SANS Oracle Database Security Course author/instructor", 2015, https://www.sans.org/reading-room/whitepapers/analyst/oracle- database-security-secure-34885 (this link is given in college Moodle webpage) Discuss the following in your own words: a) Discuss the need of having database security in any institution aslo as DBA what you need to secure. b) Discuss the differeces between the Authentication and Auditing with appropriate example . Note:  The solution must be in your words and should not exceed 3 pages.  The given research paper is for your reference only and you may refer various authentic resources and provide the references for the same.  You may include necessary examples and diagrams if any. 20+15 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 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 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 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