Deliverables Aspects 0-11 12-24 25-30 Task 3a Implementing database security policies. Presentation based on the selected topic Poor / weak concepts of redo logs; SQL commands are not given or mostly incorrect; no screenshots Concepts/plannin g of redo logs is fair; some of the SQL commands are given with screenshots; incomplete solution Proper planning of redo logs; excellent concepts; SQL commands are included; screenshots are given. Deliverables 0-11 12-24 25-30 Task 3b Poor / weak contents and structure of the chosen topic; content mostly incomplete; conceptual skills are not adequate. Fair / partial contents and structure; conceptual skills are adequate/fair. Good / Very good / excellent contents and structure; conceptual skills are good/very good/excellent.

Deliverables Aspects 0-10 Marks Task 1 Submission of work proposal • Objectives of the Assignment clearly identified: poor/ fair / clear • Initial understanding of Task -2 and Task-3: poor/fair/clear • Resources identified: poor/fair/clear Deliverables Aspects 0-11 12-24 25-30 Marks Task 2a Establishing a Poor/weak/incomple Partially correct Very good database connection te database database /successful between a client and connection between connection connectivity a database server client and server. between client between client and and server server; completion explanation of steps

Guidelines Follow the guidelines mentioned below for your assignment: Code developed (Soft Copy) should be included. 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 Feedback shall be given in Moodle within one week from the last date of submission of work proposal and within two weeks after submission of final assignment document.

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. • Presentation and Viva are compulsory, shall be held in Week-13. • Correct information analysis and presentation in document form. • Adequate referencing (in CU Harvard style) and citation provided • Examples can be provided if needed

• Detailed solution should be written for the topic chosen for presentation. The solution for task-3 (3a and 3b) must be written in a maximum of 5 pages. • You must upload the solutions of task-2, task-3a and task-3b in one MS Word document. • Duration of presentation is 10 minutes • Prepare a separate presentation file of 8-10 slides to be used during presentation. • Time of presentation will be informed to you later (based on the Session timings).

Use ORACLE sql plus because i need to use this in my pc Task one i need it today only one page clarify what will don to implement this Assignment according to they requirement that mention on Assignment paper (upload) Submit a work proposal for this assignment by the end of week 8th i.e. which must include: • Understanding of deliverables – a detail description of deliverables • General overview of proposed plan - initial understanding of solution for the task-2 and task-3. • Resources identified