Exercise 1
Problem Statement
A company maintains a table to track employee projects. The table is as follows:
| Employee_ID | Employee_Name | Project_ID | Project_Name | Project_Manager |
|---|---|---|---|---|
| 101 | Alice | P1 | Alpha | John |
| 101 | Alice | P2 | Beta | Sarah |
| 102 | Bob | P1 | Alpha | John |
| 103 | Charlie | P3 | Gamma | Alice |
Analyze whether this table is in Second Normal Form (2NF). If it is not, provide a solution by converting the table into 2NF.
Hint
- Identify the primary key of the table.
- Check for any attributes that depend only on a part of the primary key.
We will discuss the solution in the next lesson.
🤖 Don't fully get this? Learn it with Claude
Stuck on Exercise 1? Open Claude, copy a block below, and it'll teach you this exact concept — visually and interactively.
🎨 Explain it visually
Build the mental picture, not memorization.
I just read a lesson on **Exercise 1** (Databases) and want to truly understand it. Explain Exercise 1 from first principles using ONE vivid real-world analogy and a visual mental model — draw it as ASCII art or a clear step-by-step diagram — with a concrete example using real numbers. Then ask me one question to check I got the mental picture, and wait for my reply. If you're unsure or a claim isn't standard, say so and reason from first principles instead of guessing.
🤔 Walk me through it (interactive)
Socratic — adapts to where you're stuck.
Teach me **Exercise 1** interactively. Ask me ONE guiding question at a time, wait for my answer, and adapt to my confusion — build the idea with me step by step instead of explaining it all at once. If you're unsure or a claim isn't standard, say so and reason from first principles instead of guessing.
🧪 Quiz me & fix my gaps
Active recall exposes what you missed.
Quiz me on **Exercise 1** with 5 questions, easy to tricky, ONE at a time. Tell me if each answer is right; at the end, explain clearly what I got wrong and why. If you're unsure or a claim isn't standard, say so and reason from first principles instead of guessing.
🧠 Make it stick
Intuition + hook + flashcards for long-term memory.
Help me remember **Exercise 1** for the long term: give the one-sentence intuition, a memorable hook/mnemonic, a tiny worked example, and 3 active-recall flashcards (Q -> A). If you're unsure or a claim isn't standard, say so and reason from first principles instead of guessing.