I'm just a beginner seeking some answers. I'm creating a very simple database system for an airline company, just for learning purposes. Here are my questions:
- How to show relationships for entities that I created?
- How can I show normalization in a relationship? (at least third normalization form)
Thanks in advance,
Chitru
Best Answer
It seems you are looking for a tool, that verifies the normalization. There is no such tool (at least I can't think of any since it would be almost impossible do write checks for the noralization).
If you want to see if your schema verifies, use simple logic by observing it. If you are not sure, look at the examples in WIkipedia for 1NF, 2NF and 3NF. Does your model have the same structure as these examples? If yes, than you adhere to normalization.
Your model may look like this (showing only PKs and FKs and example)
If you want tools to visuallize your database, pick one from the list that applies to your DBMS. It lets you check how your entities are connected together.