Your Task
Read the Assessment Instructions and complete sections (1)–(4).
Consider the rubric at the end of the assignment for guidance on structure.
Submit your written report (in Word) via MyKBS by Week __.
Assessment Description
You have been hired as a database designer by a small business that sells products online. The business wants to create a relational database to store information about their customers, products, orders, and payments. They want to be able to view sales data, customer information, and inventory levels.
Case Study
KBS Pty Ltd is a small business that sells products online. The company is expanding its operations and is looking to improve their data management systems. They currently have a system that stores customer information, product information, and order information in separate files, which has become difficult to manage as the business grows. They want to create a relational database to store all their data in one place, making it easier to manage and report on.
Assessment Instructions
You are required to complete the following tasks:
- Design an entity-relationship model (ERM) for the database using Lucidchart’s modeling tool, and include all required tables, columns, and relationships.
- Normalise the tables to 3rd Normal Form (3NF) using appropriate data normalisation techniques.
- Create a report outlining your database design and data normalisation.
Your Report Should Include the Following Sections
- Introduction: A brief overview of the business and the purpose of the database.
- Entity-Relationship Model: A diagram and explanation of the ERM, including all tables, columns, and relationships using Crow’s Foot notation.
- Normalisation: An explanation of the normalisation techniques used and how the tables were normalised to 3NF.
- Conclusion: A summary of your design decisions and any limitations of your database.
Please refer to the assessment marking guide to assist you in completing all the assessment tasks.
Generative AI Traffic Lights
Please see the level of Generative AI that this assessment has been designed to accept:
| Traffic Light | Amount of Generative Artificial Intelligence (AI) Usage | Evidence Required |
|---|---|---|
| Level 1 | This assessment fully integrates Generative AI, encouraging you to harness the technology’s full potential in collaboration with your own expertise. It will highlight your ability to demonstrate how effectively you can work alongside AI to achieve sophisticated outcomes, blending human intellect and artificial intelligence. | Your collaboration with AI must be clearly referenced and documented in the appendix of your submission, including all prompts and responses used for the assessment. |
| Level 2 | This assessment invites you to engage with Generative AI as a means of expanding your creativity and idea generation. It will highlight your ability to complement your original thinking with the capabilities of AI—for example, through brainstorming and preliminary concept development. | Your collaboration with AI must be clearly referenced and documented in the appendix of your submission, including all prompts and responses used for the assessment. |
| Level 3 | This assessment showcases your individual knowledge and skills in the absence of Generative AI support. It will highlight your personal abilities—for example, to analyse, synthesise, and create based on your own understanding and learning. |