idef1x (integrated definition 1, extended idef1x narrows the definition of entities, attributes,...

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

IDEF1X vs. Extended E-R

Extended E-R IDEF1X RemarksEntity Entity Same

Attribute Attribute Same

Relationship Relationship Same

1:1 and 1:N Relationship

Non-Identifying Connection Rel’ship

HAS-A

M:N Relationship Non-Specific Rel’ship

ID-Dependent Rel’ship

Identifying Rel’ship

Weak Entity, ~ID-Dep

None

Supertype Entity Generic Entity IS-A

Subtype Entity Category Entity Categories are mutually exclusive

None Domain

IDEF1X RELATIONSHIPS

Non-Identifying Connection RelationshipEquivalent to HAS-A relationships in E-R (1:1 or 1:N)

DeptName SerialNumber

BudgetCodeOfficeNumber

TypeSizeMaterial

DEPARTMENT FURNITURE

DEPARTMENT FURNITURE1:N

A DEPARTMENT is not required to have any FURNITURE, but every piece of FURNITURE must belong to one, and only one, DEPARTMENT.

Default relationship is 1:N as shown above


Non-Identifying Connection Relationship

DeptName SSN

BudgetCodeOfficeNumber

NamePhoneJobCode

DEPARTMENT EMPLOYEE

DEPARTMENT EMPLOYEE1:N

A DEPARTMENT must have at least one, and can have many, EMPLOYEEs, but an EMPLOYEE need not belong to a DEPARTMENT.

If Child entity is required, then add P; if Parent optional, add diamond

p



BadgeNumber SSN

IssueDateIssuedBy

NamePhoneJobCode

BADGE EMPLOYEE

BADGE EMPLOYEE1:1

An EMPLOYEE must have one, and only one, BADGE and a BADGE belongs to one, and only one, EMPLOYEE.

1:1 Relationship

1



SerialNumber SSN

MakeModelDiskCapacity

NamePhoneJobCode

COMPUTER EMPLOYEE

COMPUTER EMPLOYEE1:1

An EMPLOYEE may have zero or one COMPUTER, and a COMPUTER need not belong to any EMPLOYEE.

0:1 Relationship

Z


Identifying Connection RelationshipSame as an ID-Dependent relationship in Extended E-R

BuildingNumber

ReceptionPhoneNumFloorsParkingLot

BUILDINGOFFICE

BUILDING 1:N

A BUILDING may be connected to 0, 1, or many OFFICES; an OFFICE must be associated with a BUILDING.

1:N Relationship

OFFICE

OfficeNumberBuildingNumberNetPortNumberPhoneNumberMaxCapacity

Note: Parent cannot be optional (“P”)


Non-Specific RelationshipsMany-to-many (M:N) relationship

CourseId

CourseNameCredits

COURSE STUDENT

COURSE M:N

A COURSE may have many STUDENTs and a STUDENT may enroll in many COURSEs.

M:N Relationship

STUDENTNote: IDEF1X cannot represent min cardinalities for M:N

StudentId

StudentNameCurriculum

IDEF1X RELATIONSHIPS Categorization Relationships

Generalization/subtype relationship in Extended E-R

SSNNamePhoneJobCode

EMPLOYEE

LevelCodeLastBonus

HourlyRateVacationDays

TitleLanguageOS

YearsExperience YearsExperienceLanguage

TECH_WRITERPQA_ENGINEER

PROGRAMMER

STAFF

MANAGER

Z

Z

ZZ

Z

ZZ

JobCode

idef1x (integrated definition 1, extended idef1x narrows the definition of entities, attributes,...

Documents