Not Signed-In
Which clippings matchs 'Entity-Relationship Modelling' pg.1 of 1
01 FEBRUARY 2013

Entity Relationship Diagramming video tutorial

Fig.1 Gina Baldazzi (2013). "Entity Relationship Diagram (ERD) Training Video", 15 minutes.

1

TAGS

ridge table • business rules • cardinality • crows foot notation • data modellingdata modelling techniquedatabase design • database entity • design techniquediagrammatic visualisationEntity-Relationship DiagramEntity-Relationship ModellingERDERMinformation architectureinformation design • intersection table • logical database designlogical relationshipslogical structurenotation • primary key • relational modelling • relationship modelling • tuple • unique key • video tutorial

CONTRIBUTOR

Simon Perkins
10 JULY 2009

Case*Method: Entity Relationship Modelling

"powerful technique of entity relationship modelling from this definitive guide. In a lucid instructional style, Richard Barker shows how the data modelling technique can be applied to develop high–quality, integrated information systems."

Richard Barker (1990). CASE* Method: Entity Relationship Modelling, Addison–Wesley.

[Entity-Relationship Modelling is a method for designing a 'logical' database (as apposed to creating a 'physical' database). In the notation an 'entity' is a logical way of describing a database table. Each entity has properties, which are a logical way of describing database fields. Each entity will more than likely have a relationship with other entities, these are expressed in terms of either a 'many-to-one' or a 'one-to-many' or a 'one-to-one relationship. Note that it is not logically possible to have a 'many-to-many' relationship - in such cases an 'intersection table' is inserted.]

1

TAGS

3NF • Case Method • data • data administrators • data analysis • data analysts • data modelling • data modelling language • data modelling technique • data normalising • data strategists • database design • database normalisation • definitive definition • definitive guide • design techniquediagrammatic visualisation • Edgar Codd • entity • Entity-Relationship DiagramEntity-Relationship ModellingERDERM • flight ticket ERD • graphical information model • hierarchical visualisationinformation design • integrated information systems • Integration DEFinition for Information Modelling (IDEF1X) • logical database design • logical hierarchy • logical relationshipslogical structure • lucid instructional style • normal form • normalisation process • referential integrity • relationship modelling • Richard Barker • semantic data modelling • softbox • software engineering • third normal form • Third Normal Form (3NF)

CONTRIBUTOR

Simon Perkins
Sign-In

Sign-In to Folksonomy

Can't access your account?

New to Folksonomy?

Sign-Up or learn more.