5. have collaborative and technical skills to apply information requirements specification processes in the broader systems analysis and design context for designing high-quality relational databases ILO Criteria Standards Below Expectations Meets Expectations Exceeds Expectations Level 1 (e.g. F) Level 2 (e.g. P) Level 3 (e.g. C) Level 4 (e.g. D) Level 5 (e.g. HD) 5 Physical Database Design 1 Workbench EER diagram (6 marks) 2 Physical database table, and indexes (10 marks) 3 Enter data in database tables (4 marks) No submission or submission containing little or no material relevant to a potential project sponsor. Some omissions and/or inconsistencies such that a potential project sponsor would not consider offering the project to the student. Minor omissions and/or inconsistencies which might raise some concerns in a potential project sponsor as to the student's capabilities and/or motivation. Sufficient detail such that a potential project sponsor could be satisfied the student is aware of and understands all obvious relevant issues.

5 Logical database design 3 Create ER diagram showing global logical data model (4 marks) 4 Create a table showing all entities, attributes, primary key and one or more foreign keys, as well as with all necessary referential constraints.(6 marks) No submission or material in the submission incomprehensible. Submitted on time and/or much too long or too short and/or illogical structure or inconsistent style. Submitted on time and of adequate size but not demonstrating a serious attempt to engage the audience and/or cater to the audience's expectations and requirements. A serious attempt to cater to the expectations of a potential project sponsor but nonetheless with opportunities to improve in structure, presentation etc. A clear, concise, well- structured and easily understood communication.

GROUP PRACTICAL ASSIGNMENT 1 CONCEPTUAL AND LOGICAL DATABASE DESIGN Intended Learning Outcomes (ILOs) 5. have collaborative and technical skills to apply information requirements specification processes in the broader systems analysis and design context for designing high-quality relational databases ILO Criteria Standards Below Expectations Meets Expectations Exceeds Expectations Level 1 (e.g. F) Level 2 (e.g. P) Level 3 (e.g. C) Level 4 (e.g. DI) Level 5 (e.g. HD) 5 Conceptual Database Design 1 Data Dictionary (4 marks) 2 ER-Diagram (6 marks) No submission or submission containing little or no material relevant to a potential project sponsor. Some omissions and/or inconsistencies such that a potential project sponsor would not consider offering the project to the student. Minor omissions and/or inconsistencies which might raise some concerns in a potential project sponsor as to the student's capabilities and/or motivation. Sufficient detail such that a potential project sponsor could be satisfied the student is aware of and understands all obvious relevant issues.