Book

Only available on StudyMode
  • Download(s) : 39
  • Published : December 6, 2012
Open Document
Text Preview
Relational Database Concepts
IBM Information Management Cloud Computing Center of Competence IBM Canada Labs 1
© 2011 IBM Corporation

Agenda
• Overview • Information and Data Models • The relational model • Entity-Relationship diagrams • Types of relationships • Mapping entities to tables • Relational model concepts • Relational model constraints • Normalization

2

© 2011 IBM Corporation

Supporting reading material & videos
• Reading materials • Database Fundamentals eBook
• • • • Chapter 1: Databases and information models Chapter 2: The relational data model Chapter 3: The conceptual data model (optional) Chapter 4: Relational database design (optional)

• Videos • db2university.com course AA001EN
• Lesson 1: Relational database concepts

3

© 2011 IBM Corporation

Agenda
• Overview • Information and Data Models • The relational model • Entity-Relationship diagrams • Types of relationships • Mapping entities to tables • Relational model concepts • Relational model constraints • Normalization

4

© 2011 IBM Corporation

Data vs. Information

• Data:

Collection of letters, numbers or facts

• Information: Processed data that provides value

5

© 2011 IBM Corporation

Databases and DBMS
• Databases • A repository of data • DBMS (Database management system) • Software system that manages databases • The terms “Database”, “DBMS”, “data server”, “database server” often used interchangeably to refer to a DBMS • Why a DBMS? • Security • Can handle many users with good performance • Allows for concurrency while keeping data consistent • Protects from disaster 6

© 2011 IBM Corporation

Agenda
• Overview • Information and Data Models • The relational model • Entity-Relationship diagrams • Types of relationships • Mapping entities to tables • Relational model concepts • Relational model constraints • Normalization

7

© 2011 IBM Corporation

Information and Data Models
Relationship between an Information Model and a Data Model

8

© 2011 IBM Corporation

Data Models • Network • Hierarchical • Relational • Entity-Relationship • Extended relational • Semantic • Object-oriented • Object-relational • Semi-structured

9

© 2011 IBM Corporation

Agenda
• Overview • Information and Data Models • The relational model • Entity-Relationship diagrams • Types of relationships • Mapping entities to tables • Relational model concepts • Relational model constraints • Normalization

10

© 2011 IBM Corporation

Relational Model

11

© 2011 IBM Corporation

Entity-Relationship Diagrams

• Building Blocks • Entities • Attributes
Entity

Attribute

12

© 2011 IBM Corporation

Entity and Attributes

13

© 2011 IBM Corporation

ER diagram

Title Description Editon

Aisle

Book

Year

Pages ISBN Price

14

© 2011 IBM Corporation

Exercise: Identify entities and attributes

House Social Security Number Product Date Height
15

Phone # Computer

Order #
© 2011 IBM Corporation

Did you get them right?

House Social Security Number Product Date Height
16

Phone # Computer

Order #
© 2011 IBM Corporation

Agenda
• Overview • Entity-relationship diagrams • The relational model • Entity-Relationship diagrams • Types of relationships • Mapping entities to tables • Relational model concepts • Relational model constraints • Normalization

17

© 2011 IBM Corporation

Relationships

• Building Blocks
– Entity sets – Relationship sets – Crows Foot notations

18

© 2011 IBM Corporation

ERD of Book

Title Description Editon

Aisle

Book

Year

Pages ISBN Price

19

© 2011 IBM Corporation

ERD of Author

Author_Id

Lastname

Country

Author

Firstname

City

Email

20

© 2011 IBM Corporation

Example 1

21

© 2011 IBM Corporation

Example 2

22

© 2011 IBM Corporation

Types of Relationships

Book

Authored By

Author

One-to-one Relationship...
tracking img