The E-R Model

Sep 09, 2012

610 likes | 723 Views

Share Presentation

Embed Code

Link

chrissy

Download Presentation

The E-R Model

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

1. 1�1 The E-R Model Prof. Sin-Min Lee Department of Computer Science

Mapping from E-R Model to Relational Model

Mapping from E-R Model to Relational Model. Yong Choi School of Business CSUB. Objectives of logical design. Translate the conceptual design into a logical database design that can be implemented on a chosen DBMS Input: conceptual model (ERD) Output: relational schema, normalized relations

626 views • 34 slides

EER: Enhanced E-R Model

EER: Enhanced E-R Model. Specialization / Generalization SubClass / SuperClass. Subclasses for Different Roles. SuperClass: Staff SubClasses: Manager SalesPersonnel Secretary. Common and Different Attributes. SuperClass:

480 views • 12 slides

Chapter 3 The Enhanced E-R Model

Chapter 3 The Enhanced E-R Model. Jason C. H. Chen, Ph.D. Professor of MIS School of Business Administration Gonzaga University Spokane, WA 99258 chen@jepson.gonzaga.edu. Objectives. Define terms Understand use of supertype/subtype relationships

1.05k views • 42 slides

Chapter 3 The Enhanced E-R Model

Chapter 3 The Enhanced E-R Model. Jason C. H. Chen, Ph.D. Professor of MIS School of Business Administration Gonzaga University Spokane, WA 99258 chen@jepson.gonzaga.edu. #3-a ( p.143). #3-b ( p.143). #3-c ( p.143). #3-d ( p.143). #3-e ( p.143). #9 ( p.143). #9 ( p.143).

380 views • 24 slides

E-R Model

E-R Model. A database can be modeled as: a collection of entities, relationship among entities. An entity is an object that exists and is distinguishable from other objects. Example: specific person, company, event, plant Entities have attributes

546 views • 35 slides

The E/R model, triggers, HTML5

The E/R model, triggers, HTML5. Reminder … next Tuesday is the first exam. E/R. A design front end for relational databases, not as an independent model Intended to have a visual syntax As opposed to “semantic” models that were intended as alternatives to the relational model

204 views • 12 slides

Chapter 4: The Enhanced E-R Model

Modern Database Management 11 th Edition Jeffrey A. Hoffer, V. Ramesh, Heikki Topi. Chapter 4: The Enhanced E-R Model. Objectives. Define terms Understand use of supertype/subtype relationships Understand use of specialization and generalization techniques

905 views • 33 slides

E-R Model

E-R Model . The E-R model is not intended to be associated with any particular database model. E-R diagrams are intended to allow humans the ability to capture more of the application ’ s meaning. History of E-R Model.

740 views • 60 slides

The Entity-Relationship (E-R) Model

The Entity-Relationship (E-R) Model. Lecture Topics Basic E-R modelling Extensions to E-R modelling Designing an E-R schema Deriving relational schema from E-R diagrams Textbook Chapter 2 Section 3.5. Overview of E-R model. used for database (conceptual schema) design

631 views • 47 slides

Entity – Relationship Model (E-R Model)

Entity – Relationship Model (E-R Model). Entity – Relationship Model. The overall logical structure of a database can be expressed graphically using E-R diagrams. Features of E-R Model This is used to give structure to the data . Model can be evolved independent of any DBMS

599 views • 30 slides

Entity-Relationship (E-R) Model

Entity-Relationship (E-R) Model. COURSE #. CTITILE. PROF. SCHED. ROOM. COURSE. ENROLL. GRADE. STUDENT. SNAME. CREDITS. STUID. MAJOR. * Sometimes it’s natural to classify the entities in an entity set into subclass, then we will use Class Hierarchies. Class Hierarchies. name. lot.

874 views • 58 slides

Mapping from E-R Model to Relational Model

1.58k views • 36 slides

E-R Model to R elational Model

E-R Model to R elational Model. E-R Model to R elational Model. Entity Sets to Tables Main Idea Each entity set maps to a new table Each attribute maps to a new table column Each relationship set maps to either new table columns or to a new table.

408 views • 26 slides

CONCEPTS OF E-R MODEL

CONCEPTS OF E-R MODEL. CONTENTS Entity Attributes Data Value Entity Types Types of Entity Types Relationships Relationship Constraints. Entity

360 views • 24 slides

Chapter 3: The Enhanced E-R Model

Modern Database Management. Chapter 3: The Enhanced E-R Model. Define terms Understand use of supertype/subtype relationships Understand use of specialization and generalization techniques Specify completeness and disjointness constraints

711 views • 31 slides

E-R MODEL

Entity-Relationship and Enhanced Entity-Relationship Conceptual Data Models (Chapters 7 & Sections 2.1 to 2.3). E-R MODEL. E-R model is based on a real world that consists of entities and relationships. It consists of two primitives:

257 views • 23 slides

The Enhanced E-R Model

The Enhanced E-R Model. Objectives. Define terms Understand use of supertype/subtype relationships Understand use of specialization and generalization techniques Specify completeness and disjointness constraints Develop supertype/subtype hierarchies for realistic business situations

322 views • 29 slides

More Related