IDEF1X Integrated Definition 1, Extended - PowerPoint PPT Presentation

1 / 9
About This Presentation
Title:

IDEF1X Integrated Definition 1, Extended

Description:

IDEF1X narrows the definition of entities, attributes, and relationships. IDEF1X adds the notion of domains which is not present in the E-R model ... – PowerPoint PPT presentation

Number of Views:188
Avg rating:3.0/5.0
Slides: 10
Provided by: webNp
Category:

less

Transcript and Presenter's Notes

Title: IDEF1X Integrated Definition 1, Extended


1
IDEF1X (Integrated Definition 1, Extended
  • IDEF1X narrows the definition of entities,
    attributes, and relationships
  • IDEF1X adds the notion of domains which is not
    present in the E-R model
  • IDEF1X introduces new symbology and hierarchy of
    views

2
IDEF1X vs. Extended E-R
3
IDEF1X RELATIONSHIPS
  • Non-Identifying Connection Relationship
  • Equivalent to HAS-A relationships in E-R (11 or
    1N)

DEPARTMENT
FURNITURE
A DEPARTMENT is not required to have any
FURNITURE, but every piece of FURNITURE must
belong to one, and only one, DEPARTMENT.
DeptName
SerialNumber
BudgetCode OfficeNumber
Type Size Material
Default relationship is 1N as shown above
DEPARTMENT
FURNITURE
1N
4
IDEF1X RELATIONSHIPS
  • Non-Identifying Connection Relationship

DEPARTMENT
EMPLOYEE
A DEPARTMENT must have at least one, and can have
many, EMPLOYEEs, but an EMPLOYEE need not belong
to a DEPARTMENT.
DeptName
SSN
BudgetCode OfficeNumber
Name Phone JobCode
p
If Child entity is required, then add P if
Parent optional, add diamond
DEPARTMENT
EMPLOYEE
1N
5
IDEF1X RELATIONSHIPS
  • Non-Identifying Connection Relationship

BADGE
EMPLOYEE
An EMPLOYEE must have one, and only one, BADGE
and a BADGE belongs to one, and only one,
EMPLOYEE.
BadgeNumber
SSN
IssueDate IssuedBy
Name Phone JobCode
1
11 Relationship
BADGE
EMPLOYEE
11
6
IDEF1X RELATIONSHIPS
  • Non-Identifying Connection Relationship

COMPUTER
EMPLOYEE
SerialNumber
SSN
An EMPLOYEE may have zero or one COMPUTER, and a
COMPUTER need not belong to any EMPLOYEE.
Make Model DiskCapacity
Name Phone JobCode
Z
01 Relationship
COMPUTER
EMPLOYEE
11
7
IDEF1X RELATIONSHIPS
  • Identifying Connection Relationship
  • Same as an ID-Dependent relationship in Extended
    E-R

OFFICE
BUILDING
OfficeNumber BuildingNumber NetPortNumber PhoneNum
ber MaxCapacity
BuildingNumber
A BUILDING may be connected to 0, 1, or many
OFFICES an OFFICE must be associated with a
BUILDING.
ReceptionPhone NumFloors ParkingLot
1N Relationship
BUILDING
OFFICE
1N
Note Parent cannot be optional (P)
8
IDEF1X RELATIONSHIPS
  • Non-Specific Relationships
  • Many-to-many (MN) relationship

COURSE
STUDENT
CourseId
StudentId
A COURSE may have many STUDENTs and a STUDENT may
enroll in many COURSEs.
CourseName Credits
StudentName Curriculum
MN Relationship
COURSE
STUDENT
MN
Note IDEF1X cannot represent min cardinalities
for MN
9
IDEF1X RELATIONSHIPS
  • Categorization Relationships
  • Generalization/subtype relationship in Extended
    E-R

EMPLOYEE
SSN
Name Phone JobCode
Z
Z
JobCode
Z
Z
Z
Z
Z
TECH_WRITER
PQA_ENGINEER
PROGRAMMER
STAFF
MANAGER
LevelCode LastBonus
HourlyRate VacationDays
Title Language OS
YearsExperience
YearsExperience Language
Write a Comment
User Comments (0)
About PowerShow.com