EBK USING MIS
EBK USING MIS
10th Edition
ISBN: 8220103633635
Author: KROENKE
Publisher: YUZU
Question
Book Icon
Chapter 5, Problem 5.3UYK
Program Plan Intro

E-R model:

  • It is a tool for creating data model.
  • It is used for developers to describe the content of data model by using two functions called entities and relationships.

Entity:

  • It helps the user for tracking something in database.
  • Example entities in student database system are Student, Grade, Course, etc.

Relationships:

  • Entities have relationships among each other.
  • For example, in student database, a Student has a relationship to Major and Student has a relationship to Advisor.

Attribute:

  • It used to describe the entity characteristics.
  • Example attributes of student entity is Student_id, Student_name, Student_address, etc.

Identifier:

  • It is an attribute or group of attribute, but its value is related with one and only one entity instance.

Example of E-R diagram:

EBK USING MIS, Chapter 5, Problem 5.3UYK

Blurred answer
Students have asked these similar questions
Using R language
Using R language
Using R language
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning