Database Program Translation - Information Systems Reengineering, Integration and Normalization - page 196

SUPPLIER
SUPPLIER_ID SUPPLIER_NAME ADDRESS

S1
S2
S3
S4

John's Co.
Michael Lee
Jack's Stare
Michael Lee

32 Ivy Road
61 Clark Road
90 Dicky Road
61 Clark Road

PART
PART_ID

PART_NAME

P1
P2
P3

Sugar
Orange Juice
Beer

P4 Chocolate

ITEM
S UPPLIER_ID

P ART_ID UNIT_PRICE

S1
S2
S3

P1
P3
P1

4
6
5

SUPPLIER_ID, PART_ID together will be used as secondary indices in the net-
work schema. The network schema has also been converted to a relational schema
as follows:

Relation SUPPLIER ( SUPPLIER_ID , NAME, ADDRESS)
Relation PART ( PART_ID , PART_NAME)
Relation ITEM ( SUPPLIER_ID , PART_ID , UNIT_PRICE)

We can thus write an embedded-SQL program with two SQL statements (Select
and Insert) to access the translated relational schema as follows: