2 - Data Modeling using Entity-Relationship(ER) Model...

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

View Full Document Right Arrow Icon
Data Modeling using Entity-Relationship(ER) Model (Lecture Session-2) Monday, January 18, 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
Monday, January 18, 2010 DLPD, BITS-Pilani. Prepared by Dr.R. Gururaj, Asst.Professor of CS 2 Contents 1.Steps I Database Design process 2.Intro to ER Modeling 3.Concepts 4.Notations 5.Reading ER models
Background image of page 2
Major Steps in Database Design Requirement analysis Understanding the domain Identifying the data to be stored Identifying the constraints Conceptual level design >Designing conceptual schema (E-R modeling) Relational schema design >Designing tables and relationships Refinement of schema Physical database design Indexing Clustering Storage Monday, January 18, 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
is a popular high level (conceptual) data model. ER model allows us to describe the data involved in a real-world environment in terms of objects and their relationships, which are widely used in design of database. ER model provides preliminary concepts or idea about the data representation which is later modified to achieve final detailed design. Important concepts used in ER modeling are- Entity is an object in real-world or some idea or concept which can be distinguished from other objects. Ex.: person, school, class, department, weather, salary, temperature etc. Entity has independent existence. Entityset
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.

Page1 / 14

2 - Data Modeling using Entity-Relationship(ER) Model...

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