# data[].attributes.body
1) Normalization refers to reducing redundant data from a database

# data[].attributes.body
0NF: It is unnormalized form data is not atomic
1NF: It is normalized form, data is in atomic form

# data[].attributes.body
Which subject is it closely related to?
Normalisation is used in most IT dominated fields. It is often applied in data science as a part of data preparation for machine learning.

# data[].attributes.body
Normalization is the process of efficiently organizing data in a database. Ultimately, there are two goals of the normalization process. The first is to remove the same data in more that one table redundant data. The second is to make sure data dependencies makes sense by having only related data stored in the same table. The two ultimate goals highlighted are important as they help reduce the amount of space a database consumes and ensure that data is logically stored.

# data[].attributes.body
1NF (First Normal Form)

2NF (Second Normal Form)

3NF (Third Normal Form)

# data[].attributes.body
0NF or UNF:
- Has Non-Atomic Data
- Data is repeated
1NF:
-Data is Atomic
-May have a primary key
2NF:
-Partial dependency
-Primary key & Foreign key
3NF:
-Data is directly dependent.

# data[].attributes.body
It may be used to hold data for the residents such as, Full name, date of birth, Emirates ID, Health issues,
Job information. All the data is collected by the Government.

# data[].attributes.body
Database normalization is the process of structuring a database, usually a relational database, in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity

# data[].attributes.body
Q1) Normalization is the process of reorganizing data in a database so that it meets two basic requirements
Q2)

1NF (First Normal Form)

2NF (Second Normal Form)

3NF (Third Normal Form)

# data[].attributes.body
0NF:
The data will be non-atomic
The fields names might not be unique.
Repeating attributes.

1NF:
It should only have atomic data
Values stored in a column should be of same domain.
All data fields must have unique data fields.
The order of how data is stored does not matter.

2NF:
It should be in 1st Normal Form.
It should not have partial dependency.
It may have a foreign and primary key.

3NF:
Should be in 2NF.
It doesn’t have Transitive Dependency.
No non-key attribute is transitively dependent on the primary key.

# data[].attributes.body
Data of residents like their passports and Emirates ID would need to be normalised in order for their data to be accurate and be used to identify residents easily

# data[].attributes.body
In the UAE the emirates ID is an essential part for every resident, therefore having normalized data is important to make sure that the data doesn't get mixed up with other residents of UAE as this can result in major issues while updating or looking up for the resident

# data[].attributes.headline
Do you think it is necessary to normalize data ?

# data[].attributes.subject
Do you think it is necessary to normalize data ?

# data[].attributes.body
-sneha 12D
yes , for the following reasons :

(1) to reduce duplication of data -
One of the biggest impacts of normalizing your data is reducing the number of duplicates in your database. Normalizing your data before matching and merging duplicates will make it easier to find the duplicates

(2) performance and metrics -
Databases that aren’t standardized and poorly maintained can cause major headaches when it comes to analyzing the data. By standardizing your data, and using a single organizational method with proper capitalization, your data will be significantly easier to sort through

# data[].attributes.body
Yes, it is necessary to normalise data because:
To Eliminate the redundant or useless data

To Reduce the complexity of the data

To Ensure the relationship between tables as well as data in the tables
To Ensure data dependencies and data is logically stored.

# data[].attributes.body
1) Normalization is organizing data in a database to reduce data redundancy and increase data integrity. The main purpose of normalization is to reduce the amount of duplicated data and to   simply the structure of a database.

2)

UNF or 0NF (Unnormalized form)

1NF (First Normal form)

2NF (Second Normal form)

3NF (Third Normal form)

# data[].attributes.body
describe the characteristics of data in

unnormalised form (0NF),

first normal form (1NF),

second normal form (2NF

third normal form (3NF)

To identify the normal form

Normalise a database to 3NF

# data[].attributes.headline
G5 - List characteristics of different normal forms

# data[].attributes.subject
G5 - List characteristics of different normal forms

# data[].attributes.body
1. Explain what is normalisation

2. List the different normal forms

# data[].attributes.body
Name the key ethical challenges for humanity and discuss the need for the moral values to be adhered to in managing resources and testing students’ knowledge and understanding of an important application of ICT in database management system like keeping consistent data and maintaining the integrity of data.Is it connected to Data Protection act. If so which principle?

# data[].attributes.body
Give one real life application in Dubai where you think they will be using normalisation in holding residents data

# data[].attributes.headline
How is it connected to moral values and which value is it connected to?

# data[].attributes.subject
How is it connected to moral values and which value is it connected to?

# data[].attributes.body
1. What is the need for normalisation in day to day life.

2. Do you think it is necessary to normalise data

3. Which Subject is it closely related to ?