ICT702 Introduction to Database Design T3 2023

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 1 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A ICT702 INTRODUCTION TO DATABASE DESIGN T323 All information in the Subject Outline is correct at the time of approval. KOI reserves the right to make changes to the Subject Outline if they become necessary. Any changes require the approval of the KOI Academic Board and will be formally advised to those students who may be affected by email and via Moodle. Information contained within this Subject Outline applies to students enrolled in the trimester as indicated 1. General Information 1.1 Administrative Details Associated HE Award(s) Duration Level Subject Coordinator Master of Information Systems (MIS) Graduate Diploma of Information Systems (GDIS) Graduate Certificate of Information Systems (GCIS) 1 trimester Level 8 Graduate Certificate Name: Dr Mohamad Naji Email:mohamad.naji@koi.edu. au P: 92833583 (Ext.156) L: Level 1, 545 Kent St. Consultation: via Moodle or by appointment 1.2 Core / Elective This subject is a core subject for the Graduate Certificate of Information Systems (GCIS). 1.3 Subject Weighting Indicated below is the weighting of this subject and the total course points. Subject Credit Points Total Course Credit Points 4 MIS (64 Credit Points); GDIS (32 Credit Points); GCIS (16 Credit Points) 1.4 Student Workload Indicated below is the expected student workload per week for this subject No. timetabled hours/week* No. personal study hours/week** Total workload hours/week*** 3 hours/week plus supplementary online material 7 hours/week 10 hours/week * Total time spent per week at lectures and tutorials ** Total time students are expected to spend per week in studying, completing assignments, etc. *** Combination of timetable hours and personal study. 1.4 Mode of Delivery Classes will be face-to-face or hybrid. Certain classes will be online (e.g., special arrangements). 1.6 Pre-requisites There are no pre-requisites for this subject. 1.7 General Study and Resource Requirements o Students are expected to attend classes with the required textbook and to read specific chapters prior to the tutorials. Students should read this material before coming to class to improve their ability to participate in the weekly activities. o Students will require access to the internet and their KOI email and should have basic skills in word processing

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 2 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A software such as MS Word, spreadsheet software such as MS Excel and visual presentation software such as MS PowerPoint. o Computers and WIFI facilities are extensively available for student use throughout KOI. Students are encouraged to make use of the campus Library for reference materials. Software resource requirements specific to this subject: Office 365, MS Imagine, SQL Server 2017 1.8 Academic Advising Academic advising is available to students throughout teaching periods including the exam weeks. As well as requesting help during scheduled class times, students have the following options: o Consultation times: A list of consultation hours is provided on the homepage of Moodle where appointments can be booked. o Subject coordinator: Subject coordinators are available for contact via email. The email address of the subject coordinator is provided at the top of this subject outline. o Academic staff: Lecturers and Tutors provide their contact details in Moodle for the specific subject. In most cases, this will be via email. Some subjects may also provide a discussion forum where questions can be raised. o Head of Program: The Head of Program is available to all students in the program if they need advice about their studies and KOI procedures. o Vice President (Academic): The Vice President (Academic) will assist students to resolve complex issues (but may refer students to the relevant lecturers for detailed academic advice). 2. Academic Details 2.1 Overview of the Subject Database management, design and development serve as the foundation of the modern business world and information society. Information that is collected from the customers, the sales revenues that are gathered from the business competitors, the profit and loss that are generated and many more forms of data are required to be stored in a secured, efficient and accessible place, this is called a database. A well-designed database will fundamentally change the decision-making process, data communication process and front-end user experience. Therefore, the design of the database is crucial to conquer the concerns of data collection, data storage and data analysis. This subject provides an overall understanding of database design terminology, database design strategy, database structure and relationships, and level of the data integrity for each database. By completing this subject, students will be able to design a basic relationship database, refine the database structure, integrate the business needs with the database design objectives and implement the database by using a database management system and structured queried language (SQL) Server environments. 2.2 Graduate Attributes for Undergraduate Courses Graduates of Postgraduate courses from King’s Own In stitute will achieve the graduate attributes expected from successful completion of a Master’s degree under the Australian Qualifications Framework (2 nd edition, January 2013). Graduates at this level will be able to apply an advanced body of knowledge from their major area of study in a range of contexts for professional practice or scholarship and as a pathway for further learning. King’s Own Institute’s generic graduate attributes for a master’s level degree are summarised below: KOI Master’s Degree Graduate Attributes Detailed Description Knowledge Current, comprehensive and coherent knowledge, including recent developments and applied research methods

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 4 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A 2.4 Subject Content and Structure Below are details of the subject content and how it is structured, including specific topics covered in lectures and tutorials. Reading refers to the text unless otherwise indicated. Weekly Planner: Week (beginning) Topic Covered in Each Week’s Lecture Reading(s) Expected Work 1 30 Oct Introduction to the relational database ● Types of databases ● Database models ● The relational database models ● Relational database management systems Chapter 1 Critically review the concepts and principles of databases and database management systems including relational data model for handling structured data Formative not graded 2 06 Nov Introduction to entity relationship model ● Understand entity, attribute, cardinality, primary key and foreign key ● Understand associate entity and the complex ER diagram terminology Materials provided on Moodle Design database using ER Modelling 1 Graded 3 13 Nov Introduction to entity relationship model ● Draw ER diagram ● Create tables and ER diagram on the database management system Materials provided on Moodle Design database using ER Modelling 2 Graded 4 20 Nov Terminology used in classic database examples ● Value-related terms ● Structure-related terms ● Relationship-related term Chapter 3 Review questions on the main concepts of database terminology Graded Assessment 2: due Draft proposal of A4 5 27 Nov Database Design Chapter 2 & Chapter 11 Design database using ER Modelling and Normalization Techniques Graded 6 04 Dec Database Design (2) Chapter 2 & Chapter 11 Design database using ER Modelling and Normalization Techniques Graded Assessment 3: due practical exam Table relationships ● Types of relationships Chapter 8 & Chapter 10 Review questions on types of relationships, reducing

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 5 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A 7 11 Dec ● Identifying existing relationships ● Refining all foreign keys ● Establishing relationship characteristics ● Relationship-level integrity the unnecessary relationships & Review questions on table relationship and relation- level integrity Graded 8 02 Jan (Tue) Analysing the current database ● Conducting the analysis ● Looking at how data is collected ● Looking at how information is presented ● Conducting interviews ● Interview users ● Interview management ● Interview questions Chapter 4 Case studies on how data is collected, presented and transit from business needs to database 1 Graded 9 08 Jan SQL for database structure creations Materials provided on Moodle Use SQL to create, query and manipulate database 1 Graded Assessment 4: Due Database design (individual assessment) 10 15 Jan Perform logic information with SQL Materials provided on Moodle Use SQL to create, query and manipulate database 2 Graded 11 22 Jan Review data integrity ● Why you should review data integrity ● Review and refine data integrity Assembling the database documentation Chapter 13 Revie questions on data integrity, case studies on evaluating data integrity Graded 12 29 Jan Introduction to Big Data XML and DTD • Semistructured Data • XML • DTD Revision Materials provided on Moodle Review questions on the table creations on XML, DTD declarations. Emerging trends eg. blockchain. Formative not graded Assessment 5: Database implementation and performance improvement (Group assessment) 13 05 Feb Study review week and Final Exam Week 14 12 Feb Examinations Continuing students - enrolments for T124 open Please see exam timetable for exam date, time and location 15 19 Feb Student Vacation begins New students - enrolments for T124 open

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 7 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A If you fail one or more subjects and you wish to consider applying for a Review of Grade you are STRONGLY ADVISED to attend the Review of Grade Day. You will have the chance to discuss your final exam and subject result with your lecturer, and will be advised if you have valid reasons for applying for a Review of Grade (see Section 3.2 below and the Assessment and Assessment Appeals Policy ). A formal request for a review of grade may not be considered unless you first contact the subject coordinator to discuss the result. Deferred Exams: If you wish to apply for a deferred exam because you are unable to attend the scheduled exam, you should submit the Assignment Extension / Exam Deferment Form available by clicking the following link Assignment Extension / Exam Deferment Form as soon as possible , but no later than three (3) working days of the assessment due date . If you miss your mid-trimester or final exam there is no guarantee you will be offered a deferred exam. You must apply within the stated timeframe and satisfy the conditions for approval to be offered a deferred exam (see Section 8.1 of the Assessment and Assessment Appeals Policy and the Application for Assignment Extension or Deferred Exam Forms ). In assessing your request for a deferred exam, KOI will take into account the information you provide, the severity of the event or circumstance, your performance on other items of assessment in the subject, class attendance and your history of previous applications for special consideration. Deferred mid-trimester exams will be held before the end of week 9. Deferred final exams will be held on two days during week 1 or 2 in the next trimester. You will not normally be granted a deferred exam on the grounds that you mistook the time, date or place of an examination, or that you have made arrangements to be elsewhere at that time; for example, have booked plane tickets. If you are offered a deferred exam, but do not attend you will be awarded 0 marks for the exam . This may mean it becomes difficult for you to pass the subject. If you apply for a deferred exam within the required time frame and satisfy the conditions you will be advised by email (to your KOI student email address) of the time and date for the deferred exam. Please ensure that you are available to take the exam at this time. Marks awarded for the deferred exam will be the marks awarded for that item of assessment towards your final mark in the subject. Supplementary Assessments (Exams and Assessments): A supplementary assessment may be offered to students to provide a final opportunity to demonstrate successful achievement of the learning outcomes of a subject. Supplementary assessments are only offered at the discretion of the Board of Examiners. In considering whether or not to offer a supplementary assessment, KOI will take into account your performance on all the major assessment items in the subject, your attendance, participation and your history of any previous special considerations. If you are offered a supplementary assessment, you will be advised by email to your KOI student email address of the time and due date for the supplementary assessment – supplementary exams will normally be held at the same time as deferred final exams during week 1 or week 2 of the next trimester. You must pass the supplementary assessment to pass the subject. The maximum grade you can achieve in a subject based on a supplementary assessment is a PASS grade. If you: o are offered a supplementary assessment, but fail it; o are offered a supplementary exam, but do not attend; or o are offered a supplementary assessment but do not submit by the due date; you will receive a FAIL grade for the subject. Students are also eligible for a supplementary assessment for their final subject in a course where they fail the subject but have successfully completed all other subjects in the course. You must have completed all major

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 8 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A assessment tasks for the subject and obtained a passing mark on at least one of the major assessment tasks to be eligible for a supplementary assessment. If you believe you meet the criteria for a supplementary assessment for the final subject in your course, but have not received an offer, complete the Complaint, Grievance, Appeal Form and send your form to reception@koi.edu.au . The deadline for applying for supplementary assessment is the Friday of the first week of classes in the next trimester. 2.7 Teaching Methods/Strategies Briefly described below are the teaching methods/strategies used in this subject: o Sessions (3 hours/week) are conducted in seminar style and address the subject content, provide motivation and context and draw on the students’ experience and preparatory reading. Sessions include class discussion of case studies and research papers, practice sets and problem-solving and syndicate work on group projects. Sessions often include group exercises and so contribute to the development of teamwork skills and cultural understanding. Session participation is an essential component of the subject and contributes to the development of many of the graduate attributes (see section 2.2 above). Session participation contributes towards the assessment in many subjects (see details in Section 3.1 for this subject). Supplementary session material such as case studies, recommended readings, review questions etc. will be made available each week in Moodle. o Online teaching resources include class materials, readings, model answers to assignments and exercises and discussion boards. All online materials for this subject as provided by KOI will be found in the Moodle page for this subject. Students should access Moodle regularly as material may be updated at any time during the trimester o Other contact - academic staff may also contact students either via Moodle messaging, or via email to the email address provided to KOI on enrolment. 2.8 Student Assessment Assessment is designed to encourage effective student learning and enable students to develop and demonstrate the skills and knowledge identified in the subject learning outcomes. Assessment tasks during the first half of the study period are usually intended to maximise the developmental function of assessment (formative assessment). These assessment tasks include weekly tutorial exercises (as indicated in the weekly planner) and low stakes graded assessments (as shown in the graded assessment table). The major assessment tasks where students demonstrate their knowledge and skills (summative assessment) generally occur later in the study period. These are the major graded assessment items shown in the graded assessment table. Final grades are awarded by the Board of Examiners in accordance with KOI's Assessment and Assessment Appeals Policy. The definitions and guidelines for the awarding of final grades are: o HD High distinction (85-100%): an outstanding level of achievement in relation to the assessment process. o D Distinction (75-84%): a high level of achievement in relation to the assessment process. o C Credit (65-74%): a better than satisfactory level of achievement in relation to the assessment process. o P Pass (50-64%): a satisfactory level of achievement in relation to the assessment process. o F Fail (0-49%): an unsatisfactory level of achievement in relation to the assessment process. o FW: This grade will be assigned when a student did not submit any of the compulsory assessment items.

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 10 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A your assessments require academic peer reviewed journal articles as sources, you need to access such sources using the Library database, Ebscohost, or Google Scholar. Please ask in the Library if you are unsure how to access Ebscohost. Instructions can also be found in Moodle. 3. Assessment Details 3.1 Details of Each Assessment Item The assessments for this subject are described below. The description includes the type of assessment, its purpose, weighting, due date and submission requirements, the topic of the assessment, details of the task and detailed marking criteria, including a marking rubric for essays, reports and presentations. Supplementary assessment information and assistance can be found in Moodle. KOI expects students to submit their own work in both assignments and exams, or the work of their group in the case of group assignments. Material in assignments which comes from the work of others must be appropriately acknowledged. Assessment 1 Assessment type Assessment type: Tutorial exercises - individual assessment Purpose To answer the weekly tutorial questions on the topics covered in lecturers. This assessment contributes to learning outcomes a, b, c, d and e. Value 10% Due date Week 2 to week 11, on tutorials Submission Submit the completed program on Moodle Task details The details of tutorial exercises will be provided on Moodle. This task contains several practical exercises on database design, development and testing. Marking Rubric for Assessment: 1 ; Value: 10 % Criteria Fail (0 – 49%) Pass (50 – 64%) Credit (65 – 74%) Distinction (75 – 84%) High Distinction (85 – 100%) Tutorial Exercises 10 marks Less than 50%of the tutorial exercises completed or many major errors or omissions Most tutorial exercises completed, but with some major errors or omissions Most tutorial exercises completed, but with some minor errors and omissions Nearly all tutorial exercises completed, but with some minor errors and omissions All tutorial exercises complete and accurate or with few very minor errors Assessment 2 Assessment type Report Purpose This assessment will allow students to review the database design case study of assessment four and understand the information required to be included in the database to meet business requirements. Value 10% Due Date Week 4 Assessment Topic Draft of Assessment 4

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 11 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A Task details In this assignment, students must read, review and analyse the database design case study provided for assessment 4. The student must understand the business requirements for the given case study and identify the information required for database design. The main objective of this draft is to identify entities, attributes, keys, and relationships within the case study. The students must create a detailed list of all entities and their corresponding attributes. They should also identify the primary and foreign keys for each entity. The list should be presented in a tabular format with separate columns for entity names, attribute names, and key types, as shown in the table below. Entity Name Attribute Key Type Customers CustomerID Primary FirstName LastName Orders OrderID Primary CustomerID Foreign OrderDate In addition to the entity and attribute identification, the students are required to identify relationships between the entities. They should describe the type of relationship between each entity, such as one-to-one, one-to- many, or many-to-many. They should also describe the cardinality of each relationship, such as whether it is mandatory or optional. Entity 1 Relationship Type Entity2 Cardinality Customers One - to - Many Orders Mandatory The information should be organised in a clear and concise manner. The final assessment will be based on the proposal draft's completeness, accuracy, clarity, and organisation. Submission requirements details: A draft report should be submitted on Moodle.

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 13 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A Marking Rubric for Assessment: 3 ; Value: 10 % Criteria Fail (0 – 49%) Pass (50 – 64%) Credit (65 – 74%) Distinction (75 – 84%) High Distinction (85 – 100%) Knowledge and Concepts 10 marks Student didn’t show any or minimal understanding of the knowledge and concepts discussed in the lecture Less than 50% correct answers Student show some understanding of the knowledge and concepts discussed in the lecture 50% or more correct answers but less than 65% Students show a good understanding of knowledge and concepts discussed in the lecture with few inaccuracies. 65% or more correct answers but less than 75% Students shows complete understanding of the concepts discussed in the lecture with no inaccuracies. 75% or more correct answers but less than 85% Students shows an excellent understanding of all the concepts discussed in lecture and their practical implementation. 85% or more correct answers Assessment 4 Assessment Type Database design – Individual Assessment Purpose This assessment will help students to design and develop a database based on a given scenario. The students will identify the tables and their relationships and write SQL queries to implement the database. Students are expected to improve the database performance, including the structure, database relationship, integrity and other aspects to make the database more secure, efficient and presentable to business stakeholders. This assessment contributes to learning outcomes b and c. Value 40% Due Date Week 9 Topic The details of the topic will be provided during the sessions Submission Submit the report, including database design and implementation SQL queries on Moodle. Task Details The individual assessment will provide a real-world scenario for the students to develop a database structure for a new website/mobile application to solve business issues. Students are also required to create general samples of basic queries. The queries also serve as a foundation for solving business issues and helping management to make specific business decisions.

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 14 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A Marking Rubric for Assessment: 4 ; Value: 40 % Criteria Fail (0 – 49%) Pass (50 – 64%) Credit (65 – 74%) Distinction (75 – 84%) High Distinction (85 – 100%) Understanding of Business Requirements 5 marks Student has not demonstrated any understanding of the business requirements for the given case study Student has demonstrated a basic understanding of the business requirements for the given case study and has identified only a few of the relevant information required for database design. Student has demonstrated some understanding of the business requirements for the given case study and has identified some of the relevant information required for database design. Student has demonstrated a good understanding of the business requirements for the given case study and has identified most of the relevant information required for database design. Student has demonstrated a deep understanding of the business requirements for the given case study and has identified all relevant information required for database design. Identification of Entities, Attributes, and Keys 5 marks Student has not identified any entities or their corresponding attributes, or has not identified the primary and foreign keys for any entities, or has not presented the information in a clear and concise tabular format. Student has only identified a few entities and their corresponding attributes, and has not identified the primary and foreign keys for most entities, or has not presented the information in a clear and concise tabular format. Student has identified some entities and their corresponding attributes, but has not identified the primary and foreign keys for all entities, or has not presented the information in a clear and concise tabular format. Student has identified most entities and their corresponding attributes, and has identified the primary and foreign keys for most entities in a mostly clear and concise tabular format. Student has accurately identified all entities and their corresponding attributes, and has identified the primary and foreign keys for each entity in a clear and concise tabular format. Identification of relationships and cardinality 5 marks Student has not identified relevant relationships and cardinalities Student has identified only few relationships and cardinalities Student has identified some relationships and cardinalities Student has identified most relevant relationships and cardinalities Student has identified all relevant relationships and cardinalities ER design 10 marks Design an ERD that is completely inaccurate Design a very basic ERD Designs an ERD that is somewhat clear, accurate Designs an ERD that is generally clear, accurate Designs an ERD that is clear, accurate Queries 10 marks No queries can be generated by using the database A few queries can be generated to provide the answers to the business issues but not accurate The available queries are designed to partially answer the business issues The available queries are designed to answer most of the business issues All queries are specifically designed to answer the questions of the given case, the answers are insightful and accurate Structure and Format 5 marks Very difficult to read, unclear structure and most of the required sections are missing Some difficulty in reading, not very clear structure but important sections are included Clear and readable, and all required sections are included. Well written and very clear, and all required sections with completed discussion are included. Well written and very clear, all required sections with completed discussion are included and additional sections have been added for clarity. Assessment 5 Assessment Type Database Implementation and performance - Group Assessment Purpose The case study of database evaluation and improvement will be provided on

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 16 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A Marking Rubric for Assessment: 5 ; Value: 10 % Individual Criteria Fail (0 – 49%) Pass (50 – 64%) Credit (65 – 74%) Distinction (75 – 84%) High Distinction (85 – 100%) Attendance at weekly meetings 1.5 marks Attended less than 50% of the meetings Attended less than 65% of the meetings Attended less than 75% of the meetings Attended less than 85% of the meetings Attended 85% or more of the meetings Weekly activity log 1.5 marks Provided less than 50% of the weekly logs and/or provided scant details Provided less than 65% of the weekly logs and/or provided incomplete details Provided less than 75% of the weekly logs and/or provided only basic details Provided less than 75% of the weekly logs and/or provided most required details Provided less than 75% of the weekly logs and/or provided comprehensive details Time management 1.5 marks Assigned tasks typically late or not completed Most assigned tasks completed by the deadline All assigned tasks completed by the deadline Most assigned tasks completed well in advance of deadline allowing time for revision and refinement All assigned tasks completed well in advance of deadline allowing time for revision and refinement Tasks 1.5 marks Did not complete the tasks assigned Completed most assigned tasks but not thorough and lacking details Completed most assigned tasks in detail Completed all assigned tasks in detail Completed all tasks assigned at a professional level Actual contribution to group project 2 marks Made little or no contribution to the project/report Made a cursory contribution to the project/report Made a fair contribution to the project/report Made a significant contribution to the project/report Made a vital contribution to the project/report Reflection 2 marks Has not been able to provide any of the following: • Discuss your experience of working in a group. • Mention any challenges/ difficulties that you have faced in accomplishing the group project. • Comment on any limitations/ strength of your design. • Comment on whether your database meets all the system requirements as specified. • Mention any assumptions made. Has been able to provide just one of the following: • Discuss your experience of working in a group. • Mention any challenges/ difficulties that you have faced in accomplishing the group project. • Comment on any limitations/ strength of your design. • Comment on whether your database meets all the system requirements as specified. • Mention any assumptions made. Has been able to provide just any two of the following: • Discuss your experience of working in a group. • Mention any challenges/ difficulties that you have faced in accomplishing the group project. • Comment on any limitations/ strength of your design. • Comment on whether your database meets all the system requirements as specified. • Mention any assumptions made. Has been able to provide only any three of the following: • Discuss your experience of working in a group. • Mention any challenges/ difficulties that you have faced in accomplishing the group project. • Comment on any limitations/ strength of your design. • Comment on whether your database meets all the system requirements as specified. • Mention any assumptions made. Has been able to provide all the following: • Discuss your experience of working in a group. • Mention any challenges/ difficulties that you have faced in accomplishing the group project. • Comment on any limitations/ strength of your design. • Comment on whether your database meets all the system requirements as specified. • Mention any assumptions made. Total Mark out of 10 10% COMMENTS:

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 17 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A 3.2 General information about assessment a) Late Penalties and Extensions An important part of business life and key to achieving KOI’s graduate outcome of Professional Skills is the ability to manage workloads and meet deadlines. Completing assessment tasks on time is a good way to master these habits. Students who miss mid-trimester tests and final exams without a valid and accepted reason may not be granted a deferred exam and will be awarded 0 marks for the assessment item. Assessment items which are missed or submitted after the due date/time will attract a penalty unless there is a compelling reason (see below). These penalties are designed to encourage students to develop good time management practices, and to create equity for all students. Any penalties applied will only be up to the maximum marks available for the specific piece of assessment attracting the penalty. Late penalties, granting of extensions and deferred exams are based on the following: In Class Tests and Quizzes (excluding Mid-Trimester Tests) o Generally, extensions are not permitted. A make-up test may only be permitted under very special circumstances where acceptable supporting evidence of illness, hardship or unavoidable problems preventing completion of the assessment is provided (see section (b) below). The procedures and timing to apply for a make-up test (only if available) are as shown in the section Applying for an Extension (see below). o Missing a class test will result in 0 marks for that assessment item unless the above applies. Written Assessments and Video Assessments o There is a late penalty of 5% of the total available marks per calendar day unless an extension is approved (see Applying for an Extension section below). Presentations o Generally, extensions are not permitted. Missing a presentation will result in 0 marks for that assessment item. The rules for make-up presentations are the same as for missing in-class tests (described above). For group presentations, if serious circumstances prevent some members of the group from participating, the members of the group who are present should make their contributions as agreed. If a make-up presentation is approved, the other members of the group will be able to make their individual presentation later and will be marked according to the marking rubric. A video presentation may be used to facilitate the process. Mid-Trimester Tests and Final Exams If students are unable to attend mid-trimester tests or final exams due to illness, hardship or some other unavoidable problem (acceptable to KOI), they must: o Complete the Assignment Extension / Exam Deferment Form available by clicking the following link Assignment Extension / Exam Deferment Form as soon as possible , but no later than three (3) working days after the exam date. o Provide acceptable documentary evidence (see section (b) below). o Agree to attend the deferred exam as set by KOI if a deferred exam is approved. Deferred exam o There will only be one deferred exam offered. o Marks obtained for the deferred exam will be the marks awarded for that assessment item. o If you miss the deferred exam you will be awarded 0 marks for the assessment item. This may mean you are unable to pass the subject. b) Applying for an Extension If students are unable to submit or attend an assessment when due, they must

KING’S OWN INSTITUTE* Success in Higher Education ICT702 INTRODUCTION TO DATABASE DESIGN T323 12-10-23 PAGE 19 OF 19 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A The focus of the adjusted assessment should be on enabling the student to demonstrate achievement of the learning outcomes for the subject, rather than on the method of assessment. e) Appeals Process Full details of the KOI Assessment and Assessment Appeals Policy may be obtained in hard copy from the Library, and on the KOI website www.koi.edu.au under Policies and Forms . Assessments and Mid-Trimester Exams: Where students are not satisfied with the results of an assessment, including mid-trimester exams, they have the right to appeal. The process is as follows: o Discuss the assessment with their tutor or lecturer – students should identify where they feel more marks should have been awarded – students should provide valid reasons based on the marking guide provided for the assessment. Reasons such as “I worked really hard ” are not considered valid. o If still not satisfied, students should complete an Application for Review of Assessment Marks form, clearly explaining the reasons for seeking a review. This form is available from the KOI website under Policies and Forms and is also available at KOI Rece ption (Kent St, Market St and O’Connell St). The completed Application for Review of Assessment Marks form should be submitted as explained on the form with supporting evidence attached to academic@koi.edu.au . o The form must be submitted within ten (10) working days of the return of the marked assessment, or within five (5) working days after the return of the assessment if the assessment is returned after the end of the trimester. Review of Grade – whole of subject and final exams: Where students are not satisfied with the results of the whole subject or with their final exam results, they have the right to request a Review of Grade – see the Assessment and Assessment Appeals Policy for more information. An Application for Review of Grade/Assessment Form (available from the KOI Website under Policies and Forms and from KOI Reception at Kent St, Market St and O’Connell St) should be completed clearly explaining the grounds for the application. The completed application should be submitted as explained on the form, with supporting evidence attached to academic@koi.edu.au .