Schemas Integration - Information Systems Reengineering, Integration and Normalization - page 287

Attribute class

Attribute name Class name Method

name

Attribute
type

Default
value

Cardinality Description

Customer Cust_ID String Superclass key

attribute

Customer Customer_

Name

String Attribute

Customer Date Date Attribute

Customer Account # String Attribute

Local Customer Address String Attribute

Oversea
Customer

Contact_
Person

String Attribute

Car Loan
Customer

License # String Attribute

Home Loan
Customer

Phone_
Number

Numeric Attribute

Car Loan Loan_Con-

tract #

String Key attribute

Car Loan Duration Integer 1 Attribute

Car Loan Start_Date Date Attribute

Car Loan Loan_Status String Attribute

Mortgage Loan_Con-

tract #

String Key attribute

Mortgage Begin_Date Date Attribute

Mortgage Mature_

Date

Date Attribute

Mortgage Status String Attribute

Constraint class

Constraint_
Name

Method_
Name

Class_
Name

Parameters Ownership Event Sequence Timing

Del_Cust Customer Delete_

Customer

Cust_ID Self Delete Before Repeat

Ins_Local Local

Customer

Insert_
Local

Cust_ID Self Insert Before Repeat

Del_Local Local

Customer

Delete_
Local

Cust_ID Self Delete Before Repeat

Ins_Over-
seas

Overseas
Customer

Insert_
Overseas

Cust_ID Self Insert Before Repeat