Download

1 / 61

Understanding the E-R Model in Computer Science

Nov 26, 2025

610 likes | 749 Views

Explore the Entity-Relationship Model by Prof. Sin-Min Lee, covering essential concepts in computer science. Learn about entities, relationships, attributes, and more. Enhance your database design skills with this comprehensive guide.

Share Presentation

Embed Code

Link

er model
computer science
entities
relationships
attributes
database design
prof sinmin lee

chrissy

Download Presentation

Understanding the E-R Model in Computer Science

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

652 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:

506 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.09k 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).

391 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

563 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

220 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

922 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.

760 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

655 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

629 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.

896 views • 58 slides

Mapping from E-R Model to Relational Model

1.6k 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.

418 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

377 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

772 views • 31 slides

E-R MODEL

Entity-Relationship and Enhanced Entity-Relationship Conceptual Data Models (Chapters 7 &amp; 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:

274 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

330 views • 29 slides

More Related