Normalization 10 No evidence of normalization process Try to attempt normalization with no logical rationales. Normalization attempted but incomplete/errors. Normalized few the relations up to 3NF. Given some explanation. Normalized most the relations up to 3NF.Given explanation for few of the relations. Normalized correctly all the relations up to 3NF. Given explanation for most of the relations. Normalized correctly all the relations up to 3NF. Detailed explanation is given for normalization.

Logical schema 20 No Logical Schema covered. Full Incorrect Logical schema presented with major errors. Logical schema given is given considering few entities with some errors. Correct logical schema given considering all the entities. Most of the primary keys are identified and underlined; very few of the foreign keys are identified and marked correctly. Complete logical schema is given considering most of the entities, breaking up many-many relationships. Most of the primary keys are identified and underlined; few of the foreign keys are identified and marked correctly. Correct logical schema given is given considering the entities, breaking up many-many relationships. All entities shown with correct primary key and foreign key. Unique, not null and check constraint applied is correct. Correct and complete logical schema given is given considering all the entities, breaking up many-many relationships. All the constraints applied and well documented.

10 No Data dictionary included in the report. Inadequate Data dictionary structure shown or shown with major errors. Data dictionary with partially correct details like description, domain, size. The constraints not applied. Data dictionary presented in satisfactory way (with proper attributes, size, domain and description). Primary key, foreign keys for the attributes is identified. Detailed Data dictionary is presented with proper attributes, size, domain and description. Few constraints are applied in proper way. Detailed data dictionary is presented with proper attributes, size, domain and description. All the constraints like not null, unique, primary key, foreign key, and check are applied in proper way. Complete and detailed data dictionary is presented with proper attributes, size, domain and description. All the required constraints like not null, unique, primary key, foreign key, check are applied and well documented.

E-R Diagram 30 No ER Diagram included. Inappropriate diagram with incorrect structure produced. E-R diagram with some entities, attributes, improper relationship between the entities with relation name, and cardinalities. Tried to convert to logical schema. Diagram produced using correct symbols but does not correctly document the information needs. Converted E-R to logical schema applying the rules. Diagram produced using documents information requirements, but some entities, attributes and relationships not properly documented. Logical schema is shown. Good diagram with most entities, attributes and relationships properly documented. Correct logical schema, with proper keys. Excellent diagram with all the required entities, attributes and relationships are properly documented. Proper rules used to convert to logical schema, proper use of keys.

Requirements analysis 20 No requirement identification and need for application Not proper Requirement analysis. Miss match between topic and requirements. Requirement analysis is incomplete. Entities partially identified. The relationship are incomplete/errors. Requirement are collected. Entities identified are correct (5-6). The relationship matrix shown is satisfactory. Entities identified are correct. Relationship matrix showing proper relationship between entities. Good documentation on the requirement analysis procedure. All entities are identified; Proper relationship matrix is shown to depict the relationship between entities. The requirements and the method used in data collection is clearly documented. Requirements and expectations of the users are collected and analyzed properly. Entities are identified with proper relationship matrix. Excellent documentation on the requirement gathering procedures used.

Criteria Weight (%) Substandard 0 Poor 20 Satisfactory 40 Good 50 Very Good 60 Excellent 70 Outstanding 100 Initial Study 10 Overview given has no relevance to the topic/company but doesn't include the problems, operational process The initial study given has some relevance to the topic/company but doesn't include the problems, operational process, and need of database. Brief write-up on how the company works is given, what problems and limitations users have is not clearly stated, need of database is not clearly defined. Write-up on how the company works, what problems and limitations users have, need of database is defined in satisfactory manner. Good write-up on how the company works, what problems and limitations users have, need of database is well understood. Very good study done on the topic chosen, write-up on how the company works, problems and limitations of company, need of database, with proper reasoning. Excellent write-up on how the company works problems, operational process and limitations, need of database with proper references.

E 4 Refer • Unsatisfactory/ Compensable fail. • Serious errors and omissions. • Very little analysis F 2 Fail • Work of a very poor standard with little relevant information and/or serious errors. F- 1 • Work containing little of merit G 0 • No work submitted

D+ 7 Pass • Satisfactory. • Shows sufficient grasp of the subject to be acceptable. • Tends to be descriptive. • Examples and evidence is likely to be weak and limited. • Shows limited reading. • Referencing is likely to be absent or very poorly carried out.

B- 11 C+ 10 Good • Generally good work. • Most points will have been covered, but many finer points will generally have been missed. • Shows limited reading. • Arguments/analysis should be basically well structured and balanced with relevant examples, but with errors and gaps. • The writing is clear, but has errors that nevertheless do not obscure the meaning. • Referencing will be present but may at times be inaccurate or insufficient. C 9

A 15 A- 14 B+ 13 Very Good • Very good work. • All main points will have been covered, though minor issues may have been omitted. • The work will be analytical, balanced and soundly based. • Examples and supporting evidence should have been included. • The writing should be essentially correct, without major grammatical or other errors. • Generally referenced correctly.

Assessment Grading Criteria Although grades may be awarded on the basis of marks in some assessments, students should note that both marks and grades will be awarded on the basis of the assessment criteria for each grade. GRADE GRADE POINT DESCRIPTION GENERAL ASSESSMENT CRITERIA A+ 16 Excellent • An outstanding piece of work. • Shows evidence of wider reading and originality • Strongly analytical. All important points are covered. • Arguments should be supported by examples and evidence, objectively presented and evaluated, • Well-structured and well written, without noticeable grammatical or other errors. • Correctly referenced

• The last submission, within the deadline, will be considered as your final submission. • The similarity percentage of your final submission will be one of the factors considered, for assessing the originality of your assignment. However, the decision to report an assignment for plagiarism is taken by the Lecturers, who mark your assignment. • The Lecturers will consider a number of factors such as Assignment type, Part of the assignment where similarity occurs, Nature of similarity etc., along with the similarity percentage of your assignment, to assess the originality of your assignment. Therefore, similarity percentage would not be accepted as a basis for disputing academic judgments regarding plagiarism. • Note that the similarity percentage of your submission can change till the submission deadline, if the submissions of other students have similarity to your assignment. Therefore, the similarity percentages are not final, till the assignment submission is closed.

Additional Guidelines • The Assignment Submission link on MOVE will be open, a week ahead of the submission date. • You can submit your assignment multiple times, till the submission deadline. Note that Turnitin could take up to 24 hours to produce similarity reports for submissions. • Assignments should be submitted by 6pm on the day of the deadline. There is a grace period until midnight to allow for any technical difficulties, but any assignments submitted after this will be counted as late. Technical problems will not be accepted as an excuse for submitting after the day of the deadline

9. All assignments must be adhered strictly to the deadlines specified by Majan College. Failure to hand in the assignment for any reason and without prior approval and a valid written extension from the module tutor will not be marked and will be awarded a grade G (0) irrespective of the quality of the work. See Student handbook page 16 section 4.4. 10. Unacknowledged use of work of others (plagiarism) is regarded as a dishonest practice and will be will be penalized. See the penalties in the student’s handbook page 35-36 section 5.8.

6. This assignment carries 50% weightingtoward final grades. 7. This assignment follows a design format and must be original and creative. An analytical piece of work is required. The use of ‘cut and paste’ approach will be penalized. It must be presented in a structured manner, with appropriate cover page, content page, introduction, body (with appropriate heading / sub-headings), conclusion, references, page numbered and any required appendices. 8. The cover page should be attached with the assignment and uploaded through MOVE (on-line. Name of the student, The Programme, Module Title and Assignment Title reflected on the cover sheet.

1. This is anIndividual Assignment. 2. The assignment MUST be submitted online (through MOVE) inWeek 9. 3. Your assignment shall reflect the depth and breadth of your original analyses in a clear and coherent manner. 4. Use of the relevant academic literature to support ideas and issues discussed. The range of academic sources such as texts and journals to support your arguments and comments. 5. Any reference to authors and other writers shall be quoted with due acknowledgement in your assignment report using the Harvard Referencing System. For details of Harvard referencing style refer the student’s hand book page 41 sections 7.2.

It is very important to follow the guideline above to prepare and organize your report. Omission of any part of the report will result in deduction of the grade. You can submit your drafts on your module tutor’s email or you can bring softcopy and show it to your module tutor until week 8. There will be no drafts checked during the submission week i.e., week 9. Having your drafts checked is an advantage as you can keep track on whether you are in the right path in doing your work.

• I/We confirm that I/We have read, understood and followed the guidelines for assignment submission and presentation provided by the lecturer. • I/We understand that this assignment may be retained on the database and used to make comparisons with other assignments in future. • I/We have made a copy of my assignment. • This work may be photocopied and/or communicated for the purpose of identifying plagiarism. • I/We give permission for a copy of this marked assignment to be retained by the faculty of Information Technology for the purpose of course reviews by external examiners and to be used as a resource by Majan College. • I/We understand that unauthorized late submission without a valid written extension will not be marked and will be awarded a grade G (0) irrespective of the quality of the workas per the college policy mentioned in the Students handbook section 4.4.

• The work contained in this assignment is my own and that all materials and sources used have been acknowledged. • I/We have not copied or colluded in part or in whole, or otherwise plagiarised the work of other students. • This assignment has not been submitted for previous assessment in any other subject or to a substantial extent has been accepted for the award of any other unit, module, degree or diploma of a university or any other institute, except where due acknowledgement is made in the text.