Genial Storyboard Guide
hammad_choudhry
Created on October 7, 2024
More creations to inspire you
Transcript
Copyright © Hammad Choudhry
Btec IT
Unit 2
Hammad and Nithush
The stages of normalisation
Lorem ipsum dolor sit amet consecteteur
Btec IT
Unit 2
What is normalisation
Normalisation involves dividing large tables into smaller, more manageable tables and defining relationships between them to ensure data consistency and efficiency. Entity relationship diagrams identify entities and their different relationships. This allows users to easily locate data.
Copyright © Hammad Choudhry
Btec IT
Unit 2
1st Normal form
Stage 1
The first stage of normalization, called First Normal Form (1NF), ensures that a table's structure is organized so that each column contains only atomic values and each row is unique.
- Eliminate Repeating Groups: Split data into smaller tables so that there are no repeated groups or multiple values in a single cell.
- Ensure Each Column Holds Only One Value: Each column must contain only one value (e.g., no lists or arrays).
- Identify a Primary Key: Ensure every table has a primary key that uniquely identifies each row.
purposes of 1nf
Definition
Copyright © Hammad Choudhry
Lorem ipsum dolor sit amet consecteteur
Btec IT
Unit 2
1st Normal form
Stage 1
The first stage of normalization, called First Normal Form (1NF), ensures that a table's structure is organized so that each column contains only atomic values and each row is unique.
- Eliminate Repeating Groups: Split data into smaller tables so that there are no repeated groups or multiple values in a single cell.
- Ensure Each Column Holds Only One Value: Each column must contain only one value (e.g., no lists or arrays).
- Identify a Primary Key: Ensure every table has a primary key that uniquely identifies each row.
purposes of 1nf
Definition
Copyright © Hammad Choudhry
Lorem ipsum dolor sit amet consecteteur
Btec IT
Unit 2
2nd Normal form
Stage 2
Second Normal Form (2NF), builds on 1NF by ensuring that all non-key attributes are fully dependent on the primary key. 2NF checks if any 1NF data needs a composite key. If a composite key is needed, the data is moved to a different table.
Definition
purposes of 2NF
- Remove partial dependencies: If a table has a composite primary key, make sure that non-key attributes are dependent on the entire key, not just part of it.
- create separate tables for different fields: Split the table into multiple tables to ensure non-key columns are linked only to the complete primary key.
Copyright © Hammad Choudhry
Lorem ipsum dolor sit amet consecteteur
Btec IT
Unit 2
3rd Normal Form
Final stage
Definition
Purposes of 3nf
Third Normal Form (3NF) aims to further eliminate redundancy and dependancies by ensuring that all non-key attributes are only dependent on the primary key.
Copyright © Hammad Choudhry
- Remove Transitive Dependencies: Ensure that non-key attributes do not depend on other non-key attributes.
- Direct Dependence on the Primary Key: Every non-key attribute should be directly dependent on the primary key only.
- Any keys that are dependant to a different field should be moved to a different table
Lorem ipsum dolor sit amet consecteteur
Btec IT
Unit 2
Thank you
Copyright © Hammad Choudhry
- Visit the Analytics settings;
- Activate user tracking;
- Let the communication flow!
Use this space to add awesome interactivity. Include text, images, videos, tables, PDFs... even interactive questions!Premium tip: Get information on how your audience interacts with your creation:
Got an idea?
Here you can include a relevant fact to highlight
Here you can include a relevant fact to highlight
- Visit the Analytics settings;
- Activate user tracking;
- Let the communication flow!
Use this space to add awesome interactivity. Include text, images, videos, tables, PDFs... even interactive questions!Premium tip: Get information on how your audience interacts with your creation:
Got an idea?
Here you can include a relevant fact to highlight
Here you can include a relevant fact to highlight
- Visit the Analytics settings;
- Activate user tracking;
- Let the communication flow!
Use this space to add awesome interactivity. Include text, images, videos, tables, PDFs... even interactive questions!Premium tip: Get information on how your audience interacts with your creation:
Got an idea?
Here you can include a relevant fact to highlight
Here you can include a relevant fact to highlight
- Visit the Analytics settings;
- Activate user tracking;
- Let the communication flow!
Use this space to add awesome interactivity. Include text, images, videos, tables, PDFs... even interactive questions!Premium tip: Get information on how your audience interacts with your creation:
Got an idea?
Here you can include a relevant fact to highlight
Here you can include a relevant fact to highlight
- Generate experiences with your content.
- It’s got the Wow effect. Very Wow.
- Make sure your audience remembers the message.
With Genially templates, you can include visual resources to wow your audience. You can also highlight a particular sentence or piece of information so that it sticks in your audience’s minds, or even embed external content to surprise them: Whatever you like!Do you need more reasons to create dynamic content? No problem! 90% of the information we assimilate is received through sight and, what’s more, we retain 42% more information when the content moves.
Let the communication flow!
Got an idea?
Here you can include a relevant fact to highlight
- Generate experiences with your content.
- It’s got the Wow effect. Very Wow.
- Make sure your audience remembers the message.
With Genially templates, you can include visual resources to wow your audience. You can also highlight a particular sentence or piece of information so that it sticks in your audience’s minds, or even embed external content to surprise them: Whatever you like!Do you need more reasons to create dynamic content? No problem! 90% of the information we assimilate is received through sight and, what’s more, we retain 42% more information when the content moves.
Let the communication flow!
Got an idea?
Here you can include a relevant fact to highlight
- Generate experiences with your content.
- It’s got the Wow effect. Very Wow.
- Make sure your audience remembers the message.
With Genially templates, you can include visual resources to wow your audience. You can also highlight a particular sentence or piece of information so that it sticks in your audience’s minds, or even embed external content to surprise them: Whatever you like!Do you need more reasons to create dynamic content? No problem! 90% of the information we assimilate is received through sight and, what’s more, we retain 42% more information when the content moves.
Let the communication flow!
Got an idea?
Here you can include a relevant fact to highlight
- Generate experiences with your content.
- It’s got the Wow effect. Very Wow.
- Make sure your audience remembers the message.
With Genially templates, you can include visual resources to wow your audience. You can also highlight a particular sentence or piece of information so that it sticks in your audience’s minds, or even embed external content to surprise them: Whatever you like!Do you need more reasons to create dynamic content? No problem! 90% of the information we assimilate is received through sight and, what’s more, we retain 42% more information when the content moves.
Let the communication flow!
Got an idea?
Here you can include a relevant fact to highlight
- Generate experiences with your content.
- It’s got the Wow effect. Very Wow.
- Make sure your audience remembers the message.
With Genially templates, you can include visual resources to wow your audience. You can also highlight a particular sentence or piece of information so that it sticks in your audience’s minds, or even embed external content to surprise them: Whatever you like!Do you need more reasons to create dynamic content? No problem! 90% of the information we assimilate is received through sight and, what’s more, we retain 42% more information when the content moves.
Let the communication flow!
Got an idea?
Here you can include a relevant fact to highlight
- Visit the Analytics settings;
- Activate user tracking;
- Let the communication flow!
Use this space to add awesome interactivity. Include text, images, videos, tables, PDFs... even interactive questions!Premium tip: Get information on how your audience interacts with your creation:
Got an idea?
Here you can include a relevant fact to highlight
Here you can include a relevant fact to highlight
- Generate experiences with your content.
- It’s got the Wow effect. Very Wow.
- Make sure your audience remembers the message.
With Genially templates, you can include visual resources to wow your audience. You can also highlight a particular sentence or piece of information so that it sticks in your audience’s minds, or even embed external content to surprise them: Whatever you like!Do you need more reasons to create dynamic content? No problem! 90% of the information we assimilate is received through sight and, what’s more, we retain 42% more information when the content moves.
Let the communication flow!
Got an idea?
Here you can include a relevant fact to highlight
- Generate experiences with your content.
- It’s got the Wow effect. Very Wow.
- Make sure your audience remembers the message.
With Genially templates, you can include visual resources to wow your audience. You can also highlight a particular sentence or piece of information so that it sticks in your audience’s minds, or even embed external content to surprise them: Whatever you like!Do you need more reasons to create dynamic content? No problem! 90% of the information we assimilate is received through sight and, what’s more, we retain 42% more information when the content moves.
Let the communication flow!
Got an idea?
Here you can include a relevant fact to highlight
- Generate experiences with your content.
- It’s got the Wow effect. Very Wow.
- Make sure your audience remembers the message.
With Genially templates, you can include visual resources to wow your audience. You can also highlight a particular sentence or piece of information so that it sticks in your audience’s minds, or even embed external content to surprise them: Whatever you like!Do you need more reasons to create dynamic content? No problem! 90% of the information we assimilate is received through sight and, what’s more, we retain 42% more information when the content moves.
Let the communication flow!
Got an idea?
Here you can include a relevant fact to highlight
- Generate experiences with your content.
- It’s got the Wow effect. Very Wow.
- Make sure your audience remembers the message.
With Genially templates, you can include visual resources to wow your audience. You can also highlight a particular sentence or piece of information so that it sticks in your audience’s minds, or even embed external content to surprise them: Whatever you like!Do you need more reasons to create dynamic content? No problem! 90% of the information we assimilate is received through sight and, what’s more, we retain 42% more information when the content moves.
Let the communication flow!
Got an idea?
Here you can include a relevant fact to highlight
- Generate experiences with your content.
- It’s got the Wow effect. Very Wow.
- Make sure your audience remembers the message.
With Genially templates, you can include visual resources to wow your audience. You can also highlight a particular sentence or piece of information so that it sticks in your audience’s minds, or even embed external content to surprise them: Whatever you like!Do you need more reasons to create dynamic content? No problem! 90% of the information we assimilate is received through sight and, what’s more, we retain 42% more information when the content moves.
Let the communication flow!
Got an idea?
Here you can include a relevant fact to highlight