Title: IDEF1X Integrated Definition 1, Extended
1IDEF1X (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
2IDEF1X vs. Extended E-R
3IDEF1X 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
4IDEF1X 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
5IDEF1X 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
6IDEF1X 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
7IDEF1X 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)
8IDEF1X 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
9IDEF1X 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