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

Method class

Method_
Name

Class_
name

Parameter Seq_no Condition Action Description

Delete_
Customer

Customer @Cust_ID If (Select * from

Local_Customer
where Cust_ID = @
Cust_ID) then call
Del_Local
If (Select * from
Oversea where
Cust_ID = @
Cust_ID) then
Delete Oversea_
Customer(Cust_ID)

Delete Cus-
tomer (@
Cust_ID)

Insert_
Local

Local
Customer

@Cust_ID If (Select * from

Oversea_Customer
where Cust_ID = @
Cust_ID) = null

Insert
Local_Cus-
tomer (@
Cust_ID)

Delete_
Local

Local
Customer

@Cust_ID If (Select * from

Car_Loan_Cus-
tomer where
Cust_ID = @
Cust_ID) then
Delete Car_Loan_
Customer(Cust_ID)
If (Select * from
Home_Loan_Cus-
tomer where
Cust_ID = @Cust_
ID) then Delete
Home_Loan_
Customer(Cust_ID)

Delete
Local_Cus-
tomer (@
Cust_ID)

Insert_
Oversea

Overseas
Customer

@Cust_ID If (Select * from

Local_Customer
where Cust_ID = @
Cust_ID) = null

Insert Over-
seas_Cus-
tomer (@
Cust_ID)

7.5 Schemas Integration for XML Documents

We need to integrate XML schemas before we integrate XML documents because
the integrated XML document must be compatible with the data structure of the
integrated XML schemas. Since XML schema is in tree structure which is top-down
from root parent element to branch child subelements, in a fan out one-to-many
structure. Furthermore, XML schema can use pointers to link associated elements
together. For example, we can implement many-to-many cardinality data semantic
by creating three sibling elements such that a middle sibling element pointing to