0 0-1 2-4 5 Task 4.c. Weak, major, Omission, little understanding of given tasks, Not able to prove knowledge in this tasks. Most of the details are not relevant. Or Information provided is not real. Adequate knowledge of key principles and concepts and/or adequate evidence of the application of theory in practice Adequate very basic concept, Not enough efforts in data collection, all data is not real Good attempt. Good knowledge or key principles and concepts and/or good knowledge of the application of theory in practice Excellent knowledge and understanding of principles and concepts and /or excellent knowledge and understanding of the application of theory in practice

Task #4 0 0-1 2-4 5 Marks Task 4.a. Weak, major, Omission, little understanding of given tasks, Not able to prove knowledge in this tasks. Most of the details are not relevant. Or Information provided is not real. Weak explanation of back ground of the organization selected. Good Attempt Demonstrate adequate knowledge of organization with proper explanation of Organization selected. 0 1-3 4-8 9-10 Task 4.b. Weak, major, Omission, little understanding of given tasks, Not able to prove knowledge in this tasks. Most of the details are not relevant. Or Information provided is not real. Adequate knowledge of key principles and concepts and/or adequate evidence of the application of theory in practice Adequate very basic concept, Not enough efforts in data collection, all data is not real Good attempt. Good knowledge or key principles and concepts and/or good knowledge of the application of theory in practice Excellent knowledge and understanding of principles and concepts and /or excellent knowledge and understanding of the application of theory in practice

iii 0 1-20 Marks No answer 5 marks for each table with appropriate constraint created as per the scenario. (3 marks each for table creation without constraint. 2 mark each for constraints like primary key, not null etc….) iv 0 1-5 6-10 Marks No answer Create a less complex view and not used for select data Create a complex view ( by using ‘inner join’) and used it for select data ( screen shots must be provided ) v 0 1-5 6-10 No answer Only one sequence created with minor errors. TWO Sequences created and provided evidence for data insert.

Tasks #3 (No marks without a lab demonstration) Or fail to demonstrate/prove his/ her own work i 0 1-3 4-5 Marks No answer Physical Structure without OFA guidelines Physical Structure with OFA guidelines and rename it ii 0 1-3 4-5 Marks No Separate Schema Only A schema created Schema created with appropriate storage specification and Grant command is used.

Assessment Analysis Sheet Student ID: ……………………………………….. Student Name: ……………………………………………… Work Proposal 0 1-5 6-10 Marks Tasks #1 No Submission or student has failed to understand the requirements of the case study Little understanding of deliverables – a detail description of deliverables General overview of task 2 and 3 Understanding of deliverables – a detail description of deliverables General overview of task 1,2& 3 0 1-8 9-16 17 - 20 Marks Tasks #2 Irrelevant or no concept. Very limited information provided with few mistakes. Discussed about SGA, PGA and User session with limited information. All instance Architecture mentioned and discussed in detail; demonstrating the knowledge.

? 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

Evaluation Criteria Detailed evaluation criteria has been given in evaluation grid at the end of the document. Lab demonstration and written viva. There will be no marks without written Viva . The written Viva is to measure originality of your work. ZERO marks will be awarded to the student if she / he is absent for VIVA. During presentation, you may asked to write SQL queries for checking the originality of the student work.