Modul-DB2-2010

Modul-DB2-2010 - Data Management, Part DB_2 Andreas Meier,...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Data Management, Part DB_2 Andreas Meier, University of Fribourg August 2010 1 Andreas Meier, Department for Informatics, University of Fribourg, Switzerland Folie 1 DB_2 The Entity Relationship Model Andreas Meier, Department for Informatics, University of Fribourg, Switzerland Slide 2 DB_2 Learning ! Targets • Why is information modeling necessary? • What are the main steps in data modeling? • What is understood by an entity resp. entity set? • What are relationships and relationship sets? • What is the difference between a Venn diagram and an the Entity Relationship Model? • What are the most essential relationship types? • What forms of simple-simple, hierarchical and network relationships do exist? • How can an example from a University be transferred into an Entity Relationship Model? Andreas Meier, Department for Informatics, University of Fribourg, Switzerland Why is Information Modeling necessary? Slide 3 Real World Model Information System Andreas Meier, Department for Informatics, University of Fribourg, Switzerland Building Blocks of Data Modeling Slide 4 Objectives System description and boundary List of requirements Real World Entity Sets Tables Transactions resp. SQL-Queries Relationship Sets HDBMS XMLDBMS NDBMS RDBMS Entity Relationship Model ORDBMS Andreas Meier, Department for Informatics, University of Fribourg, Switzerland Step 1 – Data Analysis Slide 5 Andreas Meier, Department for Informatics, University of Fribourg, Switzerland Step 2 – Entity Relationship Model Slide 6 Data and data relations are expressed with tables The query and manipulation language is relational. It transfers tables into tables. Entity Relationship Model Entity Sets Relationship Sets Department Subor dinates Employee Project Affiliates Data Management, Part DB_2 Andreas Meier, University of Fribourg August 2010 2 Andreas Meier, Department for Informatics, University of Fribourg, Switzerland Step 3 – Relational Database Scheme...
View Full Document

Page1 / 4

Modul-DB2-2010 - Data Management, Part DB_2 Andreas Meier,...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online