Want to make interactive content? It’s easy in Genially!

Over 30 million people build interactive content in Genially.

Check out what others have designed:

Transcript

Learning Objectives

During this module we'll outline the key concepts you need to understand before starting the simulation. We'll also cover the goals you should aim to achieve, ensuring you're well-prepared for the tasks ahead.

Remembering

Understanding

Applying

Analysing

Evaluating

Creating

Detailed breakdown

Here's a breakdown of what's to come in the course.

Learning objectives

Remembering: Identify key database components (customers, products, orders) based on your chosen business scenario.Understanding: Define a goal for the database diagram, such as modelling customer orders in an e-commerce platform, to structure and visualise relevant data.

Preparation Task

(10 minutes)

Applying: Search for online resources on database design best practices and examples relevant to your scenario.Analysing: Make notes on database structure, focusing on entity relationships, normalisation, and optimising query performance for scalability.

Research Task

(20 minutes)

Applying: Organise and refine your list of entities and relationships based on your scenario.Analysing: Consider how data will flow between tables and how this structure will facilitate visualisation tasks like tracking sales trends or customer activity.

Analysis Task

(15 minutes)

Detailed breakdown

Here's a breakdown of what's to come in the course.

Learning objectives

Applying: Use a database diagramming tool to create tables, define attributes, and establish relationships between entities (customer ID linking orders).Evaluating: Ensure the diagram follows normalisation principles to avoid data redundancy. Review the relationships to maintain data integrity and optimise query performance.

Create Task

(40 minutes)

Creating: Write a report explaining the rationale behind your database design decisions, including how you applied normalisation and structured the data for visualisation.Evaluating: Present your design and receive feedback to refine the database, making sure it meets the business case's needs.

Document & Present

(10 minutes)

Evaluating: Reflect on the challenges faced while designing the database, such as defining relationships or applying normalisation.Understanding: Consider how this database design process can inform future data visualisation projects, particularly structuring data for dashboards or reports.

Reflection Task

(10 minutes)

Conclusion

By completing this activity, you will have hands-on experience in creating a detailed database diagram that adheres to best practices for scalability and data integrity. You will improve your ability to structure complex datasets for efficient retrieval and data visualisation, preparing you for real-world applications in business intelligence, data visualisation, and database management.Now that you're all prepped, mark this section as complete and let's make a start on the simulation module!

Learning objectives

  • Assess the effectiveness of your database design by evaluating the relationships and data flow between entities. Ensure the structure supports key use cases for reporting and data visualisation.
  • Evaluate the database for scalability and query performance, checking if normalisation principles are applied effectively and whether the design avoids redundancy.

  • Break down the business scenario or dataset to identify core entities, their attributes, and relationships, considering the flow of data between tables.
  • Organise the tables to reduce redundancy and optimise the relationships between entities, ensuring efficient query performance and data retrieval.

  • Choose a specific business scenario (e-commerce or CRM) and define the entities that need to be modelled in a database.
  • Create a rough outline of the database structure, identifying entities, fields, and relationships using a database diagramming tool (Lucidchart, Draw.io, MySQL Workbench).

  • Explain why database diagrams are critical for structuring data in business scenarios, facilitating efficient data storage and retrieval.
  • Describe how database structure impacts data visualisation, focusing on how well-designed databases support query performance and scalability.

  • Identify common types of entities and relationships in database diagramming for different business scenarios (customers, products, orders for e-commerce)
  • List the key steps in database diagramming, such as identifying entities, defining relationships, normalising the database, and ensuring data integrity.

  • Develop a detailed database diagram, including primary keys, foreign keys, and relationships, with the appropriate data types and constraints for each entity.
  • Summarise your design decisions in a report, explaining how your database structure supports data retrieval for visualisation purposes, such as generating business reports and dashboards.