This lecture covers conceptual modelling of databases and especially using the Entity-Relationship (E-R) model.




We will look at
  • Entity, relation, attribute
  • E-R diagrams




References

Delivered material
  • Frederiksen Helle, 2000, "Databasedesign med Access 2000". IDG Forlag, Valby. (103 pp.). http://www.idgforlag.dk/. ('Analyse' sid. 36-38, 'Dataanalyse' sid. 51-56).
    or
  • Mose Ole, 1997, "Access - praktisk databasdesign". IDG Bøger 1997, Carl Jocobsens Vej 25, 2500 Valby. (36 199 100, 36 199 199 fax). http://mirror.idgforlag.dk/. (119 pp.) (69:- DkK).
    (Chapter 4-7,9,11).

Further reading




Questions (examples):

  • What is a Entity-relation diagram and how can it be used?
  • Describe how conceptual models of tye building process can be expressed.



©Per Christiansson, 6.3.2001 [6.3.2001]