= Instructions on Phase P5: Normalization

**More details soon ...**

Create and link a wiki page called **Normalization** linked to the main project page in the appropriate phase.


Template for the wiki page.

{{{#!box information 

= Normalization

== Denormalized database form

Process starts from a single relation that includes all attributes from the model.

* Functional dependencies
* Candidate keys and primary key


== 1NF decomposition

Bring the initial schema to a relational schema in 1NF based on the   dependencies and keys.

Check for loss-less join and preservation of functional dependencies in each decomposition step.

== 2NF decomposition

...

== 3NF decomposition 

...

== BCNF if possible

...

== Final result and discussion

List the final relations and name them appropriately and discuss any diferences from the model in Phase P2.

}}}



**AI Use**

You are free to use an AI to improve your work, provided that you adhere to the following rules:

 * you use AI in this phase of the project only to improve your own initial word
 * you use AI to create alternate solutions for ideas that you can borrow and use in your own solution
 * you document the changes you have made to your own work based on the ideas from the AI tool in the history above
 * you document the entire usage of the AI tool in a new wiki page named **NormalizationAIUsage** linked here, that you structure according to the following template

{{{#!box information

= Normalization AI Usage

**Name of AI service/solution that was used**

URL:

Type of service/subscription: 

**Final result**

Results in details / description:

**Entire AI usage log**

 1. Line-by-line Log of all interactions with the AI (prompt and response) 
 2. ...

}}}