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...

1 answer below »
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.
Answered 1 days AfterAug 29, 2021

Answer To: ICT105 – Data Modelling and Database Systems Assessment 1- ER Model and Relational Schema Overview...

Deepti answered on Aug 30 2021
138 Votes
Executive Summary
This report proposes a database management system for the target company KidsCreative that offers products to its customers through online portal. The proposed database shall manage the cus
tomers, sales, manufacturers, wholesalers and inventory through a single integrated platform.
The document discusses the entities, their attributes and relationships among them. This information is used to create the conceptual model of the database into ER diagram. Relational model is built using the prepared information with discreetly identifying the primary and foreign keys.
Contents
Executive Summary    1
Introduction    2
Assumptions    2
Entities    2
Attributes    2
Relationships    2
E R Diagram    3
Relational Schema    3
Normalization    4
Conclusion    5
References    5
Introduction
The KidsCreative company is an online portal that sells different products online. It makes the products available to customers through several manufacturers and wholesalers. The online and delivery operations are tracked and accomplished through the online application of KidsCreative. This report discusses the database management system for the company. The database is designed to facilitate the management of data such as storing the details of various manufacturers and wholesalers who sell their product through the company portal, the personal information about the customers who buy products from the portal, the details about the sales done through the portal, the products that are displayed and available for sale through the portal offered by the manufacturers and wholesalers and the details about the inventory.
The database system shall offer an integrated platform to support online shopping to its customers and displaying products by its manufacturers as well as wholesalers. The database shall store all the information and simultaneously maintaining the inventory and sales information. Inventory can be easily managed and the challenge of human error during sales of products and maintenance of inventory is eliminated. The DBMS shall prevent the issues of double sales...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here