Chap2-The Relational Database Model

Chap2-The Relational Database Model - The Relational...

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

View Full Document Right Arrow Icon
The Relational Database Model
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Objectives In this session you will learn That the relational database model takes a logical view of the database The basic components like entities, attributes and relationships How entities and relationships are organized into tables About the relational database operators Handling redundancy
Background image of page 2
3 The Relational Model The relational database focuses on the logical representation of the data and its relationship rather than physical storage details Tables play a prominent role in the relational model
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 ENTITIES Relational design begins by defining the required entities An entity is something about which you want to store data Example: Person, Place, concept or event
Background image of page 4
5 Continued… Entities are grouped according to their common characteristics An Entity Set is a named collection of entities that share common characteristics. The name of the entity set reflects its contents Example: STUDENT, FACULTY, etc.
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 ATTRIBUTES Each entity has certain characteristics known as attributes Example: STUDENT entity includes the attributes student registration number, name, grade, dob, etc.
Background image of page 6
7 TABLE A table is perceived as a two-dimensional structure composed of rows and columns. A table contains a group of related entities
Background image of page 7

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

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

This note was uploaded on 06/27/2011 for the course COMPUTER S 133 taught by Professor Andrewstrauss during the Spring '11 term at Bucks Community College.

Page1 / 28

Chap2-The Relational Database Model - The Relational...

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

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