Want to make creations as awesome as this one?

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