Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question
1  
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.. –  Newa Chitru Jul 1 '11 at 8:34
add comment

2 Answers

up vote 1 down vote accepted

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
-------------------
flight_id (PK)
destination
[....]

passengers
-----------------
passenger_id
surname
lastname
nr_of_seats
[....]

payment
--------------------
payment_id
date
price
[....]

-- 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.
reservation 
----------------------
flight_id
passenger_id
payment_id
[....]

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.

share|improve this answer
    
that was helpful thank you!!! –  Newa Chitru Jul 2 '11 at 0:58
    
If this is a correct answer for you, you should accept it (dba.stackexchange.com/faq#howtoask) –  DrColossos Jul 2 '11 at 8:35
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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