Schema = Schematic Diagram? (1 Viewer)

[Makro]

I'm confused between the difference from them. They both seem like the same thing with one being a graphical form. Can anyone give me an example of both to distinguish between?

EDIT: Also is an ERD = Schematic diagram? If not, please explain.

Thanks in advance.

 

[ondroo]

For the purposes of this course they all mean the same thing. A schema, schematic diagram and entity relationship diagram are all just diagrams showing each entity (table) of a relational database as well as the attributes (fields) and relationships (between primary/secondary/foreign keys, e.g. one to one, one to many, many to many)

Just like the ones ms access makes

Hope that answers ur question

 

[Makro]

Thanks