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,

  • 2
    What do you mean by show? Graphically? If so, have you looked at Entity Relationship Diagrams yet? They are the common way to show relations and .... If you want to show relationships for entities already in a database, there are many tools that can connect to a database and visualize the setup. – DrColossos Jul 1 '11 at 7:46
  • Let me consider i've flight, passengers, payment as my entities and i've used Relational format for relationship between them now how can i show normalization in their relationship. any idea to show show them. n thanku for the reply.. – xtru1990 Jul 1 '11 at 8:34

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)

flight_id (PK)



-- Your join table, that lets you connect all the data. I assume that the a passenger may book a flight more than once, so I join them together with a certain flight and payment.

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.

| improve this answer | |

Part of the point of developing a formal data model is that a formal model can support automation. The relational model is a formal data model.

SQL isn't relational, but practically speaking it's the closest thing we have.

Given either functional dependencies or representative sample data, CASE software can conceivably derive or verify every possible 3NF or 5NF schema. IBM built one such CASE product--Rational Data Architect.

I'm sure there are others. Research combinations of the words CASE, database, and normalization.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.