Relational schema / dependency diagram

[Firestrider]

Can someone link me to a website that can show me how to make a relational schema and dependency diagram from a E-R diagram?

 

[mathmate]

If you google ERD, you get a whole lot of sites, all of which are useful, depending on the level of difficulty you require, here are some examples:

http://en.wikipedia.org/wiki/Entity-relationship_model
http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter2/node8.html
http://www.smartdraw.com/tutorials/software/erd/tutorial_01.htm


If you need more specific help, please post again.

 

[Firestrider]

So a relational schema and dependency diagram is the same as a ERD?

Basically I have to convert a ERD to 3NF showing relational schema and dependency diagram.

 

[mathmate]

ERD stands for entity-relationship diagram. The purpose of the ERD is to show the relational schema and dependencies between the data entities in a succinct but precise manner.

To make an ERD, one would require how the entities work together, i.e. the relationship between different data, including the tables, the keys, the relationship between the table attributes. For example, a teacher teaches one or more classes, a student attends zero or more classes, a transcript is dependent on zero or more class marks and the student ID, etc.

From established business rules, an ERD displays the characteristics and relationships between the different entities.