ICT105 – Data Modelling and Database Systems Assessment 1- ER Model and Relational Schema Overview The purpose of this assignment is to develop the student’s skills in designing and implementing a relational database for a given case study. Timelines and important information Percentage value of Task: 30% Due: Week7 , 29-Aug-2021 at 11.59 am Please include SISTC’s assessment cover page at the beginning of the submitted work. Submitting your work late will attract a 10% reduction of mark for each day beyond the due date. A delay of more than 5 days will result in being granted a 0. The whole report should be 1000 words (+/- 10%) excluding personal reflection discussions and references. You need to submit a word version of your report to Moodle. Learning Outcomes Assessed The following course learning outcomes are assessed by completing this assessment task: LO1. Understand the fundamental concepts of relational databases, describe the different models of database management system. LO2. Design a relational database for a provided scenario utilizing tools and techniques including ER diagrams, relation models and normalization. LO3. Interpret entity relationship diagrams to implement database. Assessment Details Background You have been commissioned to create a database for kidsCreative. KidsCreative is an online retail sales company that has two types of inventories, books and toy. They would like a database to manage their inventory, manufacturers, wholesalers, customers, and sales. Some of the report that KidsCreative would like to run from your database design include a list of customers by suburbs and list of inventory by price or other category. They would also like to apply discounts to items by inventory type or other category and apply discounts to VIP customers and to bulk orders. Requirements 1. Design your ER Diagram with all the entity names, attribute names, primary and foreign keys, relationships, cardinality, and participation indicated. You can add entities or attributes as you see fit. All many to many relationships must be resolved. 2. A discussion on normalization, the normal form that each entity is in, how normalization was achieved and why that is optimal. 3. A list of relationships with all table names, attributes, primary and foreign keys indicated as per the conventions given in the lecture slides (i.e., entity/table names in capitals, attributes as proper nouns, primary key underlined and foreign keys in italics). 4. A database schema indicating the type and purpose of all attributes. A suggested structure for the report is given below: Titlepage Executive Summary Table of Contents 1. Introduction 2. ER Diagram 3. Relational Schema 4. Normalization 5. Conclusion 6. References Submission The assignment is to be submitted via the Assignment 1 submission link in LMS. Reference You need to provide reference if necessary, using APA format. Marking Criteria / Rubric General Assessment Requirement Incomprehensible submissions - Assessments provide the opportunity for students to demonstrate their knowledge and skills to achieve the required standard. To do this, assessment responses need to be both clear and easy to understand. If not, SISTC cannot determine that students have demonstrated their knowledge and skills. Assessments will, therefore, be marked accordingly including the potential for 0 (zero) marks where relevant. Check with marking rubric: Before submitting your assessment, you should check it against the assessment criteria and the marking rubric included in this specification to ensure that you have satisfactorily addressed all the criteria that will be used to mark your submission. Feedback Feedback will be supplied through Moodle. Authoritative results will be published on Moodle. Academic Misconduct To submit your assessment task, you must indicate that you have read and understood, and comply with, the Sydney International School of Technology and Commerce Academic Integrity and Student Plagiarism policies and procedures. You must also agree that your work has not been outsourced and is entirely your own except where work quoted is duly acknowledged. Additionally, you must agree that your work has not been submitted for assessment in any other course or program.