Skip to main content

The Data Model Resource CD, Volume 1: A Library of Universal Data Models for All Enterprises, Revised Edition

The Data Model Resource CD, Volume 1: A Library of Universal Data Models for All Enterprises, Revised Edition

Len Silverston

ISBN: 978-0-471-38828-9

Mar 2001

Select type: DVD

In Stock

$350.00

Description

This CD-ROM, a companion to Len Silverston's The Data Model Resource Book, Revised Edition, Volume 1, arms you with a powerful set of data models and data warehouse designs that you can use to jump-start your database development projects. It will save you countless hours and thousands of dollars in database development costs by providing the SQL code you'll need to implement the models described in the book or reverse-engineer them into your CASE tool.

You'll get actual proven models for such common business functions as ordering and managing products, handling shipments, invoicing, accounting and budgeting, managing human resources, contact management, and project management. Plus, you'll find new and expanded models for call center management, product customization, shipping and receiving, payments and collections, budgeting scenarios, and employee qualification and performance. New data mart designs are also provided in this revised edition, including financial analysis, inventory management, and shipping logistics.

You'll also want to check out The Data Model Resource Book, Revised Edition, Volume 2 (0-471-35348-5), and its companion data model sets (each sold separately), which feature universal data models tailored to various industries and applications. A free demonstration of the Volume 2 Data Models is available on this CD-ROM product.

Minimum System Requirements:
32-bit operating system such as Windows 95, Windows NT 4.0 or higher.

Hard Drive Space:
25 MB required space for installation of files.

Peripherals:
CD-ROM drive. You also will need to have the following applications to make full use of the CD-ROM: a browser such as Microsoft Internet Explorer to open the readme.htm and navigate the demo; Visio 2000 required to view the images of the models in native format, although they can alternatively be viewed as JPEGs in a browser or another application.
ChapterPageDetailsDatePrint Run
CDCD Error with "description" field
REASON should have the "description" field as an attribute and not part of the primary key.

CDCD Error with key for ORDER_ITEM_ROLE
ORDER_ITEM_ROLE does not contain the order_item_seq_id as part of its key. ORDER_ITEM_ROLE should contain the order_item_seq_id as part of its key.

CDCD Error: Missing attributes for AGREEMENT
AGREEMENT table should have a "description" and "from date" attributes. Add "description" and "from date" attributes to AGREEMENT.

CDCD Error with relationship from ORDER ROLE to ORDER ITEM ROLE
Relationship from ORDER ROLE to ORDER ITEM ROLE is incorrect and should be moved. Was changed to a relationship from ORDER ITEM to ORDER ITEM ROLE.

CDCD Error with relationship with INTERNAL ACCTG TRANS
INTERNAL ACCTG TRANS should be related to INTERNAL ORGANIZATION and not PARTY ROLE. INTERNAL ACCTG TRANS should be related to INTERNAL ORGANIZATION and not PARTY ROLE.

Visit these related products by Len Silverston

For more information about this and the author's other data model products, visit this site.