22vcg09

Next Page PreviousPage Zoomin Zoom Out Exit

Summary Report

Model page 1 - Suppliers and Manufacturers Object Types

Supplier(code-) [ varchar 10 ]

□    Supplier is a supertype of "Manufacturer"

SupplierName string [ varchar20 ]

Discount(%+) [ float ]

Level($+) [ double ]

Days number [ integer ]

City(name-) [ varchar30 ]

Product(code-) [ varchar 15 ]

□    Product is a supertype of"Scanner, Software, Printer"

Manufacturer(code-) [ varchar 10 ]

□    Manufacturer is a subtype of Supplier

□    subtype description "Supplier that is manufacturer"

ProductKind(code-) [ varchar 10 ]

Fact Types

Supplier(code) has SupplierName

Every Supplier has at least one SupplierName Each Supplier has at most one SupplierName Each SupplierName has at most one Supplier that has it.

Supplier(code) provides ratę Discount(%) for Level($)

<l I

Each Supplier, Level combination occurs with at most one Discount.

Page 1

=1

►r¹