Changes between Initial Version and Version 1 of InstructionsP5

Timestamp:

01/07/26 19:43:40 (11 days ago)

Author:

vangel.ajanovski

Comment:

—

InstructionsP5

@@ +1 @@
+= 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. ...
+
+}}}