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.

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

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. …