4 - Relational Data Model and Relational Database...

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

View Full Document Right Arrow Icon
Relational Data Model and Relational Database Constraints (Lecture Session-4) Chapter 5 Wed, January 27, 2010 1 DLPD, BITS-Pilani. Prepared by Dr.R. Gururaj, Asst.Professor of CS
Background image of page 1

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

View Full DocumentRight Arrow Icon
Wed, January 27, 2010 DLPD, BITS-Pilani. Prepared by Dr.R. Gururaj, Asst.Professor of CS 2 Contents 1.What is Relational model 2.Characteristics 3.Relational constrains 4.Representation of schemas
Background image of page 2
Relational Model It is a representational data model. Using this representational (or implementation) model we represent a database as collection of relations . The notion of relation here is different from the notion of relationship used in ER modeling. A relation here is thought of as a table of values. Each row in the table represents a collection of related data. Each row contains facts about some entity of some entity-set. Wed, January 27, 2010 3 DLPD, BITS-Pilani. Prepared by Dr.R. Gururaj, Asst.Professor of CS
Background image of page 3

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

View Full DocumentRight Arrow Icon
Entities of each type/set are stored as rows in a single relation. Hence in general, a relation corresponds to a single entity. In some cases a relationship between two entities can have some specific attributes which can be captured in a relation (table).
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/14/2010 for the course CSE IS ZC332 taught by Professor Shailendrasshekhawat during the Summer '10 term at Birla Institute of Technology & Science.

Page1 / 15

4 - Relational Data Model and Relational Database...

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

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